ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Google Analytics Query Parameter Checker
3
1Make a copy of this template1) In the Google Spreadsheets header above, click "File", then "Make a copy"
4
2Get the Google Analytics Add-on1) If you don't already have it, from the Add-ons menu, select "Get add-ons..." OR Click link below
2) Search for "Google Analytics", and install the add-on
5
Google Analytics Spreadsheet Add-on and further instructions
6
3Enter Your View ID1) Enter your ViewID below, if you don't know the View ID (see instructions below):
7
Enter Your View ID in the Yellow box35156174
8
How to find your View ID:1) Open Google Analytics to the desired View:
a) look in the URL
b) you should see something like "/a987654w45678p321654/"
c) the portion after the "p" is your View ID
2) OR open Admin > View Settings > Look for View ID
9
3*Set Optional Settings
1) Change the Start Date, Row Limit, and more - *optional, modify values within "Report Configuration" Tab (hidden)
10
4Run the Report1) 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
11
5Note which parameters to exclude1) 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
12
6Exclude within Google Analytics1) Paste this value into the "Exclude Query Parameters" field in your View settings in Google Analytics (see picture to the right)
While you are at it:
A - Exclude Bots and spiders from this profile
B - Turn on site seach reporting
C - Enter your search query param (See MashMetrics onsite search guide below)
2) Click Save
13
Other ResourceMashmetrics Google Analytics on-site search guide
14
Other ResourceMashMetrics 2019 Google Analytics Install Checklist and Guide
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