Release Notes

June 2024

We have added the following new columns to the CAMPAIGN_HISTORY table:

budget_type
bid_strategy_id
bid_strategy_name
bid_strategy_target_roas
bid_strategy_target_ad_position
bid_strategy_target_impression_share

February 2024

We have added the following reporting tables:

AGE_GENDER_AUDIENCE_DAILY_REPORT
AGE_GENDER_AUDIENCE_HOURLY_REPORT
BUDGET_SUMMARY_DAILY_REPORT
DSA_AUTO_TARGET_PERFORMANCE_DAILY_REPORT
DSA_AUTO_TARGET_PERFORMANCE_HOURLY_REPORT
DSA_CATEGORY_PERFORMANCE_DAILY_REPORT
DSA_CATEGORY_PERFORMANCE_HOURLY_REPORT
DSA_SEARCH_QUERY_PERFORMANCE_DAILY_REPORT
DSA_SEARCH_QUERY_PERFORMANCE_HOURLY_REPORT
GEOGRAPHIC_PERFORMANCE_DAILY_REPORT
GEOGRAPHIC_PERFORMANCE_HOURLY_REPORT
NEGATIVE_KEYWORD_CONFLICT_REPORT
PROFESSIONAL_DEMOGRAPHICS_AUDIENCE_DAILY_REPORT
PROFESSIONAL_DEMOGRAPHICS_AUDIENCE_HOURLY_REPORT

We are gradually rolling out this change to all existing connectors.

By default, we select all new tables for the sync. You can sync them for free until March 6, 2024. Be sure to exclude the tables that you don't want to count towards paid Monthly Active Rows (MAR) before this date.

January 2024

We have added the following reporting tables:

AD_DYNAMIC_TEXT_PERFORMANCE_DAILY_REPORT
AD_DYNAMIC_TEXT_PERFORMANCE_HOURLY_REPORT
AUDIENCE_PERFORMANCE_DAILY_REPORT
AUDIENCE_PERFORMANCE_HOURLY_REPORT
CONVERSION_PERFORMANCE_DAILY_REPORT
CONVERSION_PERFORMANCE_HOURLY_REPORT
DESTINATION_URL_PERFORMANCE_DAILY_REPORT
DESTINATION_URL_PERFORMANCE_HOURLY_REPORT
PUBLISHER_USAGE_PERFORMANCE_DAILY_REPORT
PUBLISHER_USAGE_PERFORMANCE_HOURLY_REPORT

We are gradually rolling out these change to all existing connectors.

By default, we select all new tables for the sync. You can sync these tables for free until January 31, 2024. Be sure to exclude all new tables that you don't want to count towards paid Monthly Active Rows (MAR) before this date.

May 2023

We now sync Headlines and Descriptions data of Responsive Ads into the AD_ATTRIBUTE_HISTORY table.

We have added a new column, asset_performance_label, to the AD_ATTRIBUTE_HISTORY table. For more information, see Microsoft's assetPerformanceLabel documentation.

September 2022

We updated the logic of the Rollback Window Size option. The minimum available window size is now 35 days instead of 30 days.

See the Rollback sync section of our Microsoft Advertising documentation for more details about this option.

We have added the following new columns to the tables below:

TABLE	NEW COLUMNS
`ACCOUNT_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `low_quality_conversions_qualified`, `view_through_conversions_qualified`
`ACCOUNT_IMPRESSION_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `low_quality_conversions_qualified`, `view_through_conversions_qualified`
`AD_EXTENSION_DETAIL_*`	`conversions_qualified`, `all_conversions_qualified`
`AD_GROUP_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`AD_GROUP_IMPRESSION_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`CAMPAIGN_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `low_quality_conversions_qualified`, `view_through_conversions_qualified`
`CAMPAIGN_IMPRESSION_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `low_quality_conversions_qualified`, `view_through_conversions_qualified`
`PRODUCT_DIMENSION_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`SHARE_OF_VOICE_DAILY_REPORT_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`USER_LOCATION_PERFORMANCE_*`	`all_conversions_qualified`, `view_through_conversions_qualified`

February 2022

We have added the following new columns to the tables below:

TABLES	NEW COLUMNS
`AD_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, and `view_through_conversions_qualified`
`GOALS_AND_FUNNELS_*`	`all_conversions_qualified`, `view_through_conversions_qualified`
`KEYWORD_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`, `view_through_conversions_qualified`
`PRODUCT_SEARCH_QUERY_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`
`SEARCH_QUERY_PERFORMANCE_*`	`conversions_qualified`, `all_conversions_qualified`
`USER_LOCATION_PERFORMANCE_*`	`conversions_qualified`

January 2022

We have added a new column, campaign_name, to the following campaign performance report tables:

CAMPAIGN_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_PERFORMANCE_DAILY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORT

December 2021

To stay up to date with Microsoft Bulk API, we have decreased the lookback period for downloading campaigns from 90 days to 30 days. If you have paused your connector for more than 30 days, the connector may not sync older metadata changes.

October 2021

To stay up to date with Microsoft Authentication with OAuth requirements, we migrated connectors from the deprecated Live Connect APIs to the new Microsoft Identity Platform.

Now, Microsoft Advertising connectors created using our REST API and the dashboard use the Microsoft Identity Platform API endpoints for authorization. You should obtain the refresh token passed to the API using the Microsoft Identity Platform endpoints.

August 2021

Our Microsoft Advertising connector now supports multithreading. We can now use multiple parallel API requests to fetch Ads data from your Microsoft Advertising account to your destination, which makes your syncs faster. The connector’s sync speed depends on your Microsoft Advertising account metadata.

July 2021

We have added a new column, final_url_suffix, to the following tables:

AD_GROUP_PERFORMANCE_HOURLY_REPORT
AD_GROUP_PERFORMANCE_DAILY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_HOURLY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORT

To ensure data integrity, re-sync the specified tables.

April 2021

We have expanded the Create a Connector and Modify a Connector public API endpoints. Now you can authorize the following connectors by adding the auth section to payloads:

January 2021

We have added a new column, campaign_status, to the CAMPAIGN_PERFORMANCE_* and CAMPAIGN_IMPRESSION_PERFORMANCE_* tables.

We have added a new column, keyword_status, to the KEYWORD_PERFORMANCE_* tables.

December 2020

We now support the GOALS_AND_FUNNELS_HOURLY_REPORT and GOALS_AND_FUNNELS_DAILY_REPORT tables.

September 2020

We have released pre-built, dbt Core-compatible data models for Microsoft Advertising. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

July 2020

The Microsoft Advertising connector now supports priority-first sync. Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use. Microsoft Advertising's priority-first syncs fetch the most recent thirty days' worth of data from the reporting tables.

To learn more, see our priority-first sync documentation.

We have added three new tables:

AD_EXTENSION_DETAIL_HOURLY_REPORT
AD_EXTENSION_DETAIL_DAILY_REPORT
SHARE_OF_VOICE_DAILY_REPORT

We have added a new column, title_part_3, to the AD_HISTORY table.

June 2020

You can now select the *_history tables you want to sync from the Schema tab on your connector details page.

We have made multiple schema changes to support all the available fields for the reporting tables. See Microsoft’s documentation about reporting value sets.

We have added the following fields to the CAMPAIGN_PERFORMANCE_HOURLY_REPORT, CAMPAIGN_PERFORMANCE_DAILY_REPORT, AD_GROUP_PERFORMANCE_HOURLY_REPORT, AD_GROUP_PERFORMANCE_DAILY_REPORT, AD_PERFORMANCE_HOURLY_REPORT, AD_PERFORMANCE_DAILY_REPORT, KEYWORD_PERFORMANCE_HOURLY_REPORT, and KEYWORD_PERFORMANCE_DAILY_REPORT tables:

all_conversions
all_conversion_rate
all_cost_per_conversion
all_return_on_ad_spend
all_revenue
all_revenue_per_conversion
view_through_conversions

We have added the following fields to the CAMPAIGN_IMPRESSION_PERFORMANCE_HOURLY_REPORT, CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORT, AD_GROUP_IMPRESSION_PERFORMANCE_HOURLY_REPORT, and AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORT tables:

all_conversions
all_conversion_rate
all_cost_per_conversion
all_return_on_ad_spend
all_revenue
all_revenue_per_conversion
view_through_conversions
top_impression_rate_percent
top_impression_share_percent
top_impression_share_lost_to_budget_percent
top_impression_share_lost_to_rank_percent
absolute_top_impression_rate_percent
absolute_top_impression_share_lost_to_budget_percent
absolute_top_impression_share_lost_to_rank_percent

May 2020

You can now configure your Microsoft Advertising connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.

December 2019

We have added a new column, final_url_suffix, to the KEYWORD_PERFORMANCE_DAILY_REPORT and KEYWORD_PERFORMANCE_HOURLY_REPORT tables.

November 2019

We have renamed our Bing Ads connector to Microsoft Advertising, following Microsoft's name change. This name change applies to the Fivetran dashboard and our documentation.

We have upgraded our connector to use Bing Ads SDK version 13, since the previous version (v.12) has been deprecated. For more information, see Microsoft's Bing Ads API version 13 documentation.

We have made a number of schema changes to our Microsoft Advertising connector (formerly Bing Ads) to support version 13 of the Bing Ads SDK.

We have removed the click_calls and manual_calls fields from the following tables:

ACCOUNT_PERFORMANCE_DAILY_REPORT
ACCOUNT_PERFORMANCE_HOURLY_REPORT
ACCOUNT_IMPRESSION_PERFORMANCE_DAILY_REPORT
ACCOUNT_IMPRESSION_PERFORMANCE_HOURLY_REPORT
AD_GROUP_PERFORMANCE_DAILY_REPORT
AD_GROUP_PERFORMANCE_HOURLY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_PERFORMANCE_DAILY_REPORT
CAMPAIGN_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_HOURLY_REPORT

We have removed the average_cpp field from the following tables:

ACCOUNT_PERFORMANCE_DAILY_REPORT
ACCOUNT_PERFORMANCE_HOURLY_REPORT

We have removed the impression_lost_to_bid_percent, impression_lost_to_expected_ctr_percent,impression_lost_to_ad_relevance_percent, andimpression_lost_to_rank_percent fields from the following tables:

ACCOUNT_PERFORMANCE_DAILY_REPORT
ACCOUNT_PERFORMANCE_HOURLY_REPORT
ACCOUNT_IMPRESSION_PERFORMANCE_DAILY_REPORT
ACCOUNT_IMPRESSION_PERFORMANCE_HOURLY_REPORT
AD_GROUP_PERFORMANCE_DAILY_REPORT
AD_GROUP_PERFORMANCE_HOURLY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORT
AD_GROUP_IMPRESSION_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_PERFORMANCE_DAILY_REPORT
CAMPAIGN_PERFORMANCE_HOURLY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORT
CAMPAIGN_IMPRESSION_PERFORMANCE_HOURLY_REPORT

The data that was previously split amongst these four columns is now aggregated in the impression_lost_to_rank_agg_percent column.

We have added the following tables:

SEARCH_QUERY_PERFORMANCE_HOURLY_REPORT
SEARCH_QUERY_PERFORMANCE_DAILY_REPORT
PRODUCT_SEARCH_QUERY_PERFORMANCE_HOURLY_REPORT
PRODUCT_SEARCH_QUERY_PERFORMANCE_DAILY_REPORT

October 2019

You can now select how many months' worth of reporting data you'd like to include in your initial sync. Choose from the following options:

3 months
6 months (default)
12 months
24 months
All time

September 2019

We have added the following connection tests to the Microsoft Advertising setup form:

Query All Metadata: checks if all selected accounts have access to Bulk Service.
Query All Reports: checks if all selected accounts have access to Report Service.

July 2019

The Bing Ads API recently removed support for the click_type_id field with impression_* fields in the PRODUCT_DIMENSION_PERFORMANCE_REPORT table.

We removed the column click_type_id from the following tables:

PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT

March 2019

We've added the following new fields to the reporting tables below:

Reporting Table	Fields
`ACCOUNT_IMPRESSION_PERFORMANCE_DAILY_REPORT`	`absolute_top_impression_share_percent`, `click_share_percent`
`AD_GROUP_IMPRESSION_PERFORMANCE_DAILY_REPORT`	`absolute_top_impression_share_percent`, `click_share_percent`
`CAMPAIGN_IMPRESSION_PERFORMANCE_DAILY_REPORT`	`absolute_top_impression_share_percent`, `click_share_percent`
`PRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT`	`assisted_impressions`, `assisted_clicks`
`PRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORT`	`assisted_impressions`, `assisted_clicks`
`PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT`	`absolute_top_impression_share_percent`, `click_share_percent`, `assisted_impressions`, `assisted_clicks`
`PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT`	`absolute_top_impression_share_percent`, `click_share_percent`, `assisted_impressions`, `assisted_clicks`
`AD_PERFORMANCE_DAILY_REPORT`	`ad_description, ad_description_2`
`AD_PERFORMANCE_HOURLY_REPORT`	`ad_description`, `ad_description_2`

February 2019

We have added a new table, AD_ATTRIBUTE_HISTORY.

We have added support for the new Ad Type Responsive Search Ad. We have upgraded V0 of our connector to use the latest Bing Ads SDK v.12 as the previous version v.11 is deprecated.

Deprecated Fields

The AccountStatus field has been deprecated for CAMPAIGN_PERFORMANCE and AD_GROUP_PERFORMANCE report types.

Renamed Fields

The following fields have been renamed. These renamed fields are updated in your setup form but the column names in your destination remain unchanged.

Old Field Name	New Field Name
HistoricQualityScore	HistoricalQualityScore
HistoricExpectedCtr	HistoricalExpectedCtr
HistoricAdRelevance	HistoricalAdRelevance
HistoricLandingPageExperience	HistoricalLandingPageExperience
FinalAppURL	FinalAppUrl
FinalMobileURL	FinalMobileUrl
FinalURL	FinalUrl

November 2018

We have released version 2 of the Microsoft Advertising connector, which allows you to fetch HOURLY reports.

We no longer use brand as the primary key for the following tables since it can have a null value in the Bing Ads API response:

PRODUCT_DIMENSION_PERFORMANCE_HOURLY_REPORT
PRODUCT_DIMENSION_PERFORMANCE_DAILY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_HOURLY_REPORT
PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_DAILY_REPORT

This change affects version 1 and version 2 of the Bing Ads API.

September 2018

We now support the yyyy-MM-ddTHH:mm:ss time format for the last_modified_time field in the ACCOUNT table.

We have added two new tables, PRODUCT_DIMENSION_PERFORMANCE_REPORT and PRODUCT_DIMENSION_IMPRESSION_PERFORMANCE_REPORT.

August 2018

Microsoft Advertising leverages the power of data and AI technologies to create better customer experiences.

Read our Microsoft Advertising connector documentation.