LittleData template Google API reporting 1
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRS
1
SettingValueExplanationUsed in
2
profilega:ViewID referenced by all templateShowMetric on the example template, from the view admin page or query explorer. In the form ga:1234567Template reference
3
startDate24/02/2014Template reference
4
endDate02/03/20147Days in periodTemplate reference
5
previousStart17/02/20147Previous period starts N days beforeTemplate reference
6
previousEnd23/02/2014Template reference
7
templateSheetNameexample template - general reportName of the template sheetScript reference
8
templateStartCellH1Where the code starts copying the template sheet (place values used in the report, but not appearing on the report, to the left or above this cell)Script reference
9
targetSheetNameReport-20140302Name of the report sheetScript reference
10
targetCellA1Cell to start in on the target sheet - if you want to add to an existing report, make sure this is under existing dataScript reference
11
reportTitleSite weekly metricsReferenced in H1 on example templateTemplate reference
12
modecopy templatecopy template is the 'normal' mode, 'add rows' can be used if you have a regular report that adds a new row each week - will ignore the targetCell settingScript reference
13
currencyFormat£#,##0Script reference
14
Format for queries, place the following on template sheet:
= templateShowMetric(profile, metric, startdate, enddate, dimensions, segment, filters, sort, maxresults)
15

16
17
18
19
20
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
example template - general report
example template - row report
Rows example report