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