MARKETING How I analyse search terms (Google Ads paid search)

[Andy Black]

This is how I often analyse search terms (or keyword data from the Google Keyword Planner).

I'm looking for common ways people search so I can create campaigns around them, and add negative keywords.

(Note that Google Sheets run out of steam faster than Excel does. When I want to analyse a lot of search terms I do it in Excel.)

Anyway...

Create a report like this, and download the data:



Make a copy of this Google Sheet HERE.

Clear the data I have in it and add your own data.
Make sure the formulae go down far enough in case you've added more data than I had.

Add words you're interested in categorising by.




Now look at the pivot-tables in the other tabs:




Oh, and I never run ads on search partners. You may want to add a column for network if you do.

 

Dislike ads? Become a Fastlane member: Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)

[Andy Black]

GZO:

O dsievif vjot vjsief cideati @CobzFef etlif op epuvjis vjsief:

Fuit ov fu pihevowi lizxusft?

Vjot nuspoph, O dsievif e Huuhmi Fud xovj vji ecuwi optvsadvoupt, epf qutvif ecuav ov vu MoplifOp:

http://jvvqt://xxx.moplifop.dun/qut...uhmi-tjiivt-edvowovz-7237380331497017345-WhCA

16 nopavit mevis epf vxu qiuqmi jewi emsiefz etlif ni vu tjesi vji Huuhmi Tjiiv.




IFOV: Guas juast mevis epf O dep'v liiq aq! (Dmodl vu tii qsuhsitt aqfevi op nz Gohasoph Uav MoplifOp vjsief)