Google Analytics Exclude URL Query Parameters Worksheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
1Make a copy of this template1) In the Google Spreadsheets header above, click "File", then "Make a copy"
2
2
Get the Google Analytics Add-on
1) If you don't already have it, from the Add-ons menu, select "Get add-ons..."
2) Search for "Google Analytics", and install the add-on
3
3Input the relevant View ID
1) In the Report Configuration sheet, enter the View ID (highlighted in yellow)
2) If you don't know the View ID:
a) open Google Analytics to the desired View, and look in the URL
b) you should see something like "/a987654w45678p321654/"
c) the portion after the "p" is your View ID
3) Optionally, modify the "Last N Days" value to grab more data
4
4Run the Report
1) From the Add-ons >> Google Analytics menu, select "Run Reports" (click OK if you see an upgrade notice)
2) Wait for it to finish running
5
5
Note which parameters to exclude
1) In the "Unique Query Parameters" sheet, mark "YES" next to each query parameter you'd like to exclude
2) Once you're done, copy the value of the yellow cell
3) Paste this value into the "Exclude Query Parameters" field in your View settings in Google Analytics
6
7
8
9
10
11
12
13
14
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...
Main menu