LinkedIn Ad Analytics Release Notes

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 accounts
• r_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.