Thread: Google Ads Scripts that help you with automation & other tasks to scale work and make more
money!
Here is our 7 favourite scripts
... for each RT, I'll add another script to list for fun. #ppcchat #MarketingTwitter

Here is our 7 favourite scripts

One note: Learning to install scripts is a skill y'all should learn. Can take a few tries to get a script working but worth it. My first script in 2013 took 3 tries to work.
Scripts nerds
unit. Now on with the show.
Scripts nerds

1. Negative Keyword Conflict
Tells you when there is a conflict between keywords you are bidding on and those in your campaign/ad group negative keywords (or even in negative keyword lists). Great for accounts of any size.
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/negative-keyword-conflicts
Tells you when there is a conflict between keywords you are bidding on and those in your campaign/ad group negative keywords (or even in negative keyword lists). Great for accounts of any size.
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/negative-keyword-conflicts
2. Limit AdWords Overdelivery
Pauses campaigns when they spend a percent over your daily budget. This is great for helping control ad spend and budgets. h/t @siliconvallaeys
Frequency: Hourly
Link: http://www.freeadwordsscripts.com/2017/10/limit-adwords-overdelivery-to-any.html
Pauses campaigns when they spend a percent over your daily budget. This is great for helping control ad spend and budgets. h/t @siliconvallaeys
Frequency: Hourly
Link: http://www.freeadwordsscripts.com/2017/10/limit-adwords-overdelivery-to-any.html
3. Search Queries Using N-Grams
Pulls search queries from ad accounts into Gsheet. Great for data analysis. We use it to pull shopping campaign search query data and build out more robust search campaigns. h/t @Brainlabs
Frequency: As needed
Link: https://searchengineland.com/brainlabs-script-find-best-worst-search-queries-using-n-grams-228379
Pulls search queries from ad accounts into Gsheet. Great for data analysis. We use it to pull shopping campaign search query data and build out more robust search campaigns. h/t @Brainlabs
Frequency: As needed
Link: https://searchengineland.com/brainlabs-script-find-best-worst-search-queries-using-n-grams-228379
4. Auction Insights aka Competitor Data
Pulls auction insights data into Gsheet for analysis. Understand how competitors positions shift and where to be aggressive. h/t @Brainlabs
Frequency: Monthly
Link: https://searchengineland.com/auction-insights-3-final-script-287148
Pulls auction insights data into Gsheet for analysis. Understand how competitors positions shift and where to be aggressive. h/t @Brainlabs
Frequency: Monthly
Link: https://searchengineland.com/auction-insights-3-final-script-287148
5. Bulk Shopping Ad Group Creator
Bulk Shopping Ad Group Creator provides a way to bulk create ad groups and product groups in existing Shopping Campaigns
Frequency: As needed
Link: https://developers.google.com/google-ads/scripts/docs/solutions/bulk-shopping-ad-group-creator
Bulk Shopping Ad Group Creator provides a way to bulk create ad groups and product groups in existing Shopping Campaigns
Frequency: As needed
Link: https://developers.google.com/google-ads/scripts/docs/solutions/bulk-shopping-ad-group-creator
6. Reviews your GDN placements
If you are going to do GDN. At least use a script to make it happen. Find Underperforming Placements & Opportunities On Google Display Network
Frequency: Hourly
Link: https://gist.github.com/derekmartinla/06e51b8a4298b8bbb8ff
If you are going to do GDN. At least use a script to make it happen. Find Underperforming Placements & Opportunities On Google Display Network
Frequency: Hourly
Link: https://gist.github.com/derekmartinla/06e51b8a4298b8bbb8ff
7. Keyword Labeler - Single Account
Use this script to find under/overperforming keywords. Then take action. You could also set up a rule to help with this task but maybe you want to look at the data first.
Frequency: Weekly
Link: https://www.evernote.com/pub/narch2002002/adwordsscripts#st=p&n=dc96ccb4-a134-487b-a52e-50c57ef29450
Use this script to find under/overperforming keywords. Then take action. You could also set up a rule to help with this task but maybe you want to look at the data first.
Frequency: Weekly
Link: https://www.evernote.com/pub/narch2002002/adwordsscripts#st=p&n=dc96ccb4-a134-487b-a52e-50c57ef29450
8. Automate your in-market audience bidding
Love in-market audiences? Think keywords are dead. Use this script to help you bid better for in-market audences.
Frequency: Hourly
Link: https://searchengineland.com/automate-your-in-market-audience-bidding-with-this-google-ads-script-309574
Love in-market audiences? Think keywords are dead. Use this script to help you bid better for in-market audences.
Frequency: Hourly
Link: https://searchengineland.com/automate-your-in-market-audience-bidding-with-this-google-ads-script-309574
9. Recover Lost Conversions
If you think negative keywords are impacting conversions. Use this script to find out. You can never have to many scripts to fight bad negative keywords. Some people just go ham on negative keywords
Frequency: Hourly
Link: https://www.searchenginejournal.com/recover-lost-conversions-google-ads-script/273393/
If you think negative keywords are impacting conversions. Use this script to find out. You can never have to many scripts to fight bad negative keywords. Some people just go ham on negative keywords
Frequency: Hourly
Link: https://www.searchenginejournal.com/recover-lost-conversions-google-ads-script/273393/
10. MMC Script To Report on Account Performance
Haven't used this one in a while but I do love the idea. See performance across your MMC agency/multi-national peeps
Frequency: Daily
Link: https://searchengineland.com/adwords-mcc-script-will-save-hour-every-day-189499
Haven't used this one in a while but I do love the idea. See performance across your MMC agency/multi-national peeps
Frequency: Daily
Link: https://searchengineland.com/adwords-mcc-script-will-save-hour-every-day-189499
11. Flexible Budgets - Single Account
Help Google spend a fixed budget over X days. Great for short run campaigns. For those brands who love to do short sales ALL THE MOFO TIME!
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/flexible-budgets
Help Google spend a fixed budget over X days. Great for short run campaigns. For those brands who love to do short sales ALL THE MOFO TIME!
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/flexible-budgets
12. Optimize Bids Every Hour Of The Day
If you must and this is totally personal, bid by the hour. Haven't used this one but I know r/ppc is a huge fan.
Frequency: Hourly
Link: https://searchengineland.com/adwords-bidding-thats-4-times-responsive-google-marin-kenshoo-207877
If you must and this is totally personal, bid by the hour. Haven't used this one but I know r/ppc is a huge fan.
Frequency: Hourly
Link: https://searchengineland.com/adwords-bidding-thats-4-times-responsive-google-marin-kenshoo-207877
13. Account Anomaly Detector
If you need a 2nd pair of hands to make sure accounts are on lock down. Lets tech see if something is off across account data or suddenly behaving too differently from what's historically observed.
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/account-anomaly-detector
If you need a 2nd pair of hands to make sure accounts are on lock down. Lets tech see if something is off across account data or suddenly behaving too differently from what's historically observed.
Frequency: Hourly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/account-anomaly-detector
14. Account Summary Report
When a client NEEDS to know what is happening day to day on their account. Automate that report fam... for free. Reporting is the biggest way y'all should be using automation. Frees up your time.
Frequency: Daily
Link: https://developers.google.com/google-ads/scripts/docs/solutions/account-summary
When a client NEEDS to know what is happening day to day on their account. Automate that report fam... for free. Reporting is the biggest way y'all should be using automation. Frees up your time.
Frequency: Daily
Link: https://developers.google.com/google-ads/scripts/docs/solutions/account-summary
15. Ad Performance Report
How are your ads really doing. See past reports and keep the pulse on those ads. Can compare a given headline or final URL performs against others... maybe inspire new ads? ....as long as we have ETAs.
Frequency: Weekly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance
How are your ads really doing. See past reports and keep the pulse on those ads. Can compare a given headline or final URL performs against others... maybe inspire new ads? ....as long as we have ETAs.
Frequency: Weekly
Link: https://developers.google.com/google-ads/scripts/docs/solutions/ad-performance