This Google Ads script automates the process of tracking keyword quality scores in your Google Ads account. It collects quality score (QS) data from all active search campaigns, aggregates the statistics, and updates a Google Sheets dashboard with charts and summaries. The script is customizable to fit various tracking needs, including specific date ranges, campaign filters, and Google-only data. By default, it is set to track data from the last 30 days for all active search campaigns and only includes keywords that have received more than 1 click and 100 impressions. Users can also receive email notifications when the script runs.

• Account Performance Monitoring: Regularly track and visualize the quality scores of keywords to identify areas for improvement.
• Quality Score Audits: Perform detailed audits of keyword quality scores for specific campaigns or date ranges.
• Client Reporting: Generate easy-to-understand visual reports for clients, highlighting the distribution of keyword quality scores.

How often should I run this script?

It depends on your needs. For regular monitoring, running the script weekly or monthly is recommended. You can set up a schedule in the Google Ads script settings.

Can I customize the date range for the data collection?

Yes, you can customize the date range by updating the DATE_RANGE variable with your desired value (e.g., 'LAST_7_DAYS', 'THIS_MONTH').

What types of campaigns does this script work with?

By default, the script is set to work with all active search campaigns. You can adjust the campaign filters in the campaignIterator section of the script to include or exclude specific campaigns.

How do I view the dashboard created by the script?

The dashboard is created in a Google Sheets document, which will be automatically saved in your Google Drive. A link to this document will be sent to the email address specified in the script.

Can I add more data or customize the dashboard further?

Yes, once the data is in Google Sheets, you can manually add more data, create additional charts, or customize the dashboard as needed.

What should I do if I don't receive the email notification?

Ensure that the EMAIL variable is correctly set to your email address. Check your spam/junk folder. Verify that you have authorized the script to send emails. If the issue persists, check the execution logs for any errors.