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:

• AdGroupPerformanceReportRequest

• AdPerformanceReportRequest

• CampaignPerformanceReportRequest

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
• Ads
• Ads Performance
• Campaigns

Ad Groups

• Endpoint: AdGroupPerformanceReportRequest
• Update Method: UPSERT

• Table Name: [bing_ads.ad_groups]

CSV Header	Database Column
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]

CSV Header	Database Column
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]

CSV Header	Database Column
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]

CSV Header	Database Column
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