This Google Ads script is designed to manage and optimize your Google Display Network placements by analyzing the performance of URLs where your ads are shown. The script performs the following tasks:

• Connects to a Google Sheet to track "Good" and "Bad" placements.
• Fetches data from Google Ads to identify URLs where your ads appeared, based on specified criteria.
• Uses Ahrefs and SE Ranking APIs to fetch domain rating and traffic metrics for each URL.
• Compares these metrics against predefined thresholds.
• Classifies URLs as "Good" or "Bad" based on the metrics and thresholds.
• Updates the Google Sheet with the classification results.
• Adds URLs classified as "Bad" to an exclusion list in Google Ads to prevent your ads from appearing there again.

1. Daily Monitoring: Ensures any placements that don’t meet your criteria are found and excluded.
2. Campaign Health Check: Identifies display campaigns that may be paused or facing issues resulting in weak or irrelevant placements.
3. Performance Review: Assists in daily performance reviews by highlighting campaigns that are not delivering good placements.

• Google Sheet: A Google Sheet URL where results will be logged.
• API Keys: Valid API keys for Ahrefs and SE Ranking.
• Google Ads Access: Access to the Google Ads account where the script will be executed.
• Exclusion List: A pre-configured exclusion list in your Google Ads account to add bad placements.

How do I obtain API keys for Ahrefs and SE Ranking?

You can obtain API keys by signing up for Ahrefs and SE Ranking, then accessing the API section in your account settings. Generate an API key and copy it to the respective variable in the script.

What happens if the script exceeds API rate limits?

If the script exceeds API rate limits, it may be throttled or temporarily blocked. You can handle rate limits by adding delays in the script or contacting API support for higher limits.

How do I know if the script is working correctly?

Check the Logs in the Google Ads script editor for messages about the number of placements found, classifications, and any errors. Also, check the Google Sheet for updated entries in the "Good placements" and "Bad placements" tabs.

Can I change the thresholds for domain rating and traffic?

Yes, you can adjust the DR_THRESHOLD and TRAFFIC_THRESHOLD variables to set your own criteria for classifying placements as "Good" or "Bad".

What if I need to add more criteria for excluding placements?

You can modify the query in the placements variable to include additional criteria. Ensure that you understand Google Ads Query Language (GAQL) for making these changes.

How often should I run this script?

Depending on your campaign size and frequency of new placements, you might run the script daily, weekly, or monthly. Automate the script execution by setting up a schedule in the Google Ads script editor.