7 Day Cohort Analysis

7-day-cohort-analysisThis free Excel report from Analytics Edge works with the free Basic Add-in and Google Analytics connector to mimic the 7-day Cohort Analysis report providedĀ in Google Analytics.

Using embedded queries with dynamic segments, the report shows how many of your new website visitors returned to your site over each of the past 7 days.

Use the report as-is to gauge short term campaign effectiveness, orĀ use the technique in your own custom analysis.

Download the workbook: GoogleAnalytics-7DayCohortAnalysis-1-0.xlsx

A companion Help article shows how to make a 12-Month Cohort Analysis and includes a sample report.