Bing Ads Predefined Reports
  • 7 Minutes to read
  • Dark
    Light
  • PDF

Bing Ads Predefined Reports

  • Dark
    Light
  • PDF

Article summary

Predefined Reports

The Bing Ads datasource in Rivery comes with the below predefined reports. Each report will have 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 a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

Bing Ads has two source-level selections: Accounts and Customers. These options will filter down each report within the river to only the selected data.

Budget Summary

The Budget Summary report can be used to discover how the campaign's budget is performing for the month. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
AccountId system schemaIntegerDimension
Date system schemaStringDimension
CampaignId system schemaIntegerDimension
AccountNumberStringDimension
CampaignNameStringDimension
CurrencyCodeStringDimension
DailySpendFloatMetric
AccountNameStringDimension
MonthToDateSpendFloatMetric
MonthlyBudgetFloatMetric

User Location Performance

The User Location Performance report can be used to see where the traffic is coming from broken out by the physical location and the location for which people are searching. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
QueryIntentLocationId system schemaIntegerDimension
LocationId system schemaIntegerDimension
AdGroupId system schemaIntegerDimension
DeviceType system schemaStringDimension
DeviceOS system schemaStringDimension
AccountId system schemaIntegerDimension
TimePeriod system schemaStringDimension
AveragePositionFloatMetric
CampaignNameStringDimension
CityStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
ConversionsIntegerMetric
CostPerAssistStringDimension
CostPerConversionFloatMetric
CountryStringDimension
CountyStringDimension
CtrFloatMetric
AverageCpcFloatMetric
AssistsIntegerMetric
AdGroupNameStringDimension
ImpressionsIntegerMetric
AccountNumberStringDimension
MetroAreaStringDimension
QueryIntentCityStringDimension
QueryIntentCountryStringDimension
QueryIntentCountyStringDimension
QueryIntentDMAStringDimension
AccountNameStringDimension
QueryIntentStateStringDimension
RadiusIntegerMetric
ReturnOnAdSpendFloatMetric
RevenueStringDimension
RevenuePerAssistStringDimension
RevenuePerConversionFloatMetric
SpendFloatMetric
StateStringDimension
CurrencyCodeStringDimension

Ad Extension Details

The Ad Extension Details report can be used to compare how well different versions of the ad extensions are performing with each ad. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
AdId system schemaIntegerDimension
TimePeriod system schemaStringDimension
Goal system schemaStringDimension
AdExtensionId system schemaIntegerDimension
DeviceType system schemaStringDimension
AccountId system schemaIntegerDimension
CampaignId system schemaIntegerDimension
DeviceOS system schemaStringDimension
AdGroupId system schemaIntegerDimension
AverageCpcFloatMetric
AdGroupStatusStringDimension
AdGroupNameStringDimension
AdStatusStringDimension
AdTitleStringDimension
AllConversionRateStringDimension
AllConversionsIntegerMetric
AllCostPerConversionStringDimension
AllReturnOnAdSpendFloatMetric
AllRevenueFloatMetric
AllRevenuePerConversionStringDimension
AssistsIntegerMetric
AdExtensionVersionIntegerMetric
AdExtensionTypeIdIntegerMetric
CampaignNameStringDimension
CampaignStatusStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
ConversionsIntegerMetric
CostPerAssistStringDimension
CostPerConversionStringDimension
CtrFloatMetric
ReturnOnAdSpendFloatMetric
AdExtensionPropertyValueStringDimension
AccountStatusStringDimension
GoalTypeStringDimension
ImpressionsIntegerMetric
AccountNameStringDimension
RevenueStringDimension
RevenuePerAssistStringDimension
RevenuePerConversionStringDimension
SpendFloatMetric
AdExtensionTypeStringDimension

Ad Performance

