Good morning - I am building a report to show clicks on a filled area map. It generally works using the City field from the Google Ads data source. However, there are some filled areas that lie outside my campaign region (e.g. Pasadena, CA instead of Pasadena, MD). Can anyone share how to ensure the city selected is within the appropriate region? This is a critical field because it ties to other data sources I want to join to the Google Ads data.
Good morning! To ensure the city selected is within the appropriate region, you can use a geographic validation process. First, create a mapping of cities to their respective regions and filter your data accordingly. Consider using spatial joins with a geographic database that includes region boundaries. You could also implement a lookup function in your report to check if the city is in the allowed region before processing further. This will help maintain data integrity for your joins with other data sources.