# Search Terms Report Reconciliation Sheet

Canonical page: https://waitlist.crany.ai/marketing-templates/paid-search-report-reconciliation

By Tangenix. Published 2026-10-23. Category: Paid search.

Investigate why query-level paid-search exports and summary reports differ without assigning hidden queries, missing revenue or fabricated precision.

## Task

Explain a mismatch between search-term exports and other paid-search summaries using comparable scopes.

## When to use

Use this when a report total appears inconsistent with query rows or theme-level insights. Preserve both exports and definitions before interpreting the difference as waste or broken tracking.

## Choose another approach when

You intend to reconstruct omitted private searches, assign unidentified conversions to a preferred query, or merge reports with incompatible dates and definitions.

## Inputs

- Both reports with their export time, date range and account timezone.
- Filters, campaign/network scope and exact metric definitions.
- Notes on conversion maturity and aggregation or privacy limitations.

## Template

    Question: [which figures differ?]
    Report A: [surface / export time / dates / filters]
    Report B: [surface / export time / dates / filters]
    Metric compared and definition: [what is counted]
    Alignment checks: timezone / network / campaign / attribution settings / delay
    Known omission or grouping limits: [documented behavior]
    Difference remaining after alignment: [value, not assigned to an invented query]
    Supported explanation: [evidence]
    Unresolved possibilities: [explicit unknowns]
    Next check and owner: [bounded action]
    Decision deferred or changed: [reason]

## Illustrative example

This is not a Crany customer result. Replace example details with verified facts.

    Fictional review: a query export covers one Search campaign while a theme summary includes two campaigns. First correction: align campaign scope and dates.
    A smaller difference remains. The reviewer notes that some query details can be omitted or grouped and that conversion processing may differ between surfaces. The missing amount is not labeled “competitor searches” or distributed across visible rows.
    The report states the residual uncertainty and waits for a consistent mature reporting window before proposing a performance decision.

## How to use

1. Align the two report scopes and definitions before calculating a residual difference.
2. Distinguish documented grouping or delay from hypotheses about a particular discrepancy.
3. Preserve unresolved values and assign a follow-up rather than manufacturing a query-level allocation.

## Checks

- No omitted search is reconstructed or attributed without evidence.
- Export timestamps and filters remain attached to every comparison.
- A plausible documented limitation is not claimed as the proven cause of this account mismatch.

## What to measure

Track discrepancies resolved by scope corrections versus those still unexplained. A smaller reconciliation gap improves reporting confidence but does not establish that the campaign acquired valuable customers.

## Research and sources

Google documents differences between search-term reports and insights, including privacy grouping and conversion lag. The reconciliation process is original; it does not infer unseen query content or guarantee exact totals.

- [Google Ads: About the search terms report](https://support.google.com/google-ads/answer/2472708?hl=en) — checked 2026-10-23. Reported search terms differ from keywords; privacy omissions, aggregation and conversion lag limit reconciliation.

Prepared with AI assistance. Sources support the stated principles; they do not endorse Crany or guarantee performance.

## About Crany

Crany is an AI marketing co-founder in development for software founders and vibe coders. It is designed to strategize, execute approved marketing and improve based on results. These free resources are usable independently of app access. The public waitlist is at https://waitlist.crany.ai/.