This Analytics Edge report lets you see how new content is performing in Google search, or when old content starts appearing again.
It also includes the number of days that the page appeared in search and uses that to remove pages that made short ‘guest appearances’.
Creating the report with Analytics Edge
Download the example workbook: coming soon…
The Macro
The Analytics Edge macro starts with the Google Search Analytics query (image), pulling date, page and clicks for the reporting period.
Filter is used to remove the zero-click rows, then Duplicates combines the rows by page keeping the sum of the numeric columns and the earliest date (image).
Arrange renames the columns as desired for the report, and Sort and Filter reorder and remove the rows with few Count of Days.
The WriteToWorksheet function then commits the results to the worksheet.
Search Analytics query
Duplicates get sum of numbers and earliest date
Arrange renames the columns
This report shows how just a few simple wizard functions can produce an analysis that would be very difficult to produce with native spreadsheet functionality.
Analytics Edge makes it possible in a few minutes with no formulas or programming.