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.

Apply this resource

Is the failure in reporting, the product feed or measurement?

A failed continuity check does not automatically mean the product feed is wrong. Classify the broken layer before briefing a provider; this workbook remains a reporting QA tool.

Prepare a useful handover

  1. Reporting definition changed: assign the export or dashboard owner to reconcile the mapping.
  2. Product data or eligibility is the issue: capture affected product IDs, markets, feed source and the Merchant Center issue.
  3. Purchase collection is the issue: capture missing, duplicate or wrong-value events separately from feed diagnostics.

Product data, product coverage or recurring Shopping decisions need workGoogle Shopping & Feed Management →

GA4 or ad-platform purchase events fail validationGA4 & Conversion Tracking Audit + Fix →

Continue with the resource: Connect product priorities to stock and contribution.

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.

Share the broken field, refresh, definition or reconciliation gap. I will scope the tracking and reporting repair without treating a dashboard load as proof the data is trustworthy.

Discuss conversion tracking
Discuss your project