Connector Improvement: Add goal column to Microsoft Ads performance_report tables
The ad_performance_daily_report table has a conversions column but no goal column. The goals_and_funnels tables have a goal column, but no ad_id column (they only go as far as Ad Set). This makes it impossible for us to measure conversions x goal at the ad level. This wasn't an issue for us in the past when we only had one goal (subscriptions), so we knew that conversion = subscription. Now, we have a couple custom goals and no way to measure them independently of each other at the ad level.
Ad_id is not made available by Microsoft for use in the goals_and_funnels tables. But, the goal column is available in this report. So, it should be pretty straight forward to add it to the connector schema for the ad_performance_daily_report table.
The goal column should be added to all of the "daily_performance" tables, i.e. ad_performance_daily_report, campaign_performance_daily_report, etc.
-
Keep in mind that the goal column does not include an unique identifier for each goal. The values in that column refer to the goal name, which could vary from account to account. Thus having the goal category or goal_id, together with the goal information would be necessary to map custom conversions to their corresponding action.
-
Yes, I agree we should have it goal column in campaign_performance_daily_report
Please sign in to leave a comment.
Comments
2 comments