Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

Bing Ads - Schema Information

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Saras Pulse

    • Saras Daton

      Need help with something?

      Talk to data expert

      Bing Ads - Schema Information

      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.

      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/accountperformancereportrequest?view=bingads-12

      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AdDistribution
      STRING
      Impressions
      STRING
      Clicks
      STRING
      Ctr
      STRING
      AverageCpc
      STRING
      Spend
      STRING
      AveragePosition
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      AccountStatus
      STRING
      BidMatchType
      STRING
      CurrencyCode
      STRING
      CustomerId
      STRING
      CustomerName
      STRING
      DeviceOS
      STRING
      DeliveredMatchType
      STRING
      DeviceType
      STRING
      Network
      STRING
      TopVsOther
      STRING
      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
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/adextensiondetailreportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AccountId
      STRING
      AccountStatus
      STRING
      AdExtensionId
      STRING
      AdExtensionPropertyValue
      STRING
      AdExtensionType
      STRING
      AdExtensionTypeId
      STRING
      AdExtensionVersion
      STRING
      AdGroupName
      STRING
      AdGroupId
      STRING
      AdGroupStatus
      STRING
      AdId
      STRING
      AdStatus
      STRING
      AdTitle
      STRING
      Assists
      STRING
      AverageCpc
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Clicks
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      DeliveredMatchType
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      Impressions
      STRING
      Network
      STRING
      ReturnOnAdSpend
      STRING
      Revenue
      STRING
      RevenuePerAssist
      STRING
      RevenuePerConversion
      STRING
      Spend
      STRING
      TimePeriod
      STRING
      TopVsOther
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/adextensionbykeywordreportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AccountId
      STRING
      AccountStatus
      STRING
      AdExtensionId
      STRING
      AdExtensionType
      STRING
      AdExtensionVersion
      STRING
      AdGroupName
      STRING
      AdGroupId
      STRING
      AdGroupStatus
      STRING
      AverageCpc
      STRING
      BidMatchType
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Clicks
      STRING
      ClickType
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      DeliveredMatchType
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      Impressions
      STRING
      Keyword
      STRING
      KeywordId
      STRING
      KeywordStatus
      STRING
      Network
      STRING
      ReturnOnAdSpend
      STRING
      Revenue
      STRING
      RevenuePerAssist
      STRING
      RevenuePerConversion
      STRING
      Spend
      STRING
      TimePeriod
      STRING
      TopVsOther
      STRING
      TotalClicks
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/keywordperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AccountId
      STRING
      TimePeriod
      STRING
      CampaignName
      STRING
      CampaignId
      STRING
      AdGroupName
      STRING
      AdGroupId
      STRING
      Keyword
      STRING
      KeywordId
      STRING
      AdId
      STRING
      AdType
      STRING
      DestinationUrl
      STRING
      CurrentMaxCpc
      STRING
      CurrencyCode
      STRING
      DeliveredMatchType
      STRING
      AdDistribution
      STRING
      Impressions
      STRING
      Clicks
      STRING
      Ctr
      STRING
      AverageCpc
      STRING
      Spend
      STRING
      AveragePosition
      STRING
      Conversions
      STRING
      ConversionRate
      STRING
      CostPerConversion
      STRING
      BidMatchType
      STRING
      DeviceType
      STRING
      QualityScore
      STRING
      ExpectedCtr
      STRING
      AdRelevance
      STRING
      LandingPageExperience
      STRING
      Language
      STRING
      QualityImpact
      STRING
      CampaignStatus
      STRING
      AccountStatus
      STRING
      AdGroupStatus
      STRING
      KeywordStatus
      STRING
      Network
      STRING
      TopVsOther
      STRING
      DeviceOS
      STRING
      Assists
      STRING
      Revenue
      STRING
      ReturnOnAdSpend
      STRING
      CostPerAssist
      STRING
      RevenuePerConversion
      STRING
      RevenuePerAssist
      STRING
      TrackingTemplate
      STRING
      CustomParameters
      STRING
      FinalUrl
      STRING
      FinalMobileUrl
      STRING
      FinalAppUrl
      STRING
      BidStrategyType
      STRING
      KeywordLabels
      STRING
      Mainline1Bid
      STRING
      MainlineBid
      STRING
      FirstPageBid
      STRING
      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
       
      Fields
      Name
      Target Datatype
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      AdGroupCriterionId
      STRING
      AdGroupId
      STRING
      AdGroupName
      STRING
      AdGroupStatus
      STRING
      AdId
      STRING
      AdStatus
      STRING
      AdType
      STRING
      Assists
      STRING
      AverageCpc
      STRING
      AveragePosition
      STRING
      BidMatchType
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      CampaignType
      STRING
      Clicks
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      CustomerId
      STRING
      CustomerName
      STRING
      DeliveredMatchType
      STRING
      DestinationUrl
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      Impressions
      STRING
      Keyword
      STRING
      KeywordId
      STRING
      KeywordStatus
      STRING
      Language
      STRING
      Network
      STRING
      ReturnOnAdSpend
      STRING
      Revenue
      STRING
      RevenuePerAssist
      STRING
      RevenuePerConversion
      STRING
      SearchQuery
      STRING
      Spend
      STRING
      TimePeriod
      STRING
      TopVsOther
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/conversionperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AccountId
      STRING
      TimePeriod
      STRING
      CampaignName
      STRING
      CampaignId
      STRING
      AdGroupName
      STRING
      AdGroupId
      STRING
      Keyword
      STRING
      KeywordId
      STRING
      Impressions
      STRING
      Clicks
      STRING
      Ctr
      STRING
      Assists
      STRING
      Conversions
      STRING
      ConversionRate
      STRING
      Spend
      STRING
      Revenue
      STRING
      ReturnOnAdSpend
      STRING
      CostPerConversion
      STRING
      CostPerAssist
      STRING
      RevenuePerConversion
      STRING
      RevenuePerAssist
      STRING
      DeviceType
      STRING
      CampaignStatus
      STRING
      AdGroupStatus
      STRING
      KeywordStatus
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/goalsandfunnelsreportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      _sdc_report_datetime
      STRING
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      AdGroupId
      STRING
      AdGroupName
      STRING
      AdGroupStatus
      STRING
      Assists
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Conversions
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      Goal
      STRING
      GoalId
      STRING
      GoalType
      STRING
      Keyword
      STRING
      KeywordId
      STRING
      KeywordStatus
      STRING
      Revenue
      STRING
      TimePeriod
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/geographicperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AudienceAdsBidAdjustment
      STRING
      BiddingScheme
      STRING
      BudgetId
      STRING
      BudgetType
      STRING
      CampaignType
      STRING
      DailyBudget
      STRING
      Description
      STRING
      ForwardCompatibilityMap
      STRING
      Id
      STRING
      Languages
      STRING
      Name
      STRING
      Settings
      STRING
      Status
      STRING
      SubType
      STRING
      TimeZone
      STRING
      TrackingUrlTemplate
      STRING
      UrlCustomParameters
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/campaignperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      AdDistribution
      STRING
      BidMatchType
      STRING
      BudgetName
      STRING
      BudgetStatus
      STRING
      CampaignId
      STRING
      CampaignLabels
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Clicks
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      CurrencyCode
      STRING
      CustomerId
      STRING
      CustomerName
      STRING
      CustomParameters
      STRING
      DeliveredMatchType
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      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.
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/audienceperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      AdGroupId
      STRING
      AdGroupName
      STRING
      AdGroupStatus
      STRING
      AudienceId
      STRING
      AudienceName
      STRING
      AudienceType
      STRING
      AverageCpc
      STRING
      AveragePosition
      STRING
      BidAdjustment
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Clicks
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      Impressions
      STRING
      ReturnOnAdSpend
      STRING
      Revenue
      STRING
      RevenuePerConversion
      STRING
      Spend
      STRING
      TargetingSetting
      STRING
      TimePeriod
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/agegenderaudiencereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      EstimatedClickPercent
      STRING
      EstimatedClicks
      STRING
      EstimatedConversionRate
      STRING
      EstimatedConversions
      STRING
      EstimatedCtr
      STRING
      EstimatedImpressionPercent
      STRING
      EstimatedImpressions
      STRING
      Gender
      STRING
      Language
      STRING
      TimePeriod
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/adperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountId
      STRING
      AccountName
      STRING
      AccountNumber
      STRING
      AccountStatus
      STRING
      AdDescription
      STRING
      AdDistribution
      STRING
      AdGroupId
      STRING
      AdGroupName
      STRING
      AdGroupStatus
      STRING
      AdId
      STRING
      AdLabels
      STRING
      AdStatus
      STRING
      AdTitle
      STRING
      AdType
      STRING
      Assists
      STRING
      AverageCpc
      STRING
      AveragePosition
      STRING
      BidMatchType
      STRING
      BusinessName
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      Clicks
      STRING
      ConversionRate
      STRING
      Conversions
      STRING
      CostPerAssist
      STRING
      CostPerConversion
      STRING
      Ctr
      STRING
      CurrencyCode
      STRING
      CustomerId
      STRING
      CustomerName
      STRING
      CustomParameters
      STRING
      DeliveredMatchType
      STRING
      DestinationUrl
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      DisplayUrl
      STRING
      FinalAppUrl
      STRING
      FinalMobileUrl
      STRING
      FinalUrl
      STRING
      Headline
      STRING
      Impressions
      STRING
      Language
      STRING
      LongHeadline
      STRING
      Network
      STRING
      Path1
      STRING
      Path2
      STRING
      ReturnOnAdSpend
      STRING
      Revenue
      STRING
      RevenuePerAssist
      STRING
      RevenuePerConversion
      STRING
      Spend
      STRING
      TimePeriod
      STRING
      TitlePart1
      STRING
      TitlePart2
      STRING
      TopVsOther
      STRING
      TrackingTemplate
      STRING
      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.
       
      Source API Documentation https://docs.microsoft.com/en-us/bingads/reporting-service/adgroupperformancereportrequest?view=bingads-12
       
      Replication: Key-Based Replication
       
      Replication Key: ReportTime
       
      Fields
      Name
      Target Datatype
      AccountName
      STRING
      AccountNumber
      STRING
      AccountId
      STRING
      AccountStatus
      STRING
      AdDistribution
      STRING
      AdGroupName
      STRING
      AdGroupId
      STRING
      AdGroupLabels
      STRING
      Status
      STRING
      AdRelevance
      STRING
      BidMatchType
      STRING
      CampaignId
      STRING
      CampaignName
      STRING
      CampaignStatus
      STRING
      CurrencyCode
      STRING
      CustomerId
      STRING
      CustomerName
      STRING
      CustomParameters
      STRING
      DeliveredMatchType
      STRING
      DeviceOS
      STRING
      DeviceType
      STRING
      ExpectedCtr
      STRING
      Impressions
      STRING
      TimePeriod
      STRING
      ads information bing schema

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Bing Ads: Setup Instructions
      • Essential Attributes and Supported Tables for Bing Ads

      Table of Contents

      Tables/APIs Bing Ads Data

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand