ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
View ID90219011
This is the ID of your view in Google Analytics
2
City namePhiladelphia
The name of the city that you'd see in Google Analytics. (These users are bounded by the city limits.)
3
Metro namePhiladelphia PA
The name of the metro that you'd see in Google Analytics. (Bounded by the Neilsen DMA.)
4
5
How to use this report
6
7
1. Make a copy of this spreadsheet.
8
2. Get the Google Analytics Spreadsheet Add-on.
9
3. Update the View ID, City name and Metro name values, highlighted in yellow above.
10
4. Click Add-ons > Google Analytics > Run reports
11
5. You will be prompted re: Google Analytics permissions, grant them.
12
6. Done!
13
7. To automate this report, click Add-ons > Google Analytics > Schedule reports. (Suggestion: every Monday morning.)
14
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.
15
16
For more information on reading this report, etc., please see the accompanying documentation.
17
18
Memberkit 1.0
19
Copyright 2020, WHYY and Colorado Public Radio.
20
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
21
22
23
24
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