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

Bing Ads Predefined Reports

  • Dark
    Light
  • PDF

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.

Field Data Type Dimension/Metric
AccountId system schema Integer Dimension
Date system schema String Dimension
CampaignId system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
QueryIntentLocationId system schema Integer Dimension
LocationId system schema Integer Dimension
AdGroupId system schema Integer Dimension
DeviceType system schema String Dimension
DeviceOS system schema String Dimension
AccountId system schema Integer Dimension
TimePeriod system schema 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 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.

Field Data Type Dimension/Metric
AdId system schema Integer Dimension
TimePeriod system schema String Dimension
Goal system schema String Dimension
AdExtensionId system schema Integer Dimension
DeviceType system schema String Dimension
AccountId system schema Integer Dimension
CampaignId system schema Integer Dimension
DeviceOS system schema String Dimension
AdGroupId system schema 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 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.

Field Data Type Dimension/Metric
AdId system schema Integer Dimension
TimePeriod system schema String Dimension
DeviceType system schema String Dimension
AccountId system schema Integer Dimension
DeviceOS system schema String Dimension
AdGroupId system schema Integer Dimension
CampaignId system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
KeywordId system schema Integer Dimension
DeviceType system schema String Dimension
AccountId system schema Integer Dimension
AdGroupId system schema Integer Dimension
TimePeriod system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
SearchQuery system schema String Dimension
KeywordId system schema Integer Dimension
DeviceType system schema String Dimension
AdGroupCriterionId system schema String Dimension
AdGroupId system schema Integer Dimension
DeviceOS system schema String Dimension
AccountId system schema Integer Dimension
AdId system schema Integer Dimension
TimePeriod system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
DeviceType system schema String Dimension
DeviceOS system schema String Dimension
CustomerId system schema Integer Dimension
AccountId system schema Integer Dimension
TimePeriod system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
TimePeriod system schema String Dimension
KeywordId system schema Integer Dimension
AdGroupId system schema Integer Dimension
GoalId system schema Integer Dimension
DeviceType system schema String Dimension
DeviceOS system schema String Dimension
AccountId system schema 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 can be used to observe long-term account performance and trends. The only customization is the type of incremental load associated with this report.

Field Data Type Dimension/Metric
AccountId system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
DeviceType system schema String Dimension
DeviceOS system schema String Dimension
AccountId system schema Integer Dimension
AdGroupId system schema Integer Dimension
TimePeriod system schema 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 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.

Field Data Type Dimension/Metric
CampaignId system schema Integer Dimension
TimePeriod system schema String Dimension
KeywordId system schema Integer Dimension
DeviceType system schema String Dimension
AdGroupId system schema Integer Dimension
DeviceOS system schema String Dimension
AccountId system schema Integer Dimension
AdId system schema 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

Was this article helpful?