 7 Minutes to read

Print

DarkLight

PDF
Bing Ads Predefined Reports
 7 Minutes to read

Print

DarkLight

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.
SourceLevel Selections
Bing Ads has two sourcelevel 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  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 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  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 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  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 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  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 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  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 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  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 can be used to view highlevel 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  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 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  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 can be used to observe longterm account performance and trends. The only customization is the type of incremental load 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 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  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 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  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 