Tracks the Lin-Rodnitzky ratio — cost per conversion of all search queries divided by cost per conversion of converting queries only — and charts it over time in a Google Sheet.
by Nils Rooijmans·nilsrooijmans.com/google-ads-script-lin-rodnitzky-ratio
Monitors your account for unexpected performance deviations by comparing today's stats against historical averages for the same weekday. Sends an alert email when impressions, clicks, conversions, or cost deviate beyond configurable thresholds.
One 0-100 score for the whole account, built from seven objective checks — tracking flatlines, disapprovals, serving status, budget losses, negative coverage and query hygiene — with the deduction breakdown as your fix list.
Finds the structural gaps that stop ad groups from serving: ad groups without active ads, without an RSA, without keywords, keyword-stuffed themes, and multi-RSA ad groups.
Generates a daily at-a-glance performance overview of your entire Google Ads account. Writes prior-day stats to a Google Sheet with running history and optionally emails a formatted comparison of yesterday vs. two days ago vs. one week ago.
Generates a Google Spreadsheet with ad performance stats segmented by headline and final URL, including distribution charts. Covers all ad types and optionally emails the report link weekly.
Maps every campaign's ad schedule and flags forgotten narrow serving windows, stale schedule bid modifiers that Smart Bidding ignores, and (optionally) campaigns running 24/7.
The Lin-Rodnitzky ratio is a one-number health check for Search accounts: total cost/conversion divided by cost/conversion of queries that converted at least once. 1.0-1.5 = too conservative, 1.5-2.0 = well managed, 2.0-2.5 = too aggressive, above 2.5 = money is burning on queries that never convert. This script computes the ratio daily over a rolling window and appends it to a template Google Sheet that graphs the trend.
| Variable | Default |
|---|---|
SPREADSHEET_URL | (required) |
INITIAL_PERIOD | 180 |
LOOKBACK_WINDOW | 28 |
One row per day in the 'LR Ratio' sheet: date, cost/conv (all queries), cost/conv (converting queries), Lin-Rodnitzky ratio — with the template's chart showing the trend.
Popularized by Will Lin and David Rodnitzky; interpret the bands as a conversation starter, not gospel — accounts deliberately investing in growth run higher ratios. Requires conversion tracking with search query data.