What Data We Pull
SKU Analyzer merges Google Ads performance data with Merchant Center product attributes at the product level, using offer_id and product_id to join the two data sources into a single unified view.
Unified Product Data
From Google Ads
- Clicks, impressions, cost per product
- Conversions and conversion value
- CTR, CPC, ROAS calculations
- Impression share
- Search terms and campaign data
- PMax channel splits and asset groups
From Merchant Center
- Product titles, brands, images
- Current prices and availability
- Product categories (L1 through L5)
- Benchmark prices and price difference
- Competitive visibility and page overlap
- Feed history and change tracking
Why merging matters
Google Ads tells you how products perform in ads. Merchant Center tells you about the products themselves. Neither gives you the full picture alone. SKU Analyzer joins them so you can see a product's image, title, brand, price, and competitive position alongside its clicks, conversions, and ROAS — all in one row.
How the Connection Works
One Google sign-in connects both your Ads and Merchant Center accounts. Data syncs automatically and merges in real time.
Single OAuth Connection
Sign in once with your Google account. SKU Analyzer automatically detects your linked Ads and Merchant Center accounts and starts pulling data from both.
Automatic Data Merging
Products from Google Ads are matched with Merchant Center feed data using offer_id and product_id. The merge happens automatically — no mapping or configuration needed.
Smart Caching
The dashboard starts with 14 days of data for fast initial load. Expand to 30, 90, or 365 days on demand — additional data fetches only when you need it.
Daily Automated Sync
A background worker refreshes all data daily at 3 AM. Ads data uses a 14-day rolling window for conversion lag, while Merchant Center data is fetched in full each time.
What You Can Do With It
The unified data powers every feature in SKU Analyzer. Here are the key pages that benefit from merged Ads + Merchant Center data.
Product Analytics
See product images, titles, and brands from MC alongside clicks, conversions, and ROAS from Ads in one table.
Competition & Pricing
Compare your prices to benchmarks, track visibility metrics, and see position trends over time.
Wasted Spend
Identify zero-conversion products with enriched MC data like availability status and pricing context.
Campaigns & PMax
Campaign-level performance with PMax channel breakdowns and asset group analytics.
Related Resources
Explore guides and integrations related to Google Shopping analytics.
See Your Google Shopping Data in One Place
Connect your accounts and get unified product-level analytics combining Ads performance with Merchant Center feed data.