Label keywords with organic rank data
This is a rare occasion where we will talk about SEO a little. Not usually our thing. We’re all about PPC. This script lets you label keywords based on organic rank data, which means you can see how SEO is affecting PPC. I guess it’s good to know. But PPC is the king, don’t forget it.
How does it work?
Fill out a Google Docs spreadsheet with the organic positions of your site and a few competitors, and this script will label up any matching keywords in your account with those positions. This means it’s easy to analyse how SEO is affecting your PPC performance!
How do I use it?
- First set up a new Google Docs spreadsheet, and set up Sheet1 like this:
- The first row is the headers – fill in your name and your competitors’ names.
- Then the first column is the keyword text, followed by the organic positions of the sites.
- If given this sheet, the script will label the keyword ‘search query’ with ‘Us – 3’, ‘Competitor 1 – 1’ and ‘Competitor 2 – 6’.
- If a position is blank or over 9, the script will assume that means the site was not on the first page of results: the keyword ‘keyword’ would be labelled with ‘Us – Off First Page’, ‘Competitor 1 – 6’ and ‘Competitor 2 – Off First Page’
If you want to do a before/after analysis, you could put in your current ranks and previous ranks, like this:
- Then go to your AdWords account and copy and paste in the script below. There are a few settings to change:
- spreadsheetUrl is the URL of your spreadsheet.
- Use campaignNameContains and campaignNameDoesNotContain if you only want to label keywords in some campaigns.
- Set includePaused to true if you want to label paused keywords, in paused ad groups and campaigns.