Microsoft/Bing Ads data reference

A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.

Each tab below notes how the export date range applies.

For configuration steps see Configuring Microsoft/Bing Ads exports.

Campaigns (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Campaign StatusCampaign Status.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Ad Groups (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Ad Group StatusAd Group Status.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Keywords (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Keyword IDKeyword ID from the source platform.
KeywordKeyword.
Bid Match TypeBid Match Type.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Ads (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Ad IDAd ID from the source platform.
Ad TitleAd Title.
Ad TypeAd Type.
Ad StatusAd Status.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Search Queries (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Campaign IDCampaign ID from the source platform.
Campaign NameCampaign Name.
Ad Group IDAd Group ID from the source platform.
Ad Group NameAd Group Name.
Search QuerySearch Query.
KeywordKeyword.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Geographic (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
CountryCountry.
StateState.
Metro AreaMetro Area.
CityCity.
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Average CPMAverage CPM.
Average PositionAverage Position.
Conversion RateConversion Rate.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
Revenue per ConversionRevenue per Conversion in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.
View-Through ConversionsView-Through Conversions.
View-Through RevenueView-Through Revenue in the row currency unless noted otherwise.

Product Dimension (Daily)

One row per entity per day. Date range: uses the selected export date range. Metrics are Microsoft Advertising performance fields for that day.

ColumnDescription
DateDate.
Product IDProduct ID from the source platform.
Product TitleProduct Title.
BrandBrand.
Product Type (Level 1)Product Type (Level 1).
Product Type (Level 2)Product Type (Level 2).
ImpressionsNumber of times the ad or listing was shown.
ClicksNumber of clicks.
SpendSpend for the row period.
ConversionsConversions.
RevenueRevenue in the row currency unless noted otherwise.
CTRClick-through rate.
Average CPCAverage CPC.
Cost per ConversionCost per Conversion in the row currency unless noted otherwise.
Return on Ad SpendReturn on Ad Spend in the row currency unless noted otherwise.
All ConversionsAll Conversions.
All RevenueAll Revenue in the row currency unless noted otherwise.
All Conversion RateAll Conversion Rate.
All Cost per ConversionAll Cost per Conversion in the row currency unless noted otherwise.
All Return on Ad SpendAll Return on Ad Spend in the row currency unless noted otherwise.
All Revenue per ConversionAll Revenue per Conversion in the row currency unless noted otherwise.

Related documentation

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.