Connector Improvement: Microsoft Advertising: Additional Fields
AnsweredHi Fivetran Team!
We are hoping to get a few fields added to the Microsoft Ads (Bing) connector. Having these fields will allow us to connect to our Google Analytics data giving us a better idea of how Bing ads are performing against other ads.
If we could get the fields FinalUrlSuffix and UrlCustomParameters add to the tables campaign_history, ad_group_history and ad_history that would give us the key we need to connect the sources.
Microsoft Documentation
- Campaigns: https://docs.microsoft.com/en-us/advertising/campaign-management-service/campaign?view=bingads-13
- Ad Group: https://docs.microsoft.com/en-us/advertising/campaign-management-service/adgroup?view=bingads-13
- Ad: https://docs.microsoft.com/en-us/advertising/campaign-management-service/ad?view=bingads-13
In addition, we have a few dynamic ads where the urls are blank in the ad_history table. If we could get the following fields in the ad_performance_daily_report that would be great. (based on https://docs.microsoft.com/en-us/advertising/reporting-service/adperformancereportcolumn?view=bingads-13)
- DestinationUrl
- FinalMobileUrl
- FinalUrl
- FinalUrlSuffix
- TrackingTemplate
- CustomParameters
-
Official comment
Hi all,
Luke from the Product team here. We've added the request for the FinalUrlSuffix and UrlCustomParameters fields to be added to the schema to our backlog.
We'll prioritize this request based on customer demand. Please upvote this feature request if you're interested.
Thank you,
Luke -
Just wanted to follow up with this one.
-
Hi Kristen Allcorn, Drew from the product team here.
Thanks for this feature request and thank you for providing the links to the relevant documentation! These seem like fairly straightforward fields to add to the campaign_history, ad_group_history, and ad_history tables.
Could you provide a bit more detail on why you would like these fields in ad_performance_daily_report? Is this just due to the fields not being provided properly in the ad_history table? Typically we avoid providing this type of data in a report type table because it leads to denormalization.
-
Hi all,
We reviewed Microsoft's docs and confirmed that final_url_suffix can be added: https://learn.microsoft.com/en-us/advertising/bulk-service/campaign?view=bingads-13#finalurlsuffix. It's currently in our backlog.
There is ambiguity for url_custom_parameters. There isn't a corresponding field in Microsoft's documentation: https://learn.microsoft.com/en-us/advertising/bulk-service/campaign?view=bingads-13. However, we see the following code snippet on that page:
// 'Custom Parameter' column header in the Bulk file UrlCustomParameters = new CustomParameters { // Each custom parameter is delimited by a semicolon (;) in the Bulk file Parameters = new[] { new CustomParameter(){ Key = "promoCode", Value = "PROMO1" }, new CustomParameter(){ Key = "season", Value = "summer" }, }, },So, if url_custom_parameters is the same as custom_parameters - https://learn.microsoft.com/en-us/advertising/bulk-service/campaign?view=bingads-13#customparameter, we already sync it for the campaign_history table. But since this parameter contains many key-value pairs, we store them in the separate table campaign_custom_parameter_history.
Please sign in to leave a comment.
Comments
4 comments