How It Works

This script is engineered specifically for the "black box" of Google Ads: Performance Max. It extracts detailed performance data that is often hard to visualize in the native dashboard and pipes it directly into Google Sheets.

Automated Data Extraction

The script runs two distinct queries against your Performance Max campaigns. It bypasses the general interface to pull raw metrics (Clicks, Impressions, Conversions, Cost, and Conversion Value) directly via the Ads API.

Dual-View Reporting

You get two granular views for deeper analysis:

• Campaign View (Last 30 Days): A snapshot of recent performance grouped by campaign name, perfect for monthly check-ins.
• Daily Trend View (Last 365 Days): A massive historical dataset grouped by date, allowing you to plot year-over-year trends and seasonality.