The Ad Performance report can be used to help determine which ads lead to clicks and conversions, and which are not performing. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
AdId system schemaIntegerDimension
TimePeriod system schemaStringDimension
DeviceType system schemaStringDimension
AccountId system schemaIntegerDimension
DeviceOS system schemaStringDimension
AdGroupId system schemaIntegerDimension
CampaignId system schemaIntegerDimension
CampaignStatusStringDimension
AdGroupStatusStringDimension
AdLabelsStringDimension
AdStatusStringDimension
AdTitleStringDimension
AdTypeStringDimension
AssistsIntegerMetric
AverageCpcFloatMetric
AveragePositionFloatMetric
AdGroupNameStringDimension
CampaignNameStringDimension
AdDescriptionStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
ConversionsIntegerMetric
CostPerAssistFloatMetric
AccountStatusStringDimension
CtrFloatMetric
CurrencyCodeStringDimension
CustomParametersStringDimension
DestinationUrlStringDimension
CostPerConversionFloatMetric
AccountNumberStringDimension
DisplayUrlStringDimension
FinalAppUrlStringDimension
FinalMobileUrlStringDimension
FinalUrlStringDimension
ImpressionsIntegerMetric
Path1StringDimension
Path2StringDimension
ReturnOnAdSpendFloatMetric
RevenueStringDimension
RevenuePerAssistFloatMetric
RevenuePerConversionFloatMetric
SpendFloatMetric
AccountNameStringDimension
TitlePart1StringDimension
TitlePart2StringDimension
TrackingTemplateStringDimension

Conversion Performance

The Conversion Performance report can be used to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion actions. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
KeywordId system schemaIntegerDimension
DeviceType system schemaStringDimension
AccountId system schemaIntegerDimension
AdGroupId system schemaIntegerDimension
TimePeriod system schemaStringDimension
AdGroupStatusStringDimension
AssistsIntegerMetric
AdGroupNameStringDimension
CampaignNameStringDimension
CampaignStatusStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
ConversionsIntegerMetric
AccountStatusStringDimension
CostPerConversionFloatMetric
CtrFloatMetric
AccountNumberStringDimension
ImpressionsIntegerMetric
KeywordStringDimension
AccountNameStringDimension
KeywordStatusStringDimension
ReturnOnAdSpendFloatMetric
RevenueStringDimension
RevenuePerAssistFloatMetric
RevenuePerConversionFloatMetric
SpendFloatMetric
CostPerAssistFloatMetric

Search Query Performance

The Search Query Performance report can be used to see what the audience is searching for when the ads are shown. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
SearchQuery system schemaStringDimension
KeywordId system schemaIntegerDimension
DeviceType system schemaStringDimension
AdGroupCriterionId system schemaStringDimension
AdGroupId system schemaIntegerDimension
DeviceOS system schemaStringDimension
AccountId system schemaIntegerDimension
AdId system schemaIntegerDimension
TimePeriod system schemaStringDimension
AdTypeStringDimension
AssistsIntegerMetric
AverageCpcFloatMetric
AveragePositionFloatMetric
AdStatusStringDimension
CampaignNameStringDimension
CampaignStatusStringDimension
CampaignTypeStringDimension
ClicksIntegerMetric
AdGroupStatusStringDimension
ConversionsIntegerMetric
CostPerAssistStringDimension
CostPerConversionFloatMetric
CtrFloatMetric
DestinationUrlStringDimension
AdGroupNameStringDimension
AccountStatusStringDimension
ImpressionsIntegerMetric
KeywordStringDimension
AccountNumberStringDimension
KeywordStatusStringDimension
ReturnOnAdSpendFloatMetric
RevenueStringDimension
RevenuePerAssistStringDimension
RevenuePerConversionFloatMetric
AccountNameStringDimension
SpendFloatMetric
ConversionRateStringDimension

Campaign Performance

The Campaign Performance report can be used to view high-level performance statistics and quality attributes for each campaign or account. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
DeviceType system schemaStringDimension
DeviceOS system schemaStringDimension
CustomerId system schemaIntegerDimension
AccountId system schemaIntegerDimension
TimePeriod system schemaStringDimension
AveragePositionFloatMetric
AverageCpcFloatMetric
CampaignLabelsStringDimension
CampaignNameStringDimension
CampaignStatusStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
AssistsIntegerMetric
CostPerConversionFloatMetric
CtrFloatMetric
CurrencyCodeStringDimension
AccountStatusStringDimension
CustomerNameStringDimension
AccountNumberStringDimension
AccountNameStringDimension
ImpressionsIntegerMetric
QualityScoreIntegerMetric
RevenueStringDimension
SpendFloatMetric
ConversionsIntegerMetric
CampaignTypeStringDimension

