ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Configuration OptionsYour Google Analytics Reports
2
Report NameMobile CvRDesktop CvRAvg. Page Load Time
3
View IDInstructions: Make a copy of this speadsheet. Insert Google Analytics View ID in field B3, C3 and D3. Then go to Add-ons, Google Analytics, Run reports. The results will show up on the sheet Rel mCvR below. Check for a period with good site speed and see the Rel mCvR during that period. Compare that to a period of bad site speed and check the Rel mCvR then. By calculating the difference in Rel mCvR, you can see how much more revenue the company earned when Rel mCvR was better. If you want to track this daily, click Add-ons, Google Analytics, Schedule Reports. Email creator [email protected] for questions.
4
Start Date365daysAgo
5
End Dateyesterday
6
Metricsga:transactionsPerSessionga:avgPageLoadTime
7
Dimensionsga:date
8
Order
9
Filtersga:deviceCategory==mobilega:deviceCategory==desktopga:deviceCategory==mobile
10
Segments
11
Limit
12
Spreadsheet URL
13
Skip Report
18
For help with this add-on:https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on
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
101
102
103
104

Follow Lee on X/Twitter - Father, Husband, Serial builder creating AI, crypto, games & web tools. We are friends :) AI Will Come To Life!

Check out: eBank.nz (Art Generator) | Netwrck.com (AI Tools) | Text-Generator.io (AI API) | BitBank.nz (Crypto AI) | ReadingTime (Kids Reading) | RewordGame | BigMultiplayerChess | WebFiddle | How.nz | Helix AI Assistant