This script works for both Single & MCC Accounts. It creates dashboards & reports to give you ~15 different ways of analysing potential negative keywords in your Google ads account. Using this you can: - include (or exclude) certain campaigns - choose 1, 2 or 3-word nGrams - control how much data is sent to the sheet, so large accounts no longer time out - choose to use ‘all conversion’ metrics (rather than ‘conversions’), great for low vol accounts - use CPA instead of ROAS to create the nGram buckets (we love control!) It also let's you get the following reports: Campaign & Account Summary: Understand your overall account health and identify top-level optimization opportunities. All Keywords: Pinpoint your best and worst-performing keywords to refine your targeting strategy. All Search Terms: Discover new opportunities and threats hiding in your search query data. Keyword & Search Term nGrams: Uncover patterns in user searches to inform your keyword and ad copy strategy. And visualise with bubble charts. Poor Performers: Define your own CUSTOM RULES to quickly isolate underperforming terms. Match Type Analysis: Optimize your bidding strategy by understanding performance across different match types for both search terms & keywords New Words: Stay ahead of emerging trends and potential negative keywords in your market. High CPC Analysis: No CPC caps in place? Protect your budget by identifying and addressing sneaky expensive terms & keywords. Distribution Analysis: Visualize your CPC spread to make informed bidding decisions. Conflicting Negatives: Prevent accidental blocking of valuable traffic by identifying conflicts in your negative keywords. Redundant Negatives: Streamline your account structure by finding those unnecessary duplicate negatives. AI Analysis (of course!): Drowning in data & don't know where to start? Get AI insights and recommendations without the need for manual analysis.