The 2-letter codes shown below are supplied by the ISO ( International Organization for Standardization). It bases its list of country names and abbreviations on the list of names published by the United Nations. The UN also uses 3-letter codes, and numerical codes to identify nations, and those are shown below.

Adobe follow A3 (UN) notation for geo_country column.If visit has to be matched to Analytics reports for a specific country then the query is as follows:

select count(distinct(concat(post_visid_high,post_visid_low,visit_num))),
pagename, page_event, post_event_list from test12345 where exclude_hit = ‘0’ and geo_country = ‘bra’ and hit_source = ‘1’ and bot_id = ‘0’;

For Visit following is the query:

select count(distinct(concat(post_visid_high,post_visid_low,visit_num))),
pagename, page_event, post_event_list from test12345 where exclude_hit = ‘0’ and hit_source = ‘1’ and bot_id = ‘0’;