Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Microsoft Ads - Missing Reports & Fields

Completed
Anoop Kumar User

The below reports are not available in the fivetran ERD. Kindly onboard at the earliest

  • BudgetSummaryReport,
  • DestinationUrlPerformance,
  • AdDistributionReport,
  • AudiencePerformanceReport

 Also in any of the campaign tables which are part of the Fivetran ERD, following fields are not available.

  • budget_type
  • bid_strategy_id
  • bid_strategy_name
  • start_date
  • end_date
  • custom_parameter
  • base_campaign_id

Please sign in to leave a comment.

Comments

8 comments

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi all,

    Luke from the Product team here. Thanks for submitting and tracking this feature request. We added budget_type, bid_strategy_id, bid_strategy_name, and several other fields to the CAMPAIGN_HISTORY table. You can see our release notes here. I marked this feature request as completed. 

    Cheers,
    Luke

  • Lucas Alexander Fivetranner
    • Edited

    Hi Anoop, Luke from the Product team here!

    Regarding the campaign table fields you mentioned:

    • We plan to add budget_type, bid_strategy_id, and bid_strategy_name.
    • Microsoft doesn't list start_date and end_date in the docs for Campaigns. They are available for Ad Groups, so we have them in our AD_GROUP_HISTORY table.
    • custom_parameter is supported, but since it contains several values instead of one, these values are stored in a separate table: CAMPAIGN_CUSTOM_PARAMETER_HISTORY.
    • base_campaign_id isn't listed as a field in the API docs for Campaigns. Please let me know if you see a field on that docs page corresponding to base_campaign_id and we're missing it.

    Regarding the reports you requested:

    • We plan to add DestinationUrlPerformance and AudiencePerformanceReport this quarter.
    • We plan to add BudgetSummaryReport next quarter (ending April 30th, 2024)
    • Microsoft doesn't list AdDistributionReport in the Report Types in the API docs. AdDistributionReportFilter is a supported filter that you can apply to the AdDistribution column. The AdDistribution column is available in several reports that we provide (e.g. ACCOUNT_PERFORMANCE_DAILY_REPORT). We don't use this filter, so we obtain data for both types of Ads in reports: Audience and Search. 
  • Lucas Alexander Fivetranner
    • Edited

    Hi all,

    We added Audience Performance, Destination URL Performance, and Budget Summary reports to our schema. You can see the complete list of new tables in our changelog here.

    I'm leaving this feature request open because we haven't released budget_type, bid_strategy_id, and bid_strategy_name, but they are on our roadmap. 

    Cheers,
    Luke

  • Anoop Kumar User

    What is the approx ETA for the ones which are pending  budget_type, bid_strategy_id, and bid_strategy_name

  • Lucas Alexander Fivetranner

    We plan to work on these missing fields in one of the next two sprints, so approximately one month.

  • Anoop Kumar User

    Hi Team what is the ETA for these fields budget_type, bid_strategy_id, and bid_strategy_name? 

  • Lucas Alexander Fivetranner

    Hi Anoop,

    Thanks for your patience. We have this assigned to the current sprint. If there are no complications this will be rolled out in 2-3 weeks.

    Luke

  • Anoop Kumar User

    Hi Lucas,
    AS per this report Campaigns 

    i see fields like target_setting, experiment_id and  ad_schedule_use_searcher_time_zone. But these fields are not visible in any of the Fivetran reports. Can it be onboarded