Skip to main content
Documentation
Feature Requests Trust Center Status Page

Community

Connector Improvement: Microsoft Ads Improvements

Answered
Denton Anderson User

Microsoft Ads Connector // campaign_performance_daily_report: 

  • The problem: The Account Name and Campaign Name are not available columns.
  • Current workaround (partial): To get the Account Name and the Campaign Name into the campaign_performance_daily_report, one must join the account id columns to the account_history and campaign_history columns.  However, the campaign_history schema does NOT include deleted/removed campaign data.  I have been unable to find another way to include this data from Fivetran, and have resorted to merging with an offline file sourced directly from the platform where deleted items are available.

Microsoft Ads Connector // campaign_performance_daily_report 

  • The problem: The report has conversions, revenue, all conversions, and all revenue as available columns, but the goal name is not available.  If the advertiser has more than goal defined in the Microsoft Ads UI, then the data from these columns will be an aggregation of all goals.  
  • The workaround:  use the goals_and_funnels_daily_report which has goal name, all conversions, and all revenue (but does not have conversions or revenue).  Join this data with the cost, clicks, and impressions from the campaign_performance_daily_report.  However, you have to be careful because the campaign_performance_daily_report segments the data by campaign ID, by day, by device type, by device os, by network by ad distribution.  The goals_and_funnels_daily_report segments by campaign id, by day, by device type by network, by ad distribution (does not have device os), so you must first summarize the data from the campaign_performance_daily_report to remove device os before the join.  

This brings me to the last ask.  Without a custom connector to select the columns we would like, we end up with a much larger data set than is necessary because the default schemas include every single segment available vs the ones you want.  (i.e. I don't need to know/have any use for device os).  It would be extremely helpful to have a clean Custom Microsoft Ads Connector with just the fields necessary because each segmentation can easily 2x, 3x, etc the # of rows of data. 

 

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Drew Fivetranner

    Hi Denton, Drew from the Product Team here!

    Thanks for sharing this feedback, I have a few followup questions:

    The Account Name and Campaign Name are not available columns:

    • we have separated the campaign_name into the campaign_history table to preserve normalization of the data.
    • thanks for sharing information about the missing data in campaign_history. We will look into this.

    The report has conversions, revenue, all conversions, and all revenue as available columns, but the goal name is not available:

    • would exploring the addition conversions and revenue solve this problem?
    • we could also solve this with a dbt package, is that something you would find useful?
  • Denton Anderson User

    Hi Drew,

    The Account Name and Campaign Name are not available columns:

    • "we have separated the campaign_name into the campaign_history table to preserve normalization of the data."  Can you help me better understand how that helps preserve normalization of the data?
    • "thanks for sharing information about the missing data in campaign_history. We will look into this." - Thank you! 

    The report has conversions, revenue, all conversions, and all revenue as available columns, but the goal name is not available:

    • "would exploring the addition conversions and revenue solve this problem?"  Do you mean adding this to the "goals_and_funnels_daily_report" report?  If so, I think this would be a good addition.  However, this does not help solve the issue described.  The real gap is that the campaign_performance_daily_report schema simply does not contain the full data set available in the API.  Here is a link to the CampaignPerformanceReportColumn Value Set from Microsoft: https://docs.microsoft.com/en-us/advertising/reporting-service/campaignperformancereportcolumn?view=bingads-13 - To build a robust campaign report using Fivetran Data, you must rely on multiple schemas which makes it unnecessarily complicated to get a useable dataset + it dramatically increases the number of rows in each sync.
    • I have not used a dbt package before, so I am not sure if this would be helpful or not.

    Thanks,

    Denton

     

  • Russell McAthy User

    I have the same issue: Have put my comment in this thread: https://support.fivetran.com/hc/en-us/community/posts/1500000576741-Connector-Improvement-Bing-Ads-connector-ability-to-select-desired-metrics-instead-of-pulling-all-data