A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||
2 | ||||||||||||
3 | Google Analytics Query Parameter Extractor | |||||||||||
4 | ||||||||||||
5 | Google Analytics View ID | 135727895 | The ID of the View you want to analyse | |||||||||
6 | Start Date | 2020-06-24 | Pick a start and end date of at least 6 months to ensure you collect enough data. If you don't choose a long enough timeframe, you may miss some query parameters | |||||||||
7 | End Date | 2020-11-23 | ||||||||||
8 | Row Limit (Optional) | 5000 | The number of pages returned by the API - 10K is a safe number. Leave blank to return as many as possible. | |||||||||
9 | Rows Returned | 5000 | The number of rows returned if you didn't specify a row limit | |||||||||
10 | Sample Rate Returned | Unsampled | The sample rate from the returned data set if one was applied | |||||||||
11 | ||||||||||||
12 | Instructions | |||||||||||
13 | 1. Add your GA Property View ID above | |||||||||||
14 | 2. Make sure you have the Google Analytics Add-on For sheets: | https://developers.google.com/analytics/solutions/google-analytics-spreadsheet-add-on | ||||||||||
15 | 3. Click Add-ons > Google Analytics > Run Report | |||||||||||
16 | 4. Once your report has run successfully, click the "Analyse" button below to extract all unique queries from your pageview data | |||||||||||
17 | ||||||||||||
18 | ||||||||||||
19 | ||||||||||||
20 | 78 Unique Query Parameters | |||||||||||
21 | ||||||||||||
22 | fbclid,li_fat_id,from,email,message,success,depth,rurl,sp,u,usg,pto,sl,path,mc_cid,mc_eid,edit,hl,prev,t,tl,d19fec43_page,98c4acd2_page,duplicate,ref,to,branch,csId,usId,refd,dl,dt,h,a,tenant,nv,return_url,cs,gtm_debug,hss_channel,projectId,isappinstalled,ie,langpair,oe,code,state,stats,back,p,proposalId,98c4rcd2_page,configurations,q,cd,ct,gl,_sm_pdc,_sm_rid,_sm_byp,admin,hjVerifyInstall,notification_link_uid,zarsrc,url,data,sdata,reserved,invite_token,retryWith,originalResponseCode,edi,studyId,anno,query,source,frzj,debug | |||||||||||
23 | ||||||||||||
24 | ||||||||||||
25 | ||||||||||||
26 | ||||||||||||
27 | ||||||||||||
28 | ||||||||||||
29 | ||||||||||||
30 | ||||||||||||
31 | ||||||||||||
32 | ||||||||||||
33 | ||||||||||||
34 | ||||||||||||
35 | ||||||||||||
36 | ||||||||||||
37 | ||||||||||||
38 | ||||||||||||
39 | ||||||||||||
40 | ||||||||||||
41 | ||||||||||||
42 | ||||||||||||
43 | ||||||||||||
44 | ||||||||||||
45 | Built by | |||||||||||
46 | ||||||||||||
47 |