GAGetMetrics
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTU
1
KeyValueNotes
2
metricsga:entrances,ga:bounces,ga:avgTimeOnPage,ga:pageviews,ga:uniquePageviewsrequired
3
dimensionsga:pagepath
4
filters
5
segment
6
idsga:nnnnnrequired - the profile id
7
sort-ga:pageviews
8
start-date01/07/2011required
9
end-date14/01/2012required
10
start-index11 or more
11
max-results250
12
targetSheetNameResults20180121sheet will be created if doesn't exist
13
startRow1Where 1st row of data will be placed on target sheet - integer
14
startCol1Where 1st column of data will be placed on target sheet - integer
15
showParamsTRUEShow the query parameters with the results
16
17
18
19
This code no longer works due to changes in authentication requirements for the analytics API
20
Please use http://blog.littledata.co.uk/2014/04/pulling-google-analytics-into-google-docs-automated-template-driven-reporting/
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
Loading...
 
 
 
_settings
examples