Integration Specifications
Integration Overview
Bing is a place people go to search for information, places, products, and more, so this is where brands want to make sure they have a presence. Show up when users search in text, product listing, video ads, and more with Ads.
The Daasity Bing Ads integration extracts key advertising information from the Microsoft Ads platform, like spend, clicks, and impressions.
Integration Availability
This integration is available for:
Enterprise
Growth
API Endpoints
This extractor is based on this Microsoft Ads Reporting API documentation. The following endpoints are used to replicate data into Daasity:
Entity Relationship Diagram (ERD)
Bing Ads Schema
The Bing Ads extractor creates these tables using the endpoints and replication methods listed. The data is mapped from source API endpoint to the table based on the mapping logic outlined in each table.
Ad Groups
Endpoint: AdGroupPerformanceReportRequest
Update Method: UPSERT
Table Name: [
bing_ads.ad_groups]
AdGroupId
ad_group_id
CampaignId
campaign_id
AdGroupLabels
ad_group_labels
AdGroupName
ad_group_name
AdGroupType
ad_group_type
CustomParameters
custom_parameters
FinalUrlSuffix
final_url_suffix
Status
status
TrackingTemplate
tracking_template
Spend
spend
Daasity Merchant Account ID
_account_id
Bing Ads Account ID
__source_id
MD5(ad_id + __source_id)
__sync_key
Timestamp when loaded into DB
__synced_at
Ads
Endpoint: AdPerformanceReportRequest
Update Method: UPSERT
Table Name: [
bing_ads.ads]
AdDescription
ad_description
AdDescription2
ad_description2
AdGroupId
ad_group_id
AdId
ad_id
AdLabels
ad_labels
AdStatus
ad_status
AdTitle
ad_title
AdType
ad_type
DestinationUrl
destination_url
FinalMobileUrl
final_mobile_url
FinalUrl
final_url
FinalUrlSuffix
final_url_suffix
Headline
headline
LongHeadline
long_headline
Path1
path1
Path2
path2
Spend
spend
TitlePart1
title_part1
TitlePart2
title_part2
TitlePart3
title_part3
Daasity Merchant Account ID
_account_id
Bing Ads Account ID
__source_id
MD5(ad_id + __source_id)
__sync_key
Timestamp when loaded into DB
__synced_at
Ads Performance
Endpoint: AdPerformanceReportRequest
Update Method: UPSERT
Table Name: [
bing_ads.ads_performance_report]
AdId
ad_id
AdDistribution
ad_distribution
BidMatchType
bid_match_type
CurrencyCode
currency_code
DeliveredMatchType
delivered_match_type
DeviceType
device_type
TimePeriod
time_period
TopVsOther
top_vs_other
AccountId
account_id
AdGroupId
ad_group_id
BaseCampaignId
base_campaign_id
CampaignId
campaign_id
AllConversions
all_conversions
AllConversionsQualified
all_conversions_qualified
AllRevenue
all_revenue
Assists
assists
Clicks
clicks
CompletedVideoViews
completed_video_views
Conversions
conversions
ConversionsQualified
conversions_qualified
Impressions
impressions
Revenue
revenue
Spend
spend
TotalWatchTimeInMS
total_watch_time_in_ms
VideoViews
video_views
VideoViewsAt25Percent
video_views_at25_percent
VideoViewsAt50Percent
video_views_at50_percent
VideoViewsAt75Percent
video_views_at75_percent
ViewThroughConversions
view_through_conversions
ViewThroughConversionsQualified
view_through_conversions_qualified
ViewThroughRevenue
view_through_revenue
FinalUrl
final_url
Daasity Merchant Account ID
_account_id
Bing Ads Account ID
__source_id
MD5(ad_id + __source_id)
__sync_key
Timestamp when loaded into DB
__synced_at
Campaigns
Endpoint: CampaignPerformanceReportRequest
Update Method: UPSERT
Table Name: [
bing_ads.campaigns]
CampaignId
campaign_id
AccountId
account_id
CampaignLabels
campaign_labels
CampaignName
campaign_name
CampaignStatus
campaign_status
CampaignType
campaign_type
CustomParameters
custom_parameters
FinalUrlSuffix
final_url_suffix
TrackingTemplate
tracking_template
Spend
spend
Daasity Merchant Account ID
_account_id
Bing Ads Account ID
__source_id
MD5(ad_id + __source_id)
__sync_key
Timestamp when loaded into DB
__synced_at
Last updated