Overview
If you're analyzing Google Ads performance across different regions, filtering your data by country is essential. Because Google Ads does not directly provide country names in API responses, you’ll need to use the Country criterion ID along with the Geographic view report in Whatagraph.
This guide walks you through the steps to apply this filter accurately and visualize results effectively within Whatagraph.
Step 1: Select the Geographic View Report Type
To enable filtering by country, your Google Ads widget must be set to the Geographic view.
How to Set the Geographic View:
Open your report in Whatagraph.
Add or edit a Google Ads widget.
In the widget settings, go to the Report Type dropdown.
Select Geographic from the list.
Important: Country-level filtering is only available when the Geographic report type is selected. Other report types won’t support country-based filtering.
Step 2: Locate the Country Criterion ID
Google Ads uses numerical Country criterion IDs rather than country names when returning location data through the API.
How to Find the Right ID:
You have two options:
Option A: Use Google’s Official CSV File
Search for your target country in the file to find its corresponding ID.
Option B: Create a Table Widget in Whatagraph
Add a Table widget to your report.
Set Country as a dimension.
Add Country Criterion ID as a metric.
View the resulting table to match countries with their IDs.
Note: This is the most accurate method for seeing which Country criterion IDs are present in your live data.
Step 3: Create a Table Widget with Country Data
Before applying filters, it's helpful to visualize which country data exists in your report.
Steps to Build the Table Widget:
Add a new Table widget to your report.
In the widget settings:
Set Country as a dimension.
Set Country Criterion ID as an additional dimension or metric.
Confirm that the data shown includes the countries and IDs you want to filter by.
Important: Seeing both fields together helps you validate that the ID you’re filtering for is available in the data.
Step 4: Apply the Filter by Country Criterion ID
Now that you’ve identified the correct Country criterion ID(s), apply the filter to any widget or report.
How to Filter by Country:
Open the widget settings or data source filter panel.
Choose Country Criterion ID as the filter field.
Select the appropriate operator:
Equals — for a single country
Contains — to include multiple countries
Enter the Country criterion ID(s) you retrieved earlier.
Examples:
To filter for the United States only:
Country Criterion ID includes 2840
To include the US and Canada:
Country Criterion ID contains 2840, 2124
Note: If the data does not appear after filtering, double-check that the Geographic view is selected and the Country criterion ID exists in your dataset.
Additional Tips
Label widgets clearly (e.g., "Google Ads – US Only") to avoid confusion.
Save filter presets if you’ll reuse the same country filters across multiple reports.
Cross-check with the country CSV regularly in case Google updates country IDs.