Tools & Automation
Overview
Tools, scripts, spreadsheets, and resources for internal client management – mostly for Google Ads.
Links below either go straight to file or to a page with notes & instructions
Management
Budget Automation: Automate budget adjustments throughout the month for a single account
Budget Cap Script: Pause campaigns when they surpass their monthly budget
Single Campaign Budget Cap Script: Quick script to pause single Campaigns with certain naming conventions when they surpass any fixed budget
MCC Budget Cap Script: Same as above but across accounts in the same MCC.
Quick Responsive Search Ad Builder: Pulls all unique Headlines & Descriptions from every Ad Group into Editor-friendly RSA upload doc
Exact Match Close Variant Prevention: Automatically add Exact (Close Variant) Search Queries as Ad Group-level Negatives
Google Ads N-Gram Analyzer: Analyze Search Query-based Words & Phrases To Identify New Potential Keywords/Negatives
Search Query Review Sheet: Sheet tool to filter in potential New Keywords & Negatives based on a set of adjustable metric-based criteria. Automated Negative Keyword review.
Broad Match Modifier Update: Update BMM to Phrase Match In Bulk Across Accounts, Label, And Monitor Both As They Continue Forward Into This Brave New World!
Google Ads Launch Checklist: Quick Checklist For Launching Accounts & Campaigns.
Monitoring
Google Ads MCC URL Check: Keep an eye on the Final URLs in your MCC's accounts to catch 404s before ads are disapproved!
Google Ads MCC Spend Check: Monitor For Accounts Without Spend & Get Email Alerts Every X Hours No Spend Has Occurred.
Internal Auditing
Internal Account Audits: Quick Insights & Checklist for new accounts. View report and set the GA & AW Account selectors to review data
Campaign Build
Camp Campaign Keyword Builder: Quickly put together comprehensive Keyword Sets for any camp
Ad Matrix Generator: Build out a quick matrix for client review using editor-friendly Keyword & Ad Lists
Ad Matrix Unzip: Takes the above Matrix structure & reformats all contents into Ads-Editor-Friendly Output for Copy & Paste
Updated Ad Matrix Unzip (Responsive Search Ads): Same as the tool above, but updated to accommodate RSA structures.
Keyword Concatenation: Same as found.co.uk's tool but output is automatically broken into distinct Ad Groups for Ads Editor upload
Ad Schedule Uploader For Ads Editor: Create a quick framework & customize bids for all Campaigns by Pasting 'Output' Tab into Editor
Quick Facebook Campaign Uploader: Build a set of ads & iterate them over multiple ad groups. Copy & paste with Facebook Ads' Import tool
Ad Extensions Upload Template: Templated sheet for quick Ad Extension build and upload through Google Ads Editor
Sitelink Creation Assistant: Quickly pull top-visited pages on the site with Google Analytics. Use their titles & meta descriptions for sitelinks.
Ad & Keyword Creation Template: Just a quick sheet template for organizing Keywords & writing Ads.
Campaign Tracking Templates: ValueTrack parameters don't allow Campaign Names to be dynamically set – this script will do the trick!
Research & Info
Weather-Based Performance Reporting: Log weather data for your client's zip code & merge with performance data in GDS
Incomes & Zip Code Data: Government Index of Incomes by Zip Code. Data > Create Temporary Filter View To Sort...Or Download CSV
Zip Codes Within Radius By Income: Get a full list of Zip Codes within any radius of a specified Zip & filtered by Household Income (see above).
General Negative Keyword List: List of universal Negative Keywords for Google Ads. Review before implementing!
Dynamic Keyword Insertion Stats: Performance overview for DKI in Google Ads Headlines
Statistical Significance Calculator (Google Sheet): Copy into any spreadsheet & link cells to results to report on Statistical Significance of A/B test
Audience Performance Measurement: Compile audience data from all Campaigns/Ad Groups within an account in this GDS report
COVID-19 Stats: View report & build your own using Google Sheets & Google Data Studio. Data from CDC.gov.
Reporting
Google Ads Reporting Scripts: A set of script templates for downloading data/uploading changes to Google Ads.
Google Analytics Data Sheet: Download & Schedule Reports Through The Universal Analytics API Using This General Purpose Spreadsheet Template
Google Analytics 4 Data Sheet: Download & Schedule Reports Through The GA4 API Using This General Purpose Spreadsheet Template
Ad Copy Analysis Report: Script & Sheet Combo To Review Ad Performance By Headline, Description, URL & More!
Google Sheet JSON Data Import Sample: Simple example demonstrating how to import JSON data from an API into a Google Sheet
CallRail Reporting Sheet: Google Sheet script for adding call data from the CallRail API into a Google Sheet.
Capterra Ads Reporting Sheet: Google Sheet script for adding Capterra click data into a Google Sheet via the API.
Sitemap Import, Labelling, And Performance: Import A Site's Sitemap & Evaluate Performance Via Google Analytics
Quora Ads Reporting Script For Google Sheets: Import data from Quora Ads via API connection to Google Sheet.
Google Ads Experiment Reporting: Script & Sheet To Provide Overview & Statistical Significance Test For Campaign Experiments.
Data Studio Google Ads Experiment Reporting: GDS & Google Sheet Template for reporting on ongoing Google Ads Experiments.
Google Ads Conversion Upload Format Assistant: Quick formatting doc to ensure that all values are ready for upload.
General Tools
Google Apps Script Progress Bar Template: Just a quick template to add an artificial progress bar to a script.
Simple Character Counter Tool: Count the number of words/characters entered into a text box.
Simple URI Encode/Decode Tool: Quickly Encode/Decode URIs entered into a text box.
Simple Capitalization Converter Tool: Quickly update capitalization of text inputs.
UTM Generator: Quickly put together UTMs for campaign tracking.
Google Docs Resize All Images: Quickly resize all images on a Google Doc to a uniform width with this Google Apps Script