This free Excel report includes all the formulas and conditional formatting needed to reproduce the Google Analytics Frequency and Recency reports. Use it as part of your dashboard project! A quick refresh and your website data is presented in an easy-to-understand tabular format, complete with background bar chart-like conditional formatting providing a quick visual reinforcement of the larger numbers.
Requires: Analytics Edge Core Add-in(free license) with Google Analytics connector
Download the workbook: GoogleAnalytics-FrequencyAndRecency-3-0,xlsx