Schema Information for Bing Ads
Schema Information for Bing Ads
In this article, we will look at the schema information of the supported APIs and tables for Bing Ads.
Find the links to other articles related to Bing Ads Below:
Tables/APIs
The following is the list of tables or APIs associated with the Bing Ads connector:
- AccountPerformanceReport
- AdExtensionDetailReport
- AdExtensionByKeywordReport
- KeywordPerformanceReport
- SearchQueryPerformanceReport
- ConversionPerformanceReport
- GoalsAndFunnelsReport
- GeographicPerformanceReport
- CampaignPerformanceReport
- AudiencePerformanceReport
- AgeGenderDemographicReport
- AdPerformanceReport
- AdGroupPerformanceReport
Bing Ads Data
AccountPerformanceReport
Purpose: Use this report to observe long-term account performance and trends. You can
request impressions, impression share (%), clicks, spending, and average cost per click for
individual accounts. Once downloaded, this data can be sorted by individual accounts,
currency, bid match type, and delivered match type.
AdExtensionDetailReport
Purpose: Use this report to discover the effectiveness of individual ad extension items, for example each link of a sitelink extension. You can request impressions, clicks, spend, and average cost per click of individual extension items. Once downloaded, this data can be sorted by the individual ad extension display name, ad extension ID, and ad extension type
Replication: Key-Based Replication
AdExtensionByKeywordReport
Purpose: Use this report to compare how well different versions of your ad extensions are performing for each keyword. You can request impressions, clicks, spend, and average cost per click of your extensions for each keyword. Once downloaded, this data can be sorted by keyword, keyword ID, ad extension type, and ad extension version.valid across the ad sets within that campaign.
Replication: Key-Based Replication
KeywordPerformanceReport
Purpose: Use this report to find out which keywords are performing well and those that are not. You can request impressions, clicks, spend, and average cost per click for your landing pages. Once downloaded, this data can be sorted by keyword, account, campaign, and ad group.
Replication: Key-Based Replication
SearchQueryPerformanceReport
Purpose: Use this report to see what your audience is searching for when your ads are shown. You can use this information to make informed additions, removals, or edits to both your keyword and negative keyword lists. You can request impressions, clicks, click-through rate, and average position for search terms that have triggered your ads.
Source API Documentation https://docs.microsoft.com/en-us/bingads/guides/report-types?view=bingads-12
Replication: Key-Based Replication
Replication Key: ReportTime
Schema Details: Download Excel
ConversionPerformanceReport
Purpose: Use this report to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion action. For more information, see Track sales and other conversions. You can request conversions, assists, revenue, and revenue per conversion for your campaigns. Once downloaded, this data can be sorted by account, ad group, campaign, keyword, and device type.
Replication: Key-Based Replication
GoalsAndFunnelsReport
Purpose: Use this report to discover whether your audience completes each step through the land, browse, prospect, and conversion pages of your website. For example, you can use this report to determine the step that users leave the conversion funnel, so that you can improve or remove that step to increase the chance that the user will continue to the next step. For more information, see Track sales and other conversions. You can request spend, revenue, assists, conversions, and conversion steps of your websites. Once downloaded, this data can be sorted by account, ad group, campaign, keyword, and goal.
Replication: Key-Based Replication
GeographicPerformanceReport
Purpose: Use this report to see which locations your traffic is coming from. You can then validate whether your location targeting strategy is successful, and identify opportunities to improve. The report also identifies either the physical location of the search user or the geographical location interest based on the user's search query. You can request impressions, clicks, spend, and average cost per click for each ad group, organized by city, country, metro area (Nielsen DMA® in the United States), radius, state, and account.
Replication: Key-Based Replication
CampaignPerformanceReport
Purpose: Use this report to view high-level performance statistics and quality attributes for each campaign or account. This is also a quick way to flag any major campaign or account problems. You can request impressions, impression share (%), clicks, spend, and average cost per click for each campaign or account. Once downloaded, this data can be sorted by campaign, campaign status, and quality score.
Replication: Key-Based Replication
Replication Key: ReportTime
Schema Details: Download Excel
AudiencePerformanceReport
Purpose: Use this report to compare delivery performance statistics by audience, ad group, campaign, or account attributes. You can request impressions, clicks, spend, and average cost per click. Once downloaded, this data can be sorted by audience, association status, ad group, and targeting setting.
Replication: Key-Based Replication
AgeGenderDemographicReport
Purpose: To discover how your campaigns and ad groups are resonating with different age groups and genders. You can request impressions, clicks, spend, and average cost-per-click for each ad group, organized by gender and age group. Please note that this report only reflects your Audience Campaign data.
Replication: Key-Based Replication
AdPerformanceReport
Purpose: Use this report to help you determine which ads lead to clicks and conversions, and which are not performing. Having underperforming ads in your account can pull down the quality of your campaigns. You can request impressions, clicks, spend, and average cost per click for each ad. Once downloaded, this data can be sorted by ad ID, ad status, ad title, display URL, and destination URL.
Replication: Key-Based Replication
Replication Key: ReportTime
Schema Details: Download Excel
AdGroupPerformanceReport
Purpose: Use this report to more broadly compare delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level. You can request impressions, impression share (%), clicks, spend, and average cost per click of your ad groups. Once downloaded, this data can be sorted by ad group, ad group status, language, and network. You can request impressions, impression share (%), clicks, spend, and average cost per click of your ad groups. Once downloaded, this data can be sorted by ad group, ad group status, language, and network.
Replication: Key-Based Replication
