June 2022link
We have removed the approximate_unique_impressions
column from the AD_ANALYTICS_BY_CREATIVE
and AD_ANALYTICS_BY_CAMPAIGN
tables.
We have added the following new columns to the AD_ANALYTICS_BY_CAMPAIGN
table:
average_daily_reach_metrics_approximate_cost_in_currency_per_thousand_members_reached
average_daily_reach_metrics_approximate_frequency
average_daily_reach_metrics_approximate_reach
average_previous_seven_day_reach_metrics_approximate_cost_in_currency_per_thousand_members_reached
average_previous_seven_day_reach_metrics_approximate_frequency
average_previous_seven_day_reach_metrics_approximate_reach
average_previous_thirty_day_reach_metrics_approximate_cost_in_currency_per_thousand_members_reached
average_previous_thirty_day_reach_metrics_approximate_frequency
average_previous_thirty_day_reach_metrics_approximate_reach
December 2020link
We have added support for Share Content in the SponsoredUpdateCreativeVariables
, SponsoredVideoCreativeVariables
, and SponsoredUpdateCarouselCreativeVariables
creatives of the CREATIVE
table.
We have added support for Ad InMail Contents. We have added a new child table, IN_MAIL_CONTENT
, to the CREATIVE
table.
November 2020link
We have removed the following fields from the ACCOUNT_HISTORY
table because LinkedIn Ads has deprecated them:
total_budget_amount
total_budget_ends_at
total_budget_currency_code
August 2020link
We have released pre-built, dbt Core-compatible data models for LinkedIn Ad Analytics. 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 2020link
The LinkedIn Ad Analytics 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. LinkedIn Ad Analytics 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 the following fields to the AD_ANALYTICS_BY_CAMPAIGN
and AD_ ANALYTICS_BY_CREATIVE
tables:
comment_likes
approximate_unique_impressions
viral_external_website_conversions
viral_external_website_post_view_conversions
viral_external_website_post_click_conversions
May 2020link
You can now configure your LinkedIn Ad Analytics connector using the Fivetran REST API. This feature is in BETA and is available only for Standard and Enterprise accounts.
February 2020link
You can now choose the conversion window size for view-through attribution and post-click attribution in your Fivetran dashboard. The default values of the conversion windows are:
- View-Through Attribution: 7 days
- Post-Click Attribution: 30 days
See LinkedIn’s API documentation for more details.
October 2019link
Fivetran now requests the following read-only permissions to support changes that LinkedIn recently made to their API permissions:
r_ads
: Retrieve member’s advertising accountsr_ads_reporting
: Retrieve reporting for member’s advertising accounts
Note: You must re-authorize your LinkedIn Ad Analytics connectors in the Fivetran setup form to grant us these permissions. Re-authorizing with the new permissions will ensure your Linked In Ad Analytics connector continues to sync.
July 2019link
We have dropped some existing fields from the CREATIVE_HISTORY
table and added new fields. The new fields sync all the data that the previous fields contained. The table now supports separate fields for each creative type with added prefix.
You will need to drop the CREATIVE_HISTORY
and CREATIVE_SERVING_STATUS_HISTORY
table. The tables will get populated in next sync.
-
Fields dropped from the
CREATIVE_HISTORY
table:text
title
activity
direct_sponsored_content
share
content
media_asset
- some custom fields
-
Fields added to the
CREATIVE_HISTORY
table:text_ad_text
text_ad_title
sponsored_update_activity
sponsored_update_direct_sponsored_content
sponsored_update_share
sponsored_in_mail_content
sponsored_video_media_asset
sponsored_videuser_generated_content_post
sponsored_update_carousel_activity
sponsored_update_carousel_direct_sponsored_content
sponsored_update_carousel_share
follow_company_call_to_action
follow_company_organization_logo
follow_company_organization_name
follow_company_description
follow_company_headline
follow_company_organization
spotlight_call_to_action
spotlight_custom_background
spotlight_description
spotlight_forum_name
spotlight_headline
spotlight_logo
spotlight_show_member_profile_photo
jobs_company_name
jobs_logo
jobs_organization
jobs_button_label
jobs_headline
February 2019link
We have released a new version of the LinkedIn Ad Analytics connector.
The new version delivers Ad Analytics reports at campaign
and creative
levels.
The schema change adds metadata tables in addition to report tables.
Link to LinkedIn Ad Analytics Documentation
October 2018link
You can now sync all campaigns for a specific ad account without having to select them manually in our setup form.