Connector Improvement: Microsoft Advertising: Additional Fields
Answered
Hi 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 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.
-
Just wanted to follow up with this one.
Please sign in to leave a comment.
Comments
2 comments