Shopping Performance Data Exporter
Export and analyze Shopping campaign performance metrics by automatically sending data to a Google Sheet. This script helps you monitor key performance indicators and optimize your campaigns effectively.
Full description (What does the script do)
This Google Ads script exports performance data from Shopping campaigns to a specified Google Sheet. It collects metrics such as clicks, impressions, CTR, conversions, conversion rate, conversion value, and cost (converted from micros if configured) for the last 30 days or a specified date range.
Example Use Cases
- Performance Monitoring: Regularly export and review Shopping campaign performance metrics to track key indicators and identify trends.
- Cost Analysis: Analyze cost data in standard currency format for better budgeting and financial planning.
- Reporting and Auditing: Use the exported data for detailed reporting and auditing of Shopping campaign performance.
Frequently Asked Questions
How do I set up the script?
Copy the script into your Google Ads script editor. Update the SPREADSHEET_URL with the URL of your Google Sheet, ensuring it ends with '/edit'. Optionally, adjust the DATE_RANGE and CONVERT_MICROS settings.
What happens if the Google Sheet URL is not set?
The script will throw an error prompting you to set the SPREADSHEET_URL with the correct Google Sheet URL.
Can I change the name of the sheet where the data is exported?
Yes, you can change the active sheet in your Google Sheet by renaming it or selecting a different sheet as needed.
How often should I run this script?
It is recommended to run the script regularly (e.g., weekly or monthly) to keep track of Shopping campaign performance over time.
What data is exported to the Google Sheet?
The script exports metrics including product item ID, clicks, impressions, CTR, conversions, conversion rate, conversion value, and cost (converted from micros if configured).
Reviews (0)
About the listing author
I’ve spent the last 5 years navigating the complexities of international and multilingual PPC campaigns. I thrive on the challenges that come with global markets.
I’ve spent the last 5 years navigating the complexities of international and multilingual PPC campaigns. I thrive on the challenges that come with global markets.