Filtering phone numbers by country is a practical and powerful way to segment data in Google Data Studio (now Looker Studio). Whether you're analyzing user registrations, lead generation forms, or CRM exports, it’s common to encounter international phone numbers that need to be grouped or filtered based on origin. For El Salvador, country-specific filtering usually means identifying numbers that start with the +503 country code. Here’s how to set up a filter in Google Data Studio to isolate numbers from El Salvador.
The first step is ensuring your data source includes the phone numbers in a consistent format—ideally starting with the international code such as +503 for El el-salvador phone number list Salvador. Once your data is properly formatted and connected to Data Studio, create a custom field to help identify El Salvador numbers. Go to your data source, select “Add a Field,” and use a formula like this:
REGEXP_MATCH(Phone, "^\\+503.*")
This formula uses a regular expression (regex) to check if the phone number begins with +503. You can name this field something like “Is El Salvador Number” and set the output to boolean (true/false).
Once you’ve created the custom field, applying the filter is easy. When building your report, you can now add a filter control based on this new field. To display only El Salvador numbers in a table, chart, or any other widget, add a filter where “Is El Salvador Number = True.” This will instantly exclude all numbers that do not match the +503 pattern, helping you narrow down your analysis to users or entries from El Salvador specifically.
If you want more flexibility, such as filtering based on partial matches or local number formats (e.g., 7 or 8-digit local numbers without +503), you can enhance the regular expression accordingly. However, for reliable filtering and international consistency, it’s always recommended to standardize your numbers in the database before importing them into Data Studio. With this method in place, your reports become more actionable, allowing for targeted insights from the Salvadoran segment of your audience.