Google Merchant Center

Follow our setup guide to connect Google Merchant Center to QUANTI:

Pre-built tables and definition

---

Prerequisites

Before connecting Google Merchant Center to QUANTI, ensure you have:

• Google Merchant Center Account: An active Google Merchant Center account with product feeds configured

• Google Account Access: Owner or Admin access to the Merchant Center account

• Product Feed: At least one product feed with approved products

• API Access: Ensure API access is enabled for your Merchant Center account

---

Setup Instructions

1

Authorize Google Connection

• Click on Connect to Google

• You will be redirected to Google's authorization page

• Log in with your Google account credentials

• Review and accept the requested permissions:

  • View and manage your Google Merchant Center accounts

  • Access product and performance data

• Click Allow to grant access

2

Select Merchant Center Account(s)

• After authorization, you'll see a list of your Merchant Center accounts

• Select the account(s) you want to connect to QUANTI

• You can select multiple accounts to track products from different sources

• Click Next

3

Select Pre-built Tables

• Review the available pre-built tables (see section below for details)

• All tables are selected by default - you can deselect tables you don't need

• Recommended: Keep all tables enabled for complete product tracking and performance analysis

• Click Next

4

Finish Setup

• Define a sync period and a lookback window - Click Save

• For the first sync, you have the following options:

  • Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button

  • Launch a historical data recovery by choosing your desired dates in the historical data tab

  • Launch a manual sync immediately by clicking the Sync now button

• Wait for the sync to complete. Then navigate to your data warehouse to verify that tables are populated

• Check the connector dashboard for sync status and any potential errors

---

Pre-built Tables

Dimension Tables

• product: Complete product catalog with attribute change tracking. Contains product details including ID, title, brand, availability, condition, channel, language, and aggregated status. This table includes historization to track product attribute changes over time.

• item_issue: Product issues child table linked to the product table. Captures all issues affecting products including issue code, affected attribute, description, resolution type, severity level, and documentation links. Each product can have multiple issues.

Metric Tables

• product_performance: Daily product performance metrics including clicks, impressions, click-through rate, conversions, conversion rate, and conversion value. Data is segmented by marketing method (Shopping Ads, Free Listings, etc.) and customer country. Includes hierarchical categorization with Google categories (5 levels), product types (5 levels), and custom labels (5 labels).

The Parent-Child Relationship between product & item_issue

item_issues is a nested object within the product table, representing a one-to-many relationship between products and their issues. Each product can have multiple issues associated with it. To link issues to their respective products, use the _quanti_id field present in both tables - this field enables the join between the two tables and ensures each issue is correctly associated with its parent product record.

---

Pre-built tables and definition

---

Notes

• Historical Limitations: Google's API allows historical data retrieval up to 18 months for performance metrics.