Bing Ads predefined reports
Predefined reports
The Bing Ads data source in Data Integration comes with the predefined reports. Each report has a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are locked fields that are only accessible through the custom reporting feature.
Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom reports feature.
Source-Level selections
Bing Ads has two source-level selections: Accounts and Customers. These options filter down each report within the river to only the selected data.
Budget Summary
The Budget Summary report determines the campaign's budget performance for the month. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
AccountId  | Integer | Dimension |
| Date | String | Dimension |
| CampaignId | Integer | Dimension |
| AccountNumber | String | Dimension |
| CampaignName | String | Dimension |
| CurrencyCode | String | Dimension |
| DailySpend | Float | Metric |
| AccountName | String | Dimension |
| MonthToDateSpend | Float | Metric |
| MonthlyBudget | Float | Metric |
User Location Performance
The User Location Performance report is to view where the traffic is coming from, broken out by the physical location and the location for which users are searching. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| QueryIntentLocationId | Integer | Dimension |
| LocationId | Integer | Dimension |
| AdGroupId | Integer | Dimension |
| DeviceType | String | Dimension |
| DeviceOS | String | Dimension |
| AccountId | Integer | Dimension |
| TimePeriod | String | Dimension |
| AveragePosition | Float | Metric |
| CampaignName | String | Dimension |
| City | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Conversions | Integer | Metric |
| CostPerAssist | String | Dimension |
| CostPerConversion | Float | Metric |
| Country | String | Dimension |
| County | String | Dimension |
| Ctr | Float | Metric |
| AverageCpc | Float | Metric |
| Assists | Integer | Metric |
| AdGroupName | String | Dimension |
| Impressions | Integer | Metric |
| AccountNumber | String | Dimension |
| MetroArea | String | Dimension |
| QueryIntentCity | String | Dimension |
| QueryIntentCountry | String | Dimension |
| QueryIntentCounty | String | Dimension |
| QueryIntentDMA | String | Dimension |
| AccountName | String | Dimension |
| QueryIntentState | String | Dimension |
| Radius | Integer | Metric |
| ReturnOnAdSpend | Float | Metric |
| Revenue | String | Dimension |
| RevenuePerAssist | String | Dimension |
| RevenuePerConversion | Float | Metric |
| Spend | Float | Metric |
| State | String | Dimension |
| CurrencyCode | String | Dimension |
Ad Extension Details
The Ad Extension Details report compares how well different versions of the ad extensions are performing with each ad. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| AdId | Integer | Dimension |
| TimePeriod | String | Dimension |
| Goal | String | Dimension |
| AdExtensionId | Integer | Dimension |
| DeviceType | String | Dimension |
| AccountId | Integer | Dimension |
| CampaignId | Integer | Dimension |
| DeviceOS | String | Dimension |
| AdGroupId | Integer | Dimension |
| AverageCpc | Float | Metric |
| AdGroupStatus | String | Dimension |
| AdGroupName | String | Dimension |
| AdStatus | String | Dimension |
| AdTitle | String | Dimension |
| AllConversionRate | String | Dimension |
| AllConversions | Integer | Metric |
| AllCostPerConversion | String | Dimension |
| AllReturnOnAdSpend | Float | Metric |
| AllRevenue | Float | Metric |
| AllRevenuePerConversion | String | Dimension |
| Assists | Integer | Metric |
| AdExtensionVersion | Integer | Metric |
| AdExtensionTypeId | Integer | Metric |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Conversions | Integer | Metric |
| CostPerAssist | String | Dimension |
| CostPerConversion | String | Dimension |
| Ctr | Float | Metric |
| ReturnOnAdSpend | Float | Metric |
| AdExtensionPropertyValue | String | Dimension |
| AccountStatus | String | Dimension |
| GoalType | String | Dimension |
| Impressions | Integer | Metric |
| AccountName | String | Dimension |
| Revenue | String | Dimension |
| RevenuePerAssist | String | Dimension |
| RevenuePerConversion | String | Dimension |
| Spend | Float | Metric |
| AdExtensionType | String | Dimension |
Ad Performance
The Ad Performance Ad Performance report determines which ads lead to clicks and conversions and which are not performing. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| AdId | Integer | Dimension |
| TimePeriod | String | Dimension |
| DeviceType | String | Dimension |
| AccountId | Integer | Dimension |
| DeviceOS | String | Dimension |
| AdGroupId | Integer | Dimension |
| CampaignId | Integer | Dimension |
| CampaignStatus | String | Dimension |
| AdGroupStatus | String | Dimension |
| AdLabels | String | Dimension |
| AdStatus | String | Dimension |
| AdTitle | String | Dimension |
| AdType | String | Dimension |
| Assists | Integer | Metric |
| AverageCpc | Float | Metric |
| AveragePosition | Float | Metric |
| AdGroupName | String | Dimension |
| CampaignName | String | Dimension |
| AdDescription | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Conversions | Integer | Metric |
| CostPerAssist | Float | Metric |
| AccountStatus | String | Dimension |
| Ctr | Float | Metric |
| CurrencyCode | String | Dimension |
| CustomParameters | String | Dimension |
| DestinationUrl | String | Dimension |
| CostPerConversion | Float | Metric |
| AccountNumber | String | Dimension |
| DisplayUrl | String | Dimension |
| FinalAppUrl | String | Dimension |
| FinalMobileUrl | String | Dimension |
| FinalUrl | String | Dimension |
| Impressions | Integer | Metric |
| Path1 | String | Dimension |
| Path2 | String | Dimension |
| ReturnOnAdSpend | Float | Metric |
| Revenue | String | Dimension |
| RevenuePerAssist | Float | Metric |
| RevenuePerConversion | Float | Metric |
| Spend | Float | Metric |
| AccountName | String | Dimension |
| TitlePart1 | String | Dimension |
| TitlePart2 | String | Dimension |
| TrackingTemplate | String | Dimension |
Conversion Performance
The Conversion Performance report is used to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion actions. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| KeywordId | Integer | Dimension |
| DeviceType | String | Dimension |
| AccountId | Integer | Dimension |
| AdGroupId | Integer | Dimension |
| TimePeriod | String | Dimension |
| AdGroupStatus | String | Dimension |
| Assists | Integer | Metric |
| AdGroupName | String | Dimension |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Conversions | Integer | Metric |
| AccountStatus | String | Dimension |
| CostPerConversion | Float | Metric |
| Ctr | Float | Metric |
| AccountNumber | String | Dimension |
| Impressions | Integer | Metric |
| Keyword | String | Dimension |
| AccountName | String | Dimension |
| KeywordStatus | String | Dimension |
| ReturnOnAdSpend | Float | Metric |
| Revenue | String | Dimension |
| RevenuePerAssist | Float | Metric |
| RevenuePerConversion | Float | Metric |
| Spend | Float | Metric |
| CostPerAssist | Float | Metric |
Search Query Performance
The Search Query Performance report shows what the audience is searching for when the ads are shown. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| SearchQuery | String | Dimension |
| KeywordId | Integer | Dimension |
| DeviceType | String | Dimension |
| AdGroupCriterionId | String | Dimension |
| AdGroupId | Integer | Dimension |
| DeviceOS | String | Dimension |
| AccountId | Integer | Dimension |
| AdId | Integer | Dimension |
| TimePeriod | String | Dimension |
| AdType | String | Dimension |
| Assists | Integer | Metric |
| AverageCpc | Float | Metric |
| AveragePosition | Float | Metric |
| AdStatus | String | Dimension |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| CampaignType | String | Dimension |
| Clicks | Integer | Metric |
| AdGroupStatus | String | Dimension |
| Conversions | Integer | Metric |
| CostPerAssist | String | Dimension |
| CostPerConversion | Float | Metric |
| Ctr | Float | Metric |
| DestinationUrl | String | Dimension |
| AdGroupName | String | Dimension |
| AccountStatus | String | Dimension |
| Impressions | Integer | Metric |
| Keyword | String | Dimension |
| AccountNumber | String | Dimension |
| KeywordStatus | String | Dimension |
| ReturnOnAdSpend | Float | Metric |
| Revenue | String | Dimension |
| RevenuePerAssist | String | Dimension |
| RevenuePerConversion | Float | Metric |
| AccountName | String | Dimension |
| Spend | Float | Metric |
| ConversionRate | String | Dimension |
Campaign Performance
The Campaign Performance report shows high-level performance statistics and quality attributes for each campaign or account. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| DeviceType | String | Dimension |
| DeviceOS | String | Dimension |
| CustomerId | Integer | Dimension |
| AccountId | Integer | Dimension |
| TimePeriod | String | Dimension |
| AveragePosition | Float | Metric |
| AverageCpc | Float | Metric |
| CampaignLabels | String | Dimension |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Assists | Integer | Metric |
| CostPerConversion | Float | Metric |
| Ctr | Float | Metric |
| CurrencyCode | String | Dimension |
| AccountStatus | String | Dimension |
| CustomerName | String | Dimension |
| AccountNumber | String | Dimension |
| AccountName | String | Dimension |
| Impressions | Integer | Metric |
| QualityScore | Integer | Metric |
| Revenue | String | Dimension |
| Spend | Float | Metric |
| Conversions | Integer | Metric |
| CampaignType | String | Dimension |
Goals And Funnels
The Goals And Funnels report is used to discover whether the audience completes each step through the land, browse, prospect, and conversion pages of the website. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| TimePeriod | String | Dimension |
| KeywordId | Integer | Dimension |
| AdGroupId | Integer | Dimension |
| GoalId | Integer | Dimension |
| DeviceType | String | Dimension |
| DeviceOS | String | Dimension |
| AccountId | Integer | Dimension |
| Assists | Integer | Metric |
| CampaignName | String | Dimension |
| AllRevenue | Float | Metric |
| AllConversions | Integer | Metric |
| Goal | String | Dimension |
| AdGroupName | String | Dimension |
| GoalType | String | Dimension |
| Keyword | String | Dimension |
| AccountNumber | String | Dimension |
| KeywordStatus | String | Dimension |
| AccountName | String | Dimension |
| ViewThroughConversions | Integer | Metric |
Account Performance
The Account Performance report is used to observe long-term account performance and trends. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| AccountId | Integer | Dimension |
| CostPerConversion | Float | Metric |
| AccountNumber | String | Dimension |
| AccountStatus | String | Dimension |
| Assists | Integer | Metric |
| AverageCpc | Float | Metric |
| AveragePosition | Float | Metric |
| Clicks | Integer | Metric |
| Conversions | Integer | Metric |
| AccountName | String | Dimension |
| Ctr | Float | Metric |
| CurrencyCode | String | Dimension |
| DeviceOS | String | Dimension |
| DeviceType | String | Dimension |
| Impressions | Integer | Metric |
| Revenue | String | Dimension |
| Spend | Float | Metric |
| TimePeriod | String | Metric |
Ad Group Performance
The Ad Group Performance report broadly compares delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| DeviceType | String | Dimension |
| DeviceOS | String | Dimension |
| AccountId | Integer | Dimension |
| AdGroupId | Integer | Dimension |
| TimePeriod | String | Dimension |
| Assists | Integer | Metric |
| AverageCpc | Float | Metric |
| AveragePosition | Float | Metric |
| AdGroupName | String | Dimension |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| AccountStatus | String | Dimension |
| Conversions | Integer | Metric |
| CostPerConversion | Float | Metric |
| Ctr | Float | Metric |
| CurrencyCode | String | Dimension |
| AccountNumber | String | Dimension |
| AccountName | String | Dimension |
| Impressions | Integer | Metric |
| QualityScore | Integer | Metric |
| Revenue | String | Dimension |
| Spend | Float | Metric |
| Clicks | Integer | Metric |
Keyword Performance
The Keyword Performance report is used to determine which keywords are performing well and which are not. The only customization is the incremental load type associated with this report.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| CampaignId | Integer | Dimension |
| TimePeriod | String | Dimension |
| KeywordId | Integer | Dimension |
| DeviceType | String | Dimension |
| AdGroupId | Integer | Dimension |
| DeviceOS | String | Dimension |
| AccountId | Integer | Dimension |
| AdId | Integer | Dimension |
| AdGroupStatus | String | Dimension |
| AdType | String | Dimension |
| Assists | Integer | Metric |
| AverageCpc | Float | Metric |
| AveragePosition | Float | Metric |
| BidStrategyType | String | Dimension |
| AdRelevance | Integer | Metric |
| CampaignName | String | Dimension |
| CampaignStatus | String | Dimension |
| Clicks | Integer | Metric |
| ConversionRate | String | Dimension |
| Conversions | Integer | Metric |
| CostPerAssist | Float | Metric |
| CostPerConversion | Float | Metric |
| Ctr | Float | Metric |
| CurrencyCode | String | Dimension |
| CurrentMaxCpc | Float | Metric |
| CustomParameters | String | Dimension |
| DestinationUrl | String | Dimension |
| AdGroupName | String | Dimension |
| AccountStatus | String | Dimension |
| ExpectedCtr | Integer | Metric |
| FinalAppUrl | String | Dimension |
| FinalMobileUrl | String | Dimension |
| FinalUrl | String | Dimension |
| HistoricalAdRelevance | Integer | Metric |
| HistoricalExpectedCtr | Integer | Metric |
| HistoricalLandingPageExperience | Integer | Metric |
| HistoricalQualityScore | Integer | Metric |
| Impressions | Integer | Metric |
| Keyword | String | Dimension |
| AccountNumber | String | Dimension |
| KeywordStatus | String | Dimension |
| LandingPageExperience | Integer | Metric |
| QualityImpact | Integer | Metric |
| QualityScore | Integer | Metric |
| ReturnOnAdSpend | Float | Metric |
| Revenue | String | Dimension |
| RevenuePerAssist | Float | Metric |
| RevenuePerConversion | Float | Metric |
| Spend | Float | Metric |
| AccountName | String | Dimension |
| TrackingTemplate | String | Dimension |