Goals And Funnels

The Goals and Funnels report can be 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 type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
TimePeriod system schemaStringDimension
KeywordId system schemaIntegerDimension
AdGroupId system schemaIntegerDimension
GoalId system schemaIntegerDimension
DeviceType system schemaStringDimension
DeviceOS system schemaStringDimension
AccountId system schemaIntegerDimension
AssistsIntegerMetric
CampaignNameStringDimension
AllRevenueFloatMetric
AllConversionsIntegerMetric
GoalStringDimension
AdGroupNameStringDimension
GoalTypeStringDimension
KeywordStringDimension
AccountNumberStringDimension
KeywordStatusStringDimension
AccountNameStringDimension
ViewThroughConversionsIntegerMetric

Account Performance

The Account Performance report can be used to observe long-term account performance and trends. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
AccountId system schemaIntegerDimension
CostPerConversionFloatMetric
AccountNumberStringDimension
AccountStatusStringDimension
AssistsIntegerMetric
AverageCpcFloatMetric
AveragePositionFloatMetric
ClicksIntegerMetric
ConversionsIntegerMetric
AccountNameStringDimension
CtrFloatMetric
CurrencyCodeStringDimension
DeviceOSStringDimension
DeviceTypeStringDimension
ImpressionsIntegerMetric
RevenueStringDimension
SpendFloatMetric
TimePeriodStringMetric

Ad Group Performance

The Ad Group Performance report can be used to more broadly compare delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
DeviceType system schemaStringDimension
DeviceOS system schemaStringDimension
AccountId system schemaIntegerDimension
AdGroupId system schemaIntegerDimension
TimePeriod system schemaStringDimension
AssistsIntegerMetric
AverageCpcFloatMetric
AveragePositionFloatMetric
AdGroupNameStringDimension
CampaignNameStringDimension
CampaignStatusStringDimension
AccountStatusStringDimension
ConversionsIntegerMetric
CostPerConversionFloatMetric
CtrFloatMetric
CurrencyCodeStringDimension
AccountNumberStringDimension
AccountNameStringDimension
ImpressionsIntegerMetric
QualityScoreIntegerMetric
RevenueStringDimension
SpendFloatMetric
ClicksIntegerMetric

Keyword Performance

The Keyword Performance report can be used to find out which keywords are performing well and those that are not. The only customization is the type of incremental load associated with this report.

FieldData TypeDimension/Metric
CampaignId system schemaIntegerDimension
TimePeriod system schemaStringDimension
KeywordId system schemaIntegerDimension
DeviceType system schemaStringDimension
AdGroupId system schemaIntegerDimension
DeviceOS system schemaStringDimension
AccountId system schemaIntegerDimension
AdId system schemaIntegerDimension
AdGroupStatusStringDimension
AdTypeStringDimension
AssistsIntegerMetric
AverageCpcFloatMetric
AveragePositionFloatMetric
BidStrategyTypeStringDimension
AdRelevanceIntegerMetric
CampaignNameStringDimension
CampaignStatusStringDimension
ClicksIntegerMetric
ConversionRateStringDimension
ConversionsIntegerMetric
CostPerAssistFloatMetric
CostPerConversionFloatMetric
CtrFloatMetric
CurrencyCodeStringDimension
CurrentMaxCpcFloatMetric
CustomParametersStringDimension
DestinationUrlStringDimension
AdGroupNameStringDimension
AccountStatusStringDimension
ExpectedCtrIntegerMetric
FinalAppUrlStringDimension
FinalMobileUrlStringDimension
FinalUrlStringDimension
HistoricalAdRelevanceIntegerMetric
HistoricalExpectedCtrIntegerMetric
HistoricalLandingPageExperienceIntegerMetric
HistoricalQualityScoreIntegerMetric
ImpressionsIntegerMetric
KeywordStringDimension
AccountNumberStringDimension
KeywordStatusStringDimension
LandingPageExperienceIntegerMetric
QualityImpactIntegerMetric
QualityScoreIntegerMetric
ReturnOnAdSpendFloatMetric
RevenueStringDimension
RevenuePerAssistFloatMetric
RevenuePerConversionFloatMetric
SpendFloatMetric
AccountNameStringDimension
TrackingTemplateStringDimension

Was this article helpful?