- 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.

## 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 | 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 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 | 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 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 | 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 |