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 Basic, Standard, or Core Add-in with Google Analytics connector
Download the workbook: GoogleAnalytics-FrequencyAndRecency-3-0,xlsx