Reporting continuity · 25 min setup

Merchant Center Reporting Continuity QA Kit

A formula-driven QA workbook that maps old-to-new fields, reconciles like-for-like totals and assigns owners before a reporting or API change becomes a budget decision.

Direct verdict

Your dashboard still loads. The definition underneath it changed. Find the failed field, material variance or missing owner before comparing performance.

Use this resource when

DTC growth operators using Merchant Center or Shopping dataEcommerce analysts validating reporting changesTechnical marketers managing product-data integrations
Free Excel workbook

Download the working file.

This is the complete editable template—not a PDF preview. Add your own account data, owners and decisions.

Formula-driven scorecardEditable inputsNo locked cells

No spam. Your information is not sold or shared. See the Privacy Policy.

01

Inventory the sources and freshness

Record the old and new extract times, comparison period, owners and a user-set variance tolerance. Official guidance and operator rules remain visibly separated.

02

Map every critical field

Connect old field to new field, definition, source and owner. One-to-many mappings, transforms and definition changes stay explicit instead of being forced into false equivalence.

03

Reconcile like-for-like totals

Compare product count, eligible offers, clicks, cost, conversions, conversion value and merchant-side profit where available. Variance uses the old total as denominator and the tolerance remains editable.

04

Let critical failures override passing totals

PASS requires mapped fields, reconciled totals and sign-off. REVIEW records expected discontinuities. BLOCK overrides cosmetic success when a critical field is missing, refresh is broken or a material issue remains open.

05

Assign ownership and rollback

Every issue has evidence, severity, owner, action, due date, sign-off and rollback note so the QA kit completes an operating job rather than stopping at a checklist.

Merchant Center field mapping table showing mapped, review and blocked reporting fields with named owners
Evidence, not decoration.Illustrative reporting data. Document source scope, freshness and definition changes; do not assume differently defined reports should match exactly.

Practical questions

Questions that change the decision

Should old and new reports always match exactly?

No. Reconcile like-for-like fields within a tolerance you set, and document expected definition discontinuities instead of forcing equality.

Can totals pass while the final decision is BLOCK?

Yes. A missing critical field, broken refresh or unresolved material issue overrides otherwise passing totals.

Is this a full Merchant Center audit?

No. It is a focused continuity kit for reporting definitions, field mappings, totals, ownership and rollback across a change.

Sources and platform documentation

Platform features change. These links point to the primary documentation used for the implementation details above.

  1. Google Merchant Center: custom reports
  2. Google Merchant API guidance

Continuity risk found?

Turn the BLOCK into a trusted measurement repair plan.

Use the Free Audit or the $497 Budget Recovery Sprint to reconcile product data, reporting definitions and the budget decisions that depend on them.

Get a free audit
Discuss your project