Datapipe
Merchant Center report
A daily table of the synced columns, ready for Sheets or a CSV.
Coming soon
Merchant Center for agencies and in-house teams
Retail and agency teams use Merchant Center in Datapipe to see product listing clicks and impressions once Merchant Center access is approved.
What connects
The same Google sign-in, with the content scope added only when Merchant Center is requested. Account discovery uses the Merchant API accounts.list. The Content API for Shopping has shut down and is not called.
What you can report on
- Account (dimension). A Merchant Center account id returned by the Merchant API.
- Product (dimension). Product identifier. Live product performance is not pulled until Google approves access.
- Clicks (metric). Listing clicks. The report stays on sample rows until approval.
- Impressions (metric). Listing impressions. Sample until approval.
What you set up
- Add Merchant Center from Connections. That asks for the content scope on a later consent.
- Accounts can be listed from the Merchant API.
- Do not configure the old Content API for Shopping. It has shut down.
Limitations
The Content API for Shopping is shut down. This app uses the Merchant API. Live product clicks and impressions still need Google's approval, so those reports stay on sample data and are labeled Coming soon.
Last reviewed 2026-10-29. Owner: Datapipe.
Connection
Coming soon
Coming soon. Merchant Center uses the Merchant API on the same Google sign-in, with an added scope. The Content API for Shopping has shut down. Live product data needs Google's approval. Sample numbers stay labeled.
Fields
Merchant API accounts and listing performance. The Content API for Shopping shut down on August 18, 2026. Live calls need Google's approval. Sample numbers stay labeled. Source: https://developers.google.com/merchant/api/reference/rest/accounts_v1/accounts/list. Read on 2026-10-29. 4 fields.
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Impressions | impressions | Times the product was shown. | metric · integer | Metrics | Impressions |
| Clicks | clicks | Clicks on the product. | metric · integer | Metrics | Clicks |
Product
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Product | offerId | The product offer id. | dimension · string | Product |
Time
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Date | date | The day of the listing metric. | dimension · date | Time |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Merchant Center to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Merchant Center to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Merchant Center to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Merchant Center to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Merchant Center to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Merchant Center to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections. This source is marked Coming soon.
- You can still build a sample report so the destination and the schedule are ready.
- The owner turns the live connection on after the platform approves the app.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Merchant Center connection live?
Coming soon. Merchant Center uses the Merchant API on the same Google sign-in, with an added scope. The Content API for Shopping has shut down. Live product data needs Google's approval. Sample numbers stay labeled.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The field list is the platform's published resource. A saved report uses the columns on that connector's card.