Mini Campaign Builder Script
Need to quickly build a campaign or add keywords to an existing one? This script will do the work for you!
All you need to do is input a few keywords and headlines in a spreadsheet and BAM! You’ve got yourself the beginnings of a great campaign.
If you’re a fan of Single Keyword per Ad Group (SKAG) structures, you’ll know that it’s a pretty time-consuming endeavour. But the payoff is worth it, as it increases ad/keyword relevance and therefore improves quality score, making CPCs cheaper with a higher ad rank and a better CTR.
This script is a mini version of our Campaign Builder tech that we use in-house. If you just need a couple of new keywords after updating your site with new content, for example, it provides a quick and easy way to update your campaigns with SKAG structure.
What’s included?
How does the script work?
This tool will save a lot of time with small-scale builds where you know exactly which keywords and ad copy you need, for example when you’re adding a few keywords to an existing campaign.
You input your campaign name, keywords, headlines, descriptions, paths and final URL, and it will output three tabs for you: one with keyword combinations, one with negatives, and ads to upload to Google Ads Editor.
It creates one exact and one broad match modifier campaign and creates a list of keywords as exact negatives in the broad campaign to make sure that search terms that match exactly will go through the exact keyword.
I’m sure you’re dying to give it a whirl, so let’s get cracking!
How do I use it?
Make a copy of the spreadsheet linked below (note: you’ll need to authorize the script to run). You’ll find all the instructions there as a future reminder.
Once you’ve got the spreadsheet ready, input the following:
- The campaign name
- The campaign name delimiter to distinguish between broad and exact campaigns
- Headline 1 (if this cell is not specified, then it will be the same as the keyword)
- Headline 2
- Optionally, headline 3
- Description 1
- Optionally, description 2
- Optionally, path 1 and path 2
- The final URL
- The keywords (you can keep going outside of the box with these!)
You’ll see a handy character counter which will go red if you exceed the character limit. Bear in mind that this tool will assume that you’re using it correctly and so you’ll need to make sure that you’re staying within the limit!
You can also optionally create a second ad variant by choosing the part of your text you want to vary (e.g., headline 2 or description 2) and inputting the copy. Otherwise, just select “None” from the dropdown menu.
Once you’re done, click the gigantic “Go!” Button, and wait for the magic to happen.
It will generate three tabs labelled “Keywords,” “Negatives” and “Ads.” If you want to run the script again with different keywords, make sure you save these tabs elsewhere or rename them to prevent the script from overriding them.
Finally, you can paste these tabs into Editor and update all the relevant settings and adjustments. Job done!