Juniper (Digital Marketing)

Looking for something else? Click here to navigate to the Digital Marketing home page on Confluence!

Juniper Reporting

In order to cut down on the amount of manual editing that needs to be done in the client sheets every time we run the SEO Quarterly reports, we’ve made a (hopefully temporary) master google sheet that will house all of the google trend data. Every quarter, reps will come to this document and find the relevant formulas to put into the Google Trend Import tab of the client sheet, so that this data auto populates how we need it to work for Ninja Cat.

These formulas are broken up into Regions and Verticals.

Google Trend Import tab Set Up

Here is an example of what the basic template for this tab should look like. You will have column A as the “Week” column. Then columns B - E, with titles “one, two, three, four”. This is how it is mapped into Ninja Cat, so it must match exactly. Row 2 in these columns is where you will be putting the formulas provided below.

In column F, you have “number” with numbers 1-4. You should never need to change this, it’s only for filtering purposes in the report.

Column G is where you will match the keywords with the numbers in Column F. If Column B - “one” - is Motorcycles, you will put Motorcycles first. Unless you are changing what trends you want to show every quarter, then you should also only need to set this up once and never touch it again. Here is a finished tab to show you what that will look like.

In this example “one”/1 is Motorcycles, “two”/2 is ATVs, “three”/3 is Powersports, and “four”/4 is Polaris For Sale.

Now that we have the base tab set up, below are the formulas you will need to plug in to make the data show up in your report. All you need to do is copy and paste.

For generating quarterly reports you will need the following formulas: