Advanced Settings

Fixed Date Range

By default, the script analyzes rolling time periods (last 30 days, etc.). The fixed date range feature allows you to analyze specific time periods for comparison or historical analysis.

How to set: Double-click the date range cells to input specific start and end dates.

Use cases:

• Comparing performance across different time frames
• Analyzing specific promotional periods
• Historical performance audits
• Month-over-month or quarter-over-quarter comparisons

Product Matrix Thresholds

The six-bucket classification system uses cost and ROAS thresholds to categorize products as “high” or “low” performers. These thresholds can be customized in Advanced Settings.

Configurable parameters:

• Cost threshold: Defines “high cost” vs “low cost” products
• ROAS threshold: Defines “high ROAS” vs “low ROAS” products

Adjusting these thresholds changes how products are distributed across the six performance buckets, allowing you to tailor the analysis to your specific business metrics and profitability requirements.

Lots of Products Setting

For accounts with large product catalogs, the standard script execution may timeout before completing data processing. The “lots of products” setting manages this limitation by filtering out low-signal products.

Configuration options:

• 0 (default): Process all products
• 1: Ignore zombie products (products with zero impressions)
• 2: Ignore zombies AND zero conversion products (products that got impressions but never converted)

This setting prevents script timeouts for large datasets while maintaining analysis of products that actually matter to your performance.

More information: Paid script timing out? Use the lotsproducts variable

Additional Reports

The script can generate supplementary reports for deeper analysis. These reports are off by default because they increase script execution time, particularly when running through the MCC script across multiple accounts.

Available additional reports:

• Landing Page: Raw data showing which landing pages receive PMax traffic and their performance
• Change History: Google Ads change log data showing what modifications were made to campaigns and when

How to enable: Tick the checkboxes for the reports you want to generate.

Accessing reports: After the script runs, use the sheet hamburger menu to unhide the tabs. The reports appear as hidden tabs on the right-hand side of the tab list.

Data format: These reports provide raw data without the polished UI of the main tabs, designed for custom analysis.

Campaign Name Filters

Campaign name filters allow you to analyze specific subsets of your Performance Max campaigns rather than account-wide data.

Use cases:

• Region-specific analysis (campaigns named with country codes)
• Product category focus (campaigns organized by product type)
• Test vs control campaign analysis
• Client-specific reports in agency MCCs

Filter syntax: Use campaign name patterns to include only matching campaigns in the analysis.

Best practice: For complex filtering needs, consider creating separate scripts and sheets for different campaign groups rather than repeatedly changing filters.