Skip to main content

Release Notes

Justin Stevenson
Updated

Release Notes

July 2023

We have stopped maintaining the VIDEO_AD_HISTORY table due to the .

June 2023

We have fixed a bug where the values of the sub_content_regular_call_to_action_landing_page column in the IN_MAIL_CONTENT_HISTORY table always were NULL. We have renamed the column to sub_content_regular_call_to_action_landing_page_url, and it should now be populated by the actual values moving forward.

January 2023

We have migrated from the to the new .

We now use the for our LinkedIn connectors and have made the following schema changes:

  • We have added the following new columns to the CREATIVE_HISTORY table:

    • id 🔑
    • last_modified_at 🔑
    • account_id
    • call_to_action
    • campaign_id
    • click_uri
    • created_at
    • created_by
    • follower_description
    • follower_headline
    • follower_logo
    • follower_organization_name
    • follower_show_member_profile_photo
    • inline_content
    • intended_status
    • is_serving
    • jobs_button_label
    • jobs_headline
    • jobs_logo
    • jobs_organization_name
    • jobs_show_member_profile_photo
    • last_modified_by
    • reference
    • review_status
    • spotlight_description
    • spotlight_headline
    • spotlight_logo
    • spotlight_organization_name
    • spotlight_show_member_profile_photo
    • text_ad_description
    • text_ad_headline
    • text_ad_image

    NOTE: We sync the call-to-action data into the call_to_action column and the click URI data for text and spotlight ads into the click_uri column.

  • We have added the following new columns to the IN_MAIL_CONTENT_HISTORY table:

    • id 🔑
    • last_modified_at 🔑
    • account
    • created_at
    • created_by
    • creative_id
    • html_body
    • last_modified_by
    • name
    • sender
    • sub_content_regular_call_to_action_text
    • sub_content_regular_call_to_action_landing_page
    • sub_content_regular_call_to_action_right_rail_ad_picture
    • sub_content_form_call_to_action_text
    • sub_content_form_right_rail_ad_picture
    • sub_content_guided_replies_sponsored_conversation
    • sub_content_guided_replies_right_rail_ad_picture
    • subject

November 2022

In the LinkedIn Ad Analytics , we have removed the 90-day option from the postClickAttributionWindowSize and viewThroughAttributionWindowSize fields because data older than 30 days cannot be updated.

September 2022

We now sync the CREATIVE_AND_CONVERSION two-dimensional report. We have added the following tables for the two-dimensional report data:

  • AD_ANALYTICS_BY_CREATIVE_AND_CONVERSION
  • CONVERSION_HISTORY
  • CONVERSION_ASSOCIATED_CAMPAIGNS

August 2022

We now sync the following demographic reports:

  • AD_ANALYTICS_BY_MEMBER_COMPANY
  • AD_ANALYTICS_BY_MEMBER_COMPANY_SIZE
  • AD_ANALYTICS_BY_MEMBER_COUNTRY_V2
  • AD_ANALYTICS_BY_MEMBER_INDUSTRY
  • AD_ANALYTICS_BY_MEMBER_JOB_FUNCTION
  • AD_ANALYTICS_BY_MEMBER_JOB_TITLE
  • AD_ANALYTICS_BY_MEMBER_REGION_V2
  • AD_ANALYTICS_BY_MEMBER_SENIORITY

We have added the following tables for the demographic report data:

  • INDUSTRY
  • FUNCTION
  • GEO
  • ORGANIZATION
  • TITLE
  • SENIORITY

June 2022

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 2020

We have added support for in the SponsoredUpdateCreativeVariables, SponsoredVideoCreativeVariables, and SponsoredUpdateCarouselCreativeVariables creatives of the CREATIVE table.

We have added support for . We have added a new child table, IN_MAIL_CONTENT, to the CREATIVE table.

November 2020

We have removed the following fields from the ACCOUNT_HISTORY table because :

  • total_budget_amount
  • total_budget_ends_at
  • total_budget_currency_code

August 2020

We have released pre-built, dbt Core-compatible data models for LinkedIn Ad Analytics. Find the models in or . Learn more about our dbt Core integration in our *.

* 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 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' worth of data from the reporting tables.

To learn more, see our .

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 2020

You can now configure your LinkedIn Ad Analytics connector using the . This feature is in BETA and is available only for Standard and Enterprise accounts.

February 2020

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 for more details.

October 2019

Fivetran now requests the following read-only permissions to support changes that :

  • 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 2019

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 2019

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.

October 2018

You can now sync all campaigns for a specific ad account without having to select them manually in our setup form.

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk