ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
First month to report8/1/2019This is auto-generated to always be 12 months ago, don't change it
2
First month of complete data
January 2019
Enter the month following the day you implemented the custom dimension (if you started gathering dimension data on 4/15/2020, you'd enter 5/1/2020)
3
View ID90219011This is the ID of your view in Google Analytics
4
Dimension number3
This is the number of the 30-day reading custom dimension (find it in your Google Analytics admin)
5
6
How to use this report
7
To use this report, you'll need to set up a custom dimension to track reading frequency. Sadly, that's not a trivial task, but...
8
...we've thoroughly documented how you'd do it, from concepts to code, in this document!
9
And after you've implemented the dimension, you'll need to wait until the beginning of the following month for this to work.
10
11
1. Make a copy of this spreadsheet.
12
2. Get the Google Analytics Spreadsheet Add-on.
13
3. Update the First month of complete data, view ID, and dimension number, highlighted in yellow above.
14
4. Click Add-ons > Google Analytics > Run reports
15
5. You will be prompted re: Google Analytics permissions, grant them.
16
6. Done!
17
7. To automate this report, click Add-ons > Google Analytics > Schedule reports. (Suggestion: every Monday morning.)
18
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.
19
20
For more information on reading this report, etc., please see the accompanying documentation.
21
22
Memberkit 1.0
23
Copyright 2020, WHYY and Colorado Public Radio.
24
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100