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
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