PPCDATAFEED

Google sources: Sheets, Merchant Center, benchmarks, reports

Four sources that need a Google login instead of a file URL - and when each one is useful.

All four need a login in Integrations first (Google Drive for Sheets, Merchant Center or Google Ads for the rest). Then create the data source and pick the login on the screen.

The Google group of the New data source window: Google Sheets, Merchant Center, Price Benchmarks and Shopping Product Report

Google Sheets

Pick the Google Drive login, paste the Sheet URL and choose the Tab. The first row becomes the field names. Good for manual data - margins, labels, seasonal flags - that you later join to the main catalog with a Combined source or use in Shopping labels.

Merchant Center

Pick the Login and the Account. Your products come in exactly as Google sees them - useful when the shop has no usable file, or to build exports for other channels from the Google feed.

Price Benchmarks

Merchant Center price benchmark data per product - how your price compares to the market. Combine it with your catalog to label or filter products by price position.

Shopping Product Report

A Google Ads performance report per product (clicks, cost, conversions, value). Join it to the catalog to build rules such as “exclude products with 200 clicks and no conversions”.

Google logins: click Manage logins on the screen if the list is empty, or add them in Integrations first.

Still stuck? Write to info@ppcdatafeed.com - we answer ourselves and can set it up with you.