Need SQL Query to pull Country, region, and cities from Data Feed Export. | Community
Skip to main content
B
Basu212
Level 2
February 22, 2026
Question

Need SQL Query to pull Country, region, and cities from Data Feed Export.

  • February 22, 2026
  • 2 replies
  • 21 views

Hi Team, I could not able to pull the country, region and cities form Data feed export. Also I don’t see the 3 digit ISO country code mapping list. Can I get the SQL query for the same.

 

2 replies

R
Adobe Employee
rgaurAdobe Employee
Adobe Employee
February 23, 2026

Hey ​@Basu212 

Country, region and cities are available in data feeds as geo_country, geo_region and geo_city columns. Check out: https://experienceleague.adobe.com/en/docs/analytics/export/analytics-data-feed/data-feed-contents/datafeeds-reference

B
Basu212Author
Level 2
February 23, 2026

Hi ​@rgaur ,

I could see the geo_country in the data feed. But it has three digital ISO code such as ‘USA’. But I could not find any mapping tables which tells “USA” → “United States of America”.    

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
February 23, 2026

​@Basu212 I agree, I don’t see a lookup file provided. The “Geo City” seems to be free text, but the country is a shortform… 

 

However, there is a separate “Country” column with a numeric value, and there is a country.tsv lookup for that… you should be able to map Country to Geo Country… 

 

But if you need more info about the other geo items, you can reach out to Client Care… I had to once for eVar “ids” in the post product values (they first thought I wanted events and after some back and forth, they realized that there was no mapping file, and were able to send me files directly to support my needs.)

B
Basu212Author
Level 2
February 24, 2026

​@Jennifer_Dungan  thanks for the response.

The “Country” column’s data is not matching with the Adobe Dashboard Countries. Will reach out to the client care for the same. thank you. 

 

If you have any countries mapping list then please share it.

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
February 24, 2026

Hmm that’s interesting indeed… I don’t look directly at our raw feeds much, I assumed they should match…. 

Sadly, I don’t have a countries mapping list (unless you are talking about the country.tsv that is part of the lookup tables that come with your feed.

Terms & ConditionsAccessibility statement

Loading footer...