Skip to main content

Microsoft Advertising

Microsoft Advertising Icon

Microsoft Advertising

Generally AvailableETL Sources

Extract data from applications, files, databases, and events.

Features

Feature NameSupportedNotes
OAuth✓OAuth 2.0 authentication
Access Token✓API key or access token
Full Refresh✓Complete data reload
Incremental Sync✓Only new/updated records
Distribution Stage✓Generally Available
Dynamic Streams—
Start Date—
Column Hashing—

Sync Overview

  • Total Streams: 57
  • Parent Streams: 55
  • Sub-Streams: 2
  • Supported Sync Modes: Full Refresh, Incremental

Available Streams

  • account_history (Full Refresh)
  • account_impression_performance_daily_report (Full Refresh, Incremental)
  • account_impression_performance_hourly_report (Full Refresh, Incremental)
  • account_performance_daily_report (Full Refresh, Incremental)
  • account_performance_hourly_report (Full Refresh, Incremental)
  • ad_attribute_history (Full Refresh, Incremental)
  • ad_dynamic_text_performance_daily_report (Full Refresh, Incremental)
  • ad_dynamic_text_performance_hourly_report (Full Refresh, Incremental)
  • ad_extension_detail_daily_report (Full Refresh, Incremental)
  • ad_extension_detail_hourly_report (Full Refresh, Incremental)
  • ad_group_history (Full Refresh, Incremental)
    • ad_group_custom_parameter_history
  • ad_group_impression_performance_daily_report (Full Refresh, Incremental)
  • ad_group_impression_performance_hourly_report (Full Refresh, Incremental)
  • ad_group_label_history (Full Refresh, Incremental)
  • ad_group_performance_daily_report (Full Refresh, Incremental)
  • ad_group_performance_hourly_report (Full Refresh, Incremental)
  • ad_history (Full Refresh, Incremental)
  • ad_label_history (Full Refresh, Incremental)
  • ad_performance_daily_report (Full Refresh, Incremental)
  • ad_performance_hourly_report (Full Refresh, Incremental)
  • age_gender_audience_daily_report (Full Refresh, Incremental)
  • age_gender_audience_hourly_report (Full Refresh, Incremental)
  • audience_performance_daily_report (Full Refresh, Incremental)
  • audience_performance_hourly_report (Full Refresh, Incremental)
  • budget_history (Full Refresh, Incremental)
  • budget_summary_daily_report (Full Refresh, Incremental)
  • campaign_history (Full Refresh, Incremental)
    • campaign_custom_parameter_history
  • campaign_impression_performance_daily_report (Full Refresh, Incremental)
  • campaign_impression_performance_hourly_report (Full Refresh, Incremental)
  • campaign_label_history (Full Refresh, Incremental)
  • campaign_performance_daily_report (Full Refresh, Incremental)
  • campaign_performance_hourly_report (Full Refresh, Incremental)
  • conversion_performance_daily_report (Full Refresh, Incremental)
  • conversion_performance_hourly_report (Full Refresh, Incremental)
  • destination_url_performance_daily_report (Full Refresh, Incremental)
  • destination_url_performance_hourly_report (Full Refresh, Incremental)
  • geographic_performance_daily_report (Full Refresh, Incremental)
  • geographic_performance_hourly_report (Full Refresh, Incremental)
  • goals_and_funnels_daily_report (Full Refresh, Incremental)
  • goals_and_funnels_hourly_report (Full Refresh, Incremental)
  • keyword_history (Full Refresh, Incremental)
  • keyword_label_history (Full Refresh, Incremental)
  • keyword_performance_daily_report (Full Refresh, Incremental)
  • keyword_performance_hourly_report (Full Refresh, Incremental)
  • label_history (Full Refresh, Incremental)
  • negative_keyword_conflict_report (Full Refresh, Incremental)
  • professional_demographics_audience_daily_report (Full Refresh, Incremental)
  • professional_demographics_audience_hourly_report (Full Refresh, Incremental)
  • publisher_usage_performance_daily_report (Full Refresh, Incremental)
  • publisher_usage_performance_hourly_report (Full Refresh, Incremental)
  • search_query_performance_daily_report (Full Refresh, Incremental)
  • search_query_performance_hourly_report (Full Refresh, Incremental)
  • share_of_voice_daily_report (Full Refresh, Incremental)
  • user_location_performance_daily_report (Full Refresh, Incremental)
  • user_location_performance_hourly_report (Full Refresh, Incremental)

Next Steps