How many pages appear in search vs how many days do they appear — i.e. their lifespan in search? This Analytics Edge report answers the question.
Profile your website for how frequently your various pages appear in search.
Creating the report with Analytics Edge
Download the example workbook: coming soon…
The Macro
This macro starts with a Google Search Analytics query, pulling pages and impressions. A Duplicates function then counts the dates per page (image).
An Arrange function keeps only the count column and renames it as ‘Days with Impressions’ (image). Duplicates is used again, but this time to get the count of pages per day.
Arrange and Sort prepare the data for the WriteToWorksheet function and the final results are written into the sheet.
Duplicates gets a count of dates per page
Arrange keeps just the count column
Duplicates counts the pages vs days
This report uses a couple of functions to quickly profile your website performance in search with just a couple of wizard-based functions.
Analytics Edge makes it possible without formulas or programming.