Why Are Some Country Names Missing From the GEO_TARGET Table?

Question

Why are some country names missing from the GEO_TARGET table?

Environment

Connector: Google Ads

Answer

The Google Ads API doesn't return certain countries that are not targetable under U.S. law. For more information, see Google's Geographic targeting documentation.

The following countries are excluded:

• Burma (Myanmar)
• Crimea
• Cuba
• Iran
• North Korea
• Sudan
• Syria

We get data for the GEO_TARGET table from the Google API's geo_target_constant field. To ensure the list of geographical locations included in the table is up-to-date, we re-sync the table twice a month.

If the absence of these countries causes an error in your queries, you can manually add a record to the GEO_TARGET table as a workaround.

IMPORTANT: We update existing records based on the primary key column id. However, we don't modify records that are added manually. Therefore, if you add a new record to the GEO_TARGET table, you must create a unique id for the record and leave any unnecessary fields null.