The workshop annex
The working library of The SEM Dispatch. Scripts, queries, workflows and prompts we actually run, filed for reuse, plus the community tools that earned a place on the shelf. Everything is free; house code is copy-paste ready.
Copy-paste Google Ads Scripts for monitoring, reporting and housekeeping. Read-only by default: every script reports before it ever touches an account.
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.
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 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.
Ready-to-run Google Ads Query Language for the reports the UI does not want to give you. Paste into the API, scripts or your favourite runner.
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.
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.
Search Console exports, redirect maps, crawl checks and the small scripts that save an afternoon of spreadsheet drudgery.
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.
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.
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.
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.
GA4 BigQuery SQL, tagging utilities and consent-safe measurement patterns, written for people who have to defend the numbers.
A dbt package that turns the raw GA4 BigQuery export into report-ready models for sessions, users, ecommerce and attribution.
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.
Open-source email frameworks, proven transactional templates and lifecycle patterns that hold up in every client, Outlook included.
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.
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.
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 ready-to-ship React Email receipt component with a typed props interface that renders order line items and totals, and survives Gmail and Outlook.
Importable n8n workflows and automation recipes for monitoring, digests and reporting. Bring your own credentials; the wiring is done.
A curated, continuously updated GitHub collection of free n8n templates spanning marketing, sales, content and operations automation.
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.
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 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.
Working prompts and agent skills for marketing tasks, written to be edited, not worshipped. Every card states its inputs and its failure modes.
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 free library of AI prompts built from Copyhackers' own conversion-copywriting frameworks, covering voice of customer, value proposition, headlines, and landing pages.
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 Analytics' own MCP server, exposing GA4 report and realtime tools so Claude or Cursor can query your Analytics data directly without writing API glue.
One editor-curated email. The updates that matter, the noise filtered out.
Free. Occasionally includes sponsored messages from our partners. Unsubscribe anytime.