This is the ID of your view in Google Analytics

A Google Analytics API filter to identify daily newsletter subscribers. (See pink box, below.)

A Google Analytics API filter to identify members. (See pink box, below.)

How to use this report

To use this report, you must have custom dimensions set up in your

Google Analytics that identify newsletter subscribers and members.

The dimension number is the same as the number in the GA admin.

The filters match the segment value using operators like these. --->>>

(See the docs for a complete list.)

1. Make a copy of this spreadsheet.

2. Get the Google Analytics Spreadsheet Add-on.

3. Update the view ID, Daily Newsletter dimension and Member dimension, highlighted in yellow above.

4. Click Add-ons > Google Analytics > Run reports

5. You will be prompted re: Google Analytics permissions, grant them.

6. Click Memberkit > Update color coding to color the articles by title for easier cross-referencing.

7. To automate this report, click Add-ons > Google Analytics > Schedule reports. (Suggestion: every Monday morning.)

And then click Tools > Script editor. Once the editor has opened, click Edit > Current project's triggers.

Click the Add trigger button, and set the trigger to run the "go" function every Monday morning.

8. It's a little thing, but once you've got this running, I'd move the "Config" tab all the way to the right. It's ugly.

For more information on reading this report, etc., please see the accompanying documentation.

Copyright 2020, WHYY and Colorado Public Radio.

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.