Release Notes

---

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 Microsoft Advertising 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

---

September 2019

We have added the following connection tests to the Bing Ads 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

---

February 2019

Added support for the new Ad Type Responsive Search Ad. We have upgraded V0 of our Bing Ads 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

Added new table AD_ATTRIBUTE_HISTORY.

---

November 2018

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

Because the brand field can have a null value in the Bing Ads API response, it is no longer the primary key in the following tables:

• 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

Bing Ads leverages the power of data and AI technologies to create better customer experiences.

Link to Bing Ads documentation