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.
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Replication: Key-Based Replication
Replication Key: ReportTime
Fields
Name
Target Datatype
AccountName
STRING
AccountNumber
STRING
AccountId
STRING
AccountStatus
STRING
AdDistribution
STRING