Bing Ads

Home Daton Documentation Blog
Search…
Welcome to Daton
Platform
Connectors
FAQs and Troubleshooting
Connector permissions and API Keys
Common Errors and Resolution
FAQs
Bing Ads
Bing Ads ETL connector for data replication
Snapshot
Features
Details
Release Status
Released
Source API Version
v12.0.2
Table Selection
Yes
Column Selection
Yes
Edit Integration
Yes
Replication Type Selection
No
Authentication Parameters
Bing Ads account email
Bing Ads account password
Replication Type
Key Based Incremental
Replication Key
Date
Suggested Replication Frequency
24 hrs
Tables/APIs Supported
​
AccountPerformanceReport
AdExtensionDetailReport
AdExtensionByKeywordReport
KeywordPerformanceReport
SearchQueryPerformanceReport
ConversionPerformanceReport
GoalsAndFunnelsReport
GeographicPerformanceReport
CampaignPerformanceReport
AudiencePerformanceReport
AgeGenderDemographicReport
AdPerformanceReport
AdGroupPerformanceReport
​
Integrate Bing Ads with Daton
1.Signin to Daton 
2.Select Bing Ads from Integrations page
3.Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later 
4.You will be redirected to Bing Ads login for authorizing Daton to extract data periodically
5.Post successful authentication, you will be prompted to choose from the list of available Bing Ad accounts
6.Select required tables from the available list of tables
7.Then select all required fields for each table
8.Submit the integration
Workflow
1.Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
2.Users would be able to edit/pause/re-activate/delete integration anytime
3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Bing Ads Data
AccountPerformanceReport
Purpose: Use this report to observe long-term account performance and trends. You can request impressions, impression share (%), clicks, spend, 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
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
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
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
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
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
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
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
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
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
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
LinkedIn Ads
Facebook Ads
Last modified 3yr ago
Copy link
Contents
Snapshot
Integrate Bing Ads with Daton
Workflow
Bing Ads Data