Google Ads Performance Max Data Integration Script for Google Merchant Center

$0.00

Category:

Current version 2.091

Optimize your Google Ads campaigns with precision using our innovative script to seamlessly send your Performance Max (PMax) campaign data to Google Merchant Center. This powerful tool is essential for advertisers seeking to create advanced, rule-based campaign setups that enhance campaign efficacy and targeting.
With this script, effortlessly automate the merging of two distinct PMax campaigns —one targeting non-converting products and the other focusing on converting ones. It provides a comprehensive analysis of your PMax performance over periods of 30, 60, 90 days, or more, delivering all essential data into an easily accessible Google Spreadsheet.
This spreadsheet acts as a supplementary feed into Google Merchant Center, where you can establish intricate feed rules based on key metrics such as clicks, impressions, click-through rates, conversion value, return on ad spend (ROAS), and cost, all sorted by custom attributes. Set conditions such as assigning ‘converting’ or ‘non-converting’ labels based on conversion metrics, enabling tailored campaign strategies.
Moreover, our script includes a unique feature for merging campaign data. If a product initially labeled as non-converting starts converting, the merged data in the spreadsheet updates, reflecting sales accurately and allowing for real-time campaign adjustments.
Unlock the full potential of your Google Ads with this script, designed to bring precision and efficiency to your digital marketing efforts.

As of version 2.07 you can now see product level performance notes, automatically calculated based on your criteria. Check out the video in the Instructions tab for more details.

  • You can specify the campaign ROAS target
    • Allowing you to see what is on target
  • ROAS above and below target
    • Allowing you to see what is below or above a percentage target
  • Minimum clicks
    • If clicks exceed the minimum click threshold, you can see what is wasting budget
  • High Impression Threshold
    • See which products have high impressions and low CTR

PMax Product Level Notes

Instructions

Merge Multiple Campaigns Sheet

If you have multiple different campaigns, for example 5 campaigns each with different products, when targeting 1 country. You can use the below spreadsheet to merge data. Please view the video instructions for the explenation or click here:

Spreadsheet example: https://docs.google.com/spreadsheets/d/1XOud3y5UDWDYgKQhf897pcdMJ6RwUK2T5S5jhR1_wFI/copy

FAQ

Q: Some Products Are Not Listed?

A: Only products with an impression will show.

Change Log

  • 23rd August 2024
    • Created a failsafe for Google Ads product ID bug (value does not exist, causing the whole script to fail) This is now no longer an issue
    • Created a failsafe when Google Ads scripts can’t read data (Like what happened in August 2024)
  • 29th May 2024
    • Added product level notes, allowing you to see product level performancd, such as above target, below, on target, no performance etc.
    • Added a function to enable fullcap product id’s
  • 26th April 2024
    • Updated merging issues, now products from both campaigns will be merged correctly.

Reviews

There are no reviews yet.

Be the first to review “Google Ads Performance Max Data Integration Script for Google Merchant Center”

Your email address will not be published. Required fields are marked *

Shopping Cart