The Working Tools Library
The Vault
The Dispatch's working library: Google Ads scripts, GAQL, SEO utilities, GA4 SQL, n8n workflows and AI prompts, tested at the bench and filed for reuse.
Budget Pacing Guardian: know by 9am if the month is drifting
02SQL · FeaturedGA4 BigQuery starter pack: unnest event_params, count users, rank pages
03Script · PopularAccount Anomaly Pulse: compare yesterday with the last four of the same weekday
A read-only Google Ads Script that measures yesterday's cost, clicks and conversions against the average of the same weekday over the previous four weeks, and flags any metric that has drifted past your tolerance.
An Adsscripts.com tool that scans every account under an MCC for negative keywords silently blocking active keywords and search terms.
An open-source Python package for crawling, sitemap and robots.txt analysis, SERP tooling and log-file parsing, all under one pip install.
A community-maintained, continuously updated list of AI crawlers, shipped as drop-in robots.txt, htaccess, Nginx and Caddy files so you can block or allow AI bots in minutes.
An interactive tool that builds tailored AI prompts for SEO and digital marketing tasks, teaching sound prompt construction rather than handing over a canned template.
Anthropic's official repository of Agent Skills, the reusable instruction folders Claude loads on demand, plus the Skills spec and a template for building your own marketing skills.
A curated, continuously updated GitHub collection of free n8n templates spanning marketing, sales, content and operations automation.
Brainlabs Digital's open-source GitHub repository consolidating its published Google Ads scripts into one maintained, version-controlled collection.
A read-only Google Ads Script that compares month-to-date spend with where the month should be, projects the landing figure, and emails you when the pace drifts.
A read-only script that queries the change_event log every few hours and emails you when someone makes a burst of edits or removes a campaign or budget.
A Cloudflare feature, free on every plan, that shows exactly which AI crawlers hit your site and lets you allow or block them per bot with one click.
A free library of AI prompts built from Copyhackers' own conversion-copywriting frameworks, covering voice of customer, value proposition, headlines, and landing pages.
A Google Sheets template that turns a Meta Ads Manager export into hook rate, hold rate and cost per ThruPlay, so creative decisions rest on retention, not gut feel.
The exact columns for a paid-social testing sheet, plus the three decision rules that stop a test being read too early, judged on the wrong number, or forgotten before it teaches you anything.
A dbt package that turns the raw GA4 BigQuery export into report-ready models for sessions, users, ecommerce and attribution.
A read-only Google Ads Script that checks every serving ad for a disapproval or a limited-serving status each day, lists the policy topics behind each one, and optionally emails you the digest.
A read-only Google Ads Script that gathers the final URLs from your enabled keywords and ads, requests each one, and flags any answering 4xx or 5xx into a Google Sheet and optional email.
Three foundation queries for the GA4 BigQuery export: the event_params unnesting pattern, daily users and sessions, and top pages by view, all with a date filter that controls scan cost.
Session-scoped source, medium and campaign reporting from the GA4 BigQuery export, aggregating sessions and conversions per channel, with an honest note on why it will not tie out to the GA4 UI.
BigQuery SQL that audits your GA4 export for unassigned traffic, missing event parameters, possible PII in page URLs and broken purchase revenue before anyone trusts the dashboard.
A BigQuery ecommerce funnel across view_item, add_to_cart, begin_checkout and purchase, counting distinct users per step and the step-to-step drop, using conditional aggregation instead of fragile joins.
Google's free public BigQuery dataset of obfuscated Merchandise Store GA4 events, the standard sandbox for practising GA4 SQL with no live property and no setup cost.
A dedicated tutorial site of example SQL and lessons for querying the raw GA4 BigQuery export, with interviews from the dbt/GA4 ecosystem.
An open-source Dataform package that turns raw GA4 BigQuery export tables into clean session, user and event models, maintained by a team of well-known GA4 analytics engineers.
Pick metrics, dimensions and a date range in a form, and this free tool generates the matching GA4 BigQuery SQL for you.
Four read-only queries that surface disapproved ads, budget-constrained campaigns, the state of your conversion actions and who changed what recently.
Ready-to-run GAQL for creative asset ratings across responsive search ads and Performance Max asset groups, so you can find weak headlines and images in one query set.
A cookbook of Demand Gen GAQL queries that splits spend, conversions, asset ratings and audiences out of the campaign line Google reports as a single figure.
A pack of read-only queries that pull asset-group performance, the listing-group tree and campaign spend out of Performance Max, with an honest map of where the API stops.
A pack of read-only Google Ads queries that surface search terms, keywords, placements and whole campaigns taking budget while returning no conversions.
A read-only Google Ads Script that ranks every location by spend against conversions, writes the worst offenders to a Sheet and optionally emails the wasted-spend list.
A complete Claude Agent Skill, delivered as a SKILL.md file, that walks an agent through a structured Google Ads account audit and names the GAQL resources to pull.
Google's official Google Ads API MCP server, giving an AI agent tools to search accounts and fetch resource data straight from the API, announced on the Ads Developer Blog.
Google's own gallery of ready-made Ads Scripts for anomaly detection, budget management and reporting, installable straight from the Ads UI documentation.
Google Analytics' own MCP server, exposing GA4 report and realtime tools so Claude or Cursor can query your Analytics data directly without writing API glue.
Google's own reference for the Google Ads Query Language, paired with an interactive builder for constructing and validating queries against the current API version.
Google Search Console's own feature that schedules a free daily export of full, unsampled search performance data into a BigQuery dataset you own, past the thousand-row UI cap.
A Google Apps Script that reads Search Console for the last 28 days against the prior 28, computes the click deltas by query and page, and writes Winners and Losers tabs.
Google's official directory of community-built GTM tag and variable templates, web and server-side, that install straight into a container instead of a hand-coded custom HTML tag.
An importable n8n flow that watches your sitemap, spots new or changed URLs and pings IndexNow so Bing and Yandex hear about a page the moment it ships.
A Python script that cross-references your ranking queries against a site crawl to find pages that mention a term but do not yet link to the page ranking for it.
A step-by-step walkthrough of implementing Meta's Conversions API Gateway through Stape, aimed at lifting Event Match Quality without hand-rolling a server.
Paste the page copy and the promise your ad makes, and get a ranked teardown across message match, clarity, evidence, friction and forms, ending with the three fixes to make first.
A public GitHub repository of over 100 Python scripts, Streamlit apps and mini-APIs for keyword research, content analysis, redirect mapping and site migrations.
A ready-to-adapt llms.txt for a content or brand site, with a name line, a short summary, and grouped link sections, plus honest guidance on what to include and what to leave out.
An email framework that pairs Tailwind utility classes with an automated build pipeline, the best fit for teams already on Tailwind who want utility-class email authoring.
An open-source collection of Claude Skills covering CRO, copywriting, SEO, analytics and growth engineering, built by the founder of Swipe Files.
Meta's official public database of every active ad on Facebook, Instagram and Messenger, searchable by advertiser, keyword and country with no login, the baseline paid-social spy tool.
An MCP server that lets an AI assistant manage Meta campaigns end to end, launch, upload creatives, adjust budgets and pull performance, built by a badged Meta Business Partner.
Meta's official Python SDK for the Marketing, Conversions and Pages APIs, the first-party way to pull ads data for custom reporting without a third-party wrapper that breaks on API changes.
Meta's own documentation on implementing the Conversions API correctly and improving Event Match Quality, the baseline every third-party CAPI tutorial is checked against.
A working checklist for Meta pixel and Conversions API signal quality, covering event match quality, deduplication, advanced matching and the consent-mode interaction that quietly zeroes your EU signal.
An importable n8n flow that reads Meta account insights daily, compares yesterday against the trailing week and posts to Slack when spend swings beyond your threshold.
A markup language and compiler that turns semantic tags into bulletproof responsive email HTML, the most established open-source email framework with a deep template ecosystem.
Paste a KPI table with month-on-month and year-on-year columns and get a 250-word narrative of what happened, why, and what comes next, with invented causes forbidden.
A weekly n8n workflow that pulls the last 28 days of Search Console clicks against the 28 before, writes the biggest query winners and losers to a Google Sheet, and emails the top movers.
A free n8n workflow that finds brand-new Search Console queries from the last week and splits them into zero-click and already-clicking, surfacing emerging keyword opportunities daily.
A free n8n workflow that watches the Meta Ads Library for new creatives from named competitors, logs them to a Sheet and alerts on Telegram with just the new-ad count.
A daily n8n workflow that reads your chosen ad-platform news feeds, keeps only the items matching a keyword list, and emails a short digest on the mornings when something actually changed.
A daily n8n workflow that scores Google Ads performance against a rules system, logs it to Sheets, and alerts Slack on wasted spend or scaling openings.
An n8n workflow that fetches Google Ads search terms, has Gemini flag wasted spend and opportunity terms, and posts the sorted list straight to Slack.
An n8n workflow template that pulls Search Console rankings and GA4 organic traffic on a schedule and writes both into a shared Google Sheet.
A daily n8n workflow that fetches your sitemap, compares the URL list against yesterday's run held in workflow static data, and emails you when pages appear or disappear.
A curated index of 400-plus free Google Ads scripts covering bidding, ad testing and reporting, maintained by a dedicated Ads scripting specialist since 2019.
The community's standard script for splitting Performance Max spend and results by channel, with search category and asset group detail written to a Google Sheet.
Resend's unstyled React and TypeScript components for building emails that survive Gmail, Outlook and dark mode, the modern standard for transactional mail in a React codebase.
A dependency-light Python script that matches an old URL list to a new one, exact first then fuzzy, and writes a redirect map plus a list of everything it could not place.
A read-only script that reads responsive search ad asset ratings, lists every headline and description Google has labelled LOW to a Sheet, and never touches the ads.
A prompt that turns a product, an audience and your proof points into responsive search ad assets inside the character limits, with a self-check pass that recounts every length.
The reference tutorial for bulk-checking indexing status through Google's URL Inspection API in the SEO Spider, including working within the 2,000 URLs per day quota.
A free Google Sheets add-on that pulls query, page, device and country Search Console data straight into a spreadsheet, past the UI's export limit, with scheduled backups.
Paste a search terms export and get themed clusters with spend totals, a verdict per cluster, proposed negatives with match types, and the assumptions the model made to get there.
A read-only Google Ads Script that breaks 30 days of search terms into one, two and three word n-grams, ranks the spend that converts nothing, and writes the full table to a Google Sheet.
A free, open-source Google Ads Script that scans placements across Display, Performance Max and Demand Gen and semi-automates excluding the junk, from a maintainer still shipping in 2026.
The community-gallery GTM template for Google Consent Mode, adjusting tag behaviour from the visitor's recorded consent state.
A Google Apps Script that pulls Search Console data into a Sheet and lists every query ranking between positions eight and twenty with impressions worth chasing.
TikTok's official gallery of high-performing auction ads pulled from real campaigns, filterable by industry, region, objective and format, free to browse with no ads account.
A ready-to-ship React Email receipt component with a typed props interface that renders order line items and totals, and survives Gmail and Outlook.
A naming convention for paid-social UTMs plus a few Google Sheets validation formulas that flag a broken tag before it ships, so your reporting stops splitting one campaign across nine spellings.
A free Google Ads Script gist from Frederick Vallaeys that pulls Performance Max search terms and category labels into a Sheet, prising open a box Google's reporting keeps shut.
80 of 80 tools on the shelf
Know a tool we’re missing? Tell us what you use and we will credit you when it is added.
Suggest a toolOne editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.