Why Are Some Campaigns Missing country_code Data?

Question

Why does the country_code column in the CAMPAIGN_HISTORY table contain some null values?

Environment

Connector: Microsoft Advertising

Answer

Microsoft only supports country code data for the campaign types Shopping and Performance Max. For more information, see the Microsoft Campaign Record documentation.

As a result, the country_code column in the CAMPAIGN_HISTORY table may contain null values for all other campaign types.