Get Quick Insights From Your Forager Report
Now that the early adopters are starting to receive their Forger reports, I thought it would be a good time to offer some quick tips on how to transform that raw data into interesting insights.
Pivot Tables Are Your Friend!
If you’re not used to using them, don’t worry. These will be relatively simple.
- Open a new tab
- Insert > Pivot Table > From Table/Range
- Specifically select the top-left first cell.
- Scroll all the way to the very last bottom-right cell
- Shift-click to select the whole table.
- That’s it!
Counting the Number of Times a Company Appears in the Job Detail View
This quick and easy pivot table will show you how often you and your competitors show up in those blue buttons in the Job detail panel:
All we need to do here is drag the “Apply Link.text” to both the Rows and the Values fields (See Figure 1). That will give you the list of all the companies in those buttons as well as a count of how many times they appear (See Figure 2.) That’s it!
See Where Each Company Ranks for Each Search Result
I love this report because of how it makes it easy to visualize the rankings, and we get to use more of the data fields available to us. This time your fields should look like Figure 3. In Figure 4 below we can see a snippet of the output for one posting. As promised, it shows how each company’s button ranks within that specific job detail view. I love it!
Seriously, these reports take seconds to create and will provide views you’re company has never seen before.
If you haven’t gotten data of your own yet, head on over to the Forager page, create an account or just run an ad hoc report. Get it while it’s free!
Thanks again everyone! Good luck out there!