Release Noteslink
January 2021link
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 2020link
We now support the GOALS_AND_FUNNELS_HOURLY_REPORT
and GOALS_AND_FUNNELS_DAILY_REPORT
tables.
September 2020link
We have released a pre-built dbt package for Microsoft Advertising. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.
July 2020link
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 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 2020link
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 2020link
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 2019link
We have added a new column, final_url_suffix
, to the KEYWORD_PERFORMANCE_DAILY_REPORT
and KEYWORD_PERFORMANCE_HOURLY_REPORT
tables.
November 2019link
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 2019link
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 2019link
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 2019link
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 2018link
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 2018link
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 2018link
Bing Ads leverages the power of data and AI technologies to create better customer experiences.