Data Measured

artifact #A-005 · sheet · current

Attribution reconcile sheet

Two 28-day exports side by side — last-click and data-driven — per campaign delta, and the Smart Bidding re-baseline arithmetic.

verified_on
2026-09-09
checked against
GA4 — attribution settingsGA4 What's new — Jan 16, 2026 (per-conversion attribution)GA4 What's new archive — Jun 10, 2024 (paid search credit)
next re-check
2026-12-01
status
current
time
20 minutes
skill
you can export a report

What's inside

  • Columns: campaign, last-click key events, data-driven key events, delta, delta %
  • The rule for the re-baseline (new tCPA = old × total_DDA / total_LC)
  • Where to export each model from in GA4

Install

  1. Open the CSV in Sheets or Excel; paste your two exports.
  2. Check the totals match within rounding; if not, the windows differ — align them first.
  3. Annotate the change date in Google Ads' change history and reset targets from the new baseline.

The file · attribution-reconcile.csv

Download
campaign,last_click_key_events,data_driven_key_events,delta,delta_pct,note
"Brand search",120,104,=C2-B2,=IF(B2=0,"",(C2-B2)/B2),"credit moved to upper funnel"
"Generic search",80,96,=C3-B3,=IF(B3=0,"",(C3-B3)/B3),""
"Paid social",40,61,=C4-B4,=IF(B4=0,"",(C4-B4)/B4),""
# Paste two 28-day exports of the same key event (Attribution settings > model comparison, or Advertising > Attribution paths): last-click in column B, data-driven in column C. Totals should be equal within rounding — if they are not, the windows differ. Smart Bidding re-baseline: new tCPA = old tCPA x (total_C / total_B) per campaign. Delete the comment row.

Breaks on

The logged changes that can invalidate this artifact. A new one triggers a re-check.

Stamped 9 Sept 2026 · re-checked quarterly or on change · corrections to team@datameasured.com · ← the library