Your browser is no longer supported! Please upgrade your web browser now.

Harvest API: Your Data in Action

Recently Chris Wilson from Search Mojo has been writing to us with questions about the Harvest API. Through the pleasant conversations surrounding Chris’s questions, we learned that Search Mojo was using the API to create an inspiring dashboard. Here’s how Chris describes it:

We created a profitability dashboard to total up which of our clients we are profitable on based on hours, hourly rates and expenses over quarter and month ranges. We then created a score based on that. Your API tool supplied everything and it’s officially up and running on the tvs in the office.


It turns out that they have set up two different dashboards, to keep the clients displayed relevant to the employees who can see the television.

At the top left corner is a score based on profit and retention from quarter to quarter by using Harvest and looking at last time stamps and active/inactive projects. The right hand side queries our other database to show vacation and sick leave.

Now onto the bulk of the system. It lists every client and project (column 1 and column 2 respectively). The next bars (one for monthly and one for quarterly) use Google charts to display graphs which include (hourly rate X each employee) + expense cost. We have 2 dashboards setup for our 2 teams in the office so it only lists their clients. This helps us to review our processes to determine which clients are too demanding and which we need to focus on more. As each employee spends more time the chart grows closer to 100% which means we are using 100% of the budget (or the amount the client is paying us). It turns yellow when between 80-100% and red when above 100% (meaning we are over budget and have allocated too much time), otherwise it’ll show green.

Thank you Chris and the whole Search Mojo team for sharing how you use the Harvest API. Those dashboards are an awesome way to utilize your Harvest data to keep tabs on profitability.

If you have an interesting use of the Harvest API that you would like to share, please let us know!

Thoughts or questions about this post? Need some help?
Get in touch →

This was posted in Code, Success Stories, Time Tracking.
  • We’d love t be able to tie into something like this, but for multiple harvest users (with different accounts) to be able to interact together on shared projects. At CoWork Greenville we often have several members of a project team that are all time tracking with Harvest. This would work wonders when using Coop-app too. FWIW.

  • Nice – great use of the Harvest API! We put up a wallboard that uses the Co-op API and shows who’s working on what (people tracking time are lit up in green).

    http://www.facebook.com/photo.php?fbid=486662241790&set=a.320969776790.158747.285641041790&theater

  • I’d love to use something like this at the office. It would be great if this dashboard was shared, can we find the code somewhere?

  • Karen Schoellkopf on July 3, 2012

    @David You’d have to reach out to the folks at Search Mojo, to see if they’ll share ;)

  • hello all, i was in contact with the developer of search mojo and he was kind enough to share his source code for the dash board solution. however: the code was written in ruby on rails and it took us some time to install a local ruby server and the scripts did not work the way we needed them.

    but: in the meantime i have found another solution to visualize the harvest data, it is called http://eazybi.com/ and comes with some examples for get harvest. this is a business intelligence app / software as a service and the best thing for me is that you do not have to be a developer to use this. just import your getharvest data and then use the drag & drop interface to produce interesting dashboards. i highly recommend this service, also because the developers behind it are providing good support and listen to feature requests.. overall with the helpd of eazybi and the getharvest data i was able to generate great insights (f.x. top clients, uninvoiced hours etc.)

Comments have been closed for this post.
Still have questions? Contact our support team →