Back to Help

Detailed Setup Guide

Complete installation and configuration instructions

Prerequisites & Requirements

Google Ads Account Requirements:

  • • Active Performance Max campaigns (or Shopping campaigns)
  • • Last 30 days spend data
  • • Optional: Demand Gen campaigns (requires separate setup)

Permission Requirements:

  • • Standard access or above to Google Ads account
  • • Google Sheets access with same Google account

Installation: Step by Step

Part 1: Get Your Template Sheet

  1. 1. Click the template link (in purchase email or script line 16)
  2. 2. File → Make a Copy
  3. 3. Rename: "[Client Name] - PMax Insights v90"
  4. 4. Copy the sheet URL from address bar

Part 2: Install Script in Google Ads

  1. 1. Navigate to Google Ads account
  2. 2. Tools & Settings → Bulk Actions → Scripts
  3. 3. Click blue + button to create new script
  4. 4. Paste the script code (from purchase email)
  5. 5. Edit configuration (lines 18-20):
const SHEET_URL = 'your-sheet-url-here'
const CLIENTCODE = 'ClientName'

Part 3: First Run & Authorization

  1. 1. Click Preview or Run button
  2. 2. Grant permissions when prompted
  3. 3. Choose Google account that owns the sheet
  4. 4. Click "Advanced" → "Go to [Script name] (unsafe)"
  5. 5. Grant all requested permissions
  6. 6. Wait for execution (30-90 seconds typical)

Part 4: Verify Installation

  1. 1. Open your Google Sheet
  2. 2. Verify tabs exist: PMax Overview, Search Terms, Placements, Assets, Products
  3. 3. Check 'PMax Overview' tab has campaign data
  4. 4. Verify date range is last 30 days
  5. 5. Check 'Log' tab shows successful run timestamp

Part 5: Schedule Daily Runs

  1. 1. In Google Ads Scripts editor: Triggers (clock icon)
  2. 2. + Add Trigger
  3. 3. Function: main | Deployment: Head
  4. 4. Event source: Time-driven
  5. 5. Type: Day timer | Time: 6am to 7am
  6. 6. Save trigger

Optional Configuration

The script works with default settings. Only change these if you have specific needs:

  • numberOfDays: Data range (default: 30 days)
  • Brand Terms: Comma-separated for brand/non-brand analysis
  • Account Type: E-commerce (default) or Lead Gen
  • DEBUG_LOGS_ON: Verbose logging for troubleshooting

Next Steps

Understand your data tabs →Troubleshooting guide →
Quick StartUnderstanding Your Data→