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 👇 ... for each RT, I'll add another script to list for fun. #ppcchat #MarketingTwitter
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 🤓 unit. Now on with the show.
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: freeadwordsscripts.com/2017/10/limit-…
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: freeadwordsscripts.com/2017/10/limit-…
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: searchengineland.com/brainlabs-scri…
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: searchengineland.com/brainlabs-scri…
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: searchengineland.com/auction-insigh…
Pulls auction insights data into Gsheet for analysis. Understand how competitors positions shift and where to be aggressive. h/t @Brainlabs
Frequency: Monthly
Link: searchengineland.com/auction-insigh…
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: developers.google.com/google-ads/scr…
Bulk Shopping Ad Group Creator provides a way to bulk create ad groups and product groups in existing Shopping Campaigns
Frequency: As needed
Link: developers.google.com/google-ads/scr…
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: gist.github.com/derekmartinla/…
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: gist.github.com/derekmartinla/…
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: evernote.com/pub/narch20020…
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: evernote.com/pub/narch20020…
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: searchengineland.com/automate-your-…
Love in-market audiences? Think keywords are dead. Use this script to help you bid better for in-market audences.
Frequency: Hourly
Link: searchengineland.com/automate-your-…
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: searchenginejournal.com/recover-lost-c…
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: searchenginejournal.com/recover-lost-c…
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: searchengineland.com/adwords-mcc-sc…
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: searchengineland.com/adwords-mcc-sc…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: searchengineland.com/adwords-biddin…
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: searchengineland.com/adwords-biddin…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
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: developers.google.com/google-ads/scr…
16. Export Google Ads Reports into BigQuery (Single Account Script)
Calling all BigQuery nerd. You can use a scrip to get that data from Google Ads into BigQuery.
Frequency: Daily
Link: developers.google.com/google-ads/scr…
Calling all BigQuery nerd. You can use a scrip to get that data from Google Ads into BigQuery.
Frequency: Daily
Link: developers.google.com/google-ads/scr…
17. Search Query Report (Single Account)
Helps you compare SQR data. Still useful for older accounts that has tons of past data to look at.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
Helps you compare SQR data. Still useful for older accounts that has tons of past data to look at.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
18. Declining Ad Groups Report
Keep track of all those ad groups and if performance starts to drop. Great for small teams with tons of ad accounts to manager. Reporting is one of the best use cases for scripts.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
Keep track of all those ad groups and if performance starts to drop. Great for small teams with tons of ad accounts to manager. Reporting is one of the best use cases for scripts.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
19. PageSpeed Insights: Mobile Analysis
We live in a mobile world... not all sites are ready for it. Not the only metrics to look at for a site but it does help give you more data.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
We live in a mobile world... not all sites are ready for it. Not the only metrics to look at for a site but it does help give you more data.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
20. Automate Alpha Beta Campaign Structure Using AdWords Scripts
Help build out those campaigns by a theme and save time!
Frequency: As needed
Link: searchengineland.com/automate-alpha…
Help build out those campaigns by a theme and save time!
Frequency: As needed
Link: searchengineland.com/automate-alpha…
21. Bid Testing
Testing bids is worth it to make sure you don't over pay for a click. Google will take your money...even if you should pay less.
Frequency: Weekly or Monthly
Link: developers.google.com/google-ads/scr…
Testing bids is worth it to make sure you don't over pay for a click. Google will take your money...even if you should pay less.
Frequency: Weekly or Monthly
Link: developers.google.com/google-ads/scr…
22. Store Account Level Quality Score in a Google Spreadsheet
If you care about QS .... worth storing it in a Google sheet? I know @amaliaefowler finds QS helpful on smaller accounts with tighter budgets.
Frequency: Weekly
Link: freeadwordsscripts.com/2013/02/store-…
If you care about QS .... worth storing it in a Google sheet? I know @amaliaefowler finds QS helpful on smaller accounts with tighter budgets.
Frequency: Weekly
Link: freeadwordsscripts.com/2013/02/store-…
23. Check for Disapproved Ads
Don't wait for Google to email or notify you....disapproval of ads is a pain.
Frequency: Hourly
Link: gist.github.com/derekmartinla/…
Don't wait for Google to email or notify you....disapproval of ads is a pain.
Frequency: Hourly
Link: gist.github.com/derekmartinla/…
24. Delete All Disapproved Ads in an Account
Not sure you'd want to run this but you never know. Maybe you do want to delete all disapproved ad in an account.
Frequency: Daily or Weekly
Link: freeadwordsscripts.com/2012/11/delete…
Not sure you'd want to run this but you never know. Maybe you do want to delete all disapproved ad in an account.
Frequency: Daily or Weekly
Link: freeadwordsscripts.com/2012/11/delete…
25. Bid to Impression Share (Single Account)
If your boss/client only cares about impression share. Have I got a Google Ads scrip for you!!! Bid to impression share all day, everyday and twice on Sunday.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
If your boss/client only cares about impression share. Have I got a Google Ads scrip for you!!! Bid to impression share all day, everyday and twice on Sunday.
Frequency: Weekly
Link: developers.google.com/google-ads/scr…
26. Pause All Keywords With No Impressions
How many accounts have you taken over with keywords that get not one bloody impression? Use some script magic and pause them all.
Frequency: Weekly or adhoc
Link: freeadwordsscripts.com/2012/11/pause-…
How many accounts have you taken over with keywords that get not one bloody impression? Use some script magic and pause them all.
Frequency: Weekly or adhoc
Link: freeadwordsscripts.com/2012/11/pause-…
27. Multi Bidder (Single Account)
Multi Bidder offers functionality similar to that of Automated Rules based on a spreadsheet. Managing 100 rules—a difficult task in Google Ads—becomes a lot easier.
Frequency: As needed
Link: developers.google.com/google-ads/scr…
Multi Bidder offers functionality similar to that of Automated Rules based on a spreadsheet. Managing 100 rules—a difficult task in Google Ads—becomes a lot easier.
Frequency: As needed
Link: developers.google.com/google-ads/scr…
28. Pause keywords with low Quality Score
Does what the title says. Get rid of those low QS keywords. Only the best survive ... use at your own risk ;)
Frequency: Weekly
Link: evernote.com/pub/narch20020…
Does what the title says. Get rid of those low QS keywords. Only the best survive ... use at your own risk ;)
Frequency: Weekly
Link: evernote.com/pub/narch20020…
29. TV Schedule Bid Coordination
Pair TV marketing with Google ads. This is almost as good as email and paid ads.
Frequency: As needed
Link: developers.google.com/google-ads/scr…
Pair TV marketing with Google ads. This is almost as good as email and paid ads.
Frequency: As needed
Link: developers.google.com/google-ads/scr…
• • •
Missing some Tweet in this thread? You can try to
force a refresh
