Make your competitive prices notable
Disclaimer: This is not an official Google product.
The Price Visibility Booster is a solution that helps you highlight your competitive prices by leveraging price benchmark data from Google Merchant Center. It uses the Content API to identify offers that are Below, At, or Above the benchmark price and labels your products accordingly.
Optionally, you can also retrieve reporting data for the labels created, to evaluate how well your selected products are doing.
- Retrieves Price Benchmark information from Merchant Center using the Content API.
- Identifies offers that are Below, At, or Above the benchmark price.
- Labels your products based on their price position relative to the benchmark.
- A functioning Merchant Center account
- Market Insights enabled on the account
- Standard (or Admin) access to Merchant Center
- Reporting manager access to Merchant Center
- Developer Token for the Google Ads API
- Cloud project with Google Ads API enabled
- Personal access to the Google Ads account where the campaigns are running
-
Make a copy of this Google Sheet file and work on your newly created copy.
-
Go to the 'start here' tab in the spreadsheet and follow the steps outlined there.
-
Set up the necessary parameters:
- Merchant ID
- Custom label number
- Country and Currency filters
- Label thresholds for Below, At, and Above benchmark prices
- Stock information settings (if applicable)
-
If using the optional Add-on report:
- Open Apps Script (Extensions > Apps Script in the Google Sheets menu)
- Go to Project Settings
- Change the GCP Project Number to your project
- Enable the Google Ads API in your Cloud Project
- Add a new Script Property named "DeveloperToken" with your Developer Token as the value
- In the 'control panel' tab, add your Manager and Account CIDs
- The solution retrieves price benchmark data from your Merchant Center account.
- It compares your product prices to the benchmark prices.
- Based on the configured thresholds, it assigns labels to your products:
- "Below benchmark"
- "At benchmark"
- "Above benchmark"
- These labels are then pushed to your Merchant Center feed (if enabled).
- Optionally, it can generate a report on how your labeled products are performing using the Google Ads API.
You can configure various aspects of the tool in the 'control panel' tab:
- Label thresholds
- Whether to activate labels
- Stock information usage
- And more
Refer to the spreadsheet for detailed configuration options and their explanations.
If you encounter any issues or have questions, please refer to the documentation provided in the Google Sheets file or contact your Google representative for assistance.