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

      • Saras IQ

        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