Google Ads hides most key metrics—like Impressions, Clicks, Views, and Cost—for all Performance Max assets.
This script gives you access to those hidden asset metrics and lets you pull them directly into Google Sheets.
Get started:
Copy the script code provided here.
In Google Ads, go to Tools > Scripts.
Open this spreadsheet in Google Sheets and make a copy.
In the script, replace 'YOUR_SPREADSHEET_URL' with the URL of the sheet you just copied.
Save, authorize, and run the script — and you’re all set! 🎉