Release Notes

November 2024

We have updated the Quickstart packages for the following connectors:

Amplitude to version 0.5.0
Apple Search Ads to version 0.4.1
Facebook Ads to version 0.8.0
HubSpot to version 0.20.0
Iterable to version 0.13.0
Jira to version 0.19.0
LinkedIn Ad Analytics to version 0.9.1
Recurly to version 0.5.1
Reddit Ads to version 0.3.1
Zendesk Support to version 0.18.1

* 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.

October 2024

We have added the responseId column to the LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS table.

We have changed the composite primary key of the LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS table. The new composite key is a combination of the leadFormResponseId, responseId, and index columns.

July 2024

LinkedIn has deprecated the approximate_unique_impressions field and replaced it with approximate_member_reach in the following tables:

AD_ANALYTICS_BY_CAMPAIGN
AD_ANALYTICS_BY_CREATIVE
AD_ANALYTICS_BY_CREATIVE_WITH_CONVERSION_BREAKDOWN
MONTHLY_AD_ANALYTICS_BY_MEMBER_COMPANY
MONTHLY_AD_ANALYTICS_BY_MEMBER_COMPANY_SIZE
MONTHLY_AD_ANALYTICS_BY_MEMBER_COUNTRY
MONTHLY_AD_ANALYTICS_BY_MEMBER_INDUSTRY
MONTHLY_AD_ANALYTICS_BY_MEMBER_JOB_FUNCTION
MONTHLY_AD_ANALYTICS_BY_MEMBER_JOB_TITLE
MONTHLY_AD_ANALYTICS_BY_MEMBER_REGION
MONTHLY_AD_ANALYTICS_BY_MEMBER_SENIORITY

March 2024

We have added the following new tables:

LEAD_FORM_RESPONSE
LEAD_FORM_RESPONSE_ANSWER
LEAD_FORM_RESPONSE_CONSENT
LEAD_FORM_RESPONSE_MULTIPLE_CHOICE_ANSWERS

NOTE: You need to re-authorize your existing LinkedIn Ad Analytics connectors to access this data.

January 2024

We now retrieve Posts and Shares by the reference field from the CREATIVE_HISTORY table using the /posts endpoint.

To store this new data, we have added the following tables:

Expand for the full list of new tables and their columns

CAROUSEL_CARD
- _fivetran_id 🔑
- media_id 🔑
- landing_page
- media_alt_text
- media_title
- type
CREATIVE_HISTORY
- id 🔑
- last_modified_at 🔑
- account_id
- campaign_id
- created_at
- created_by
- follower_callToAction
- follower_description
- follower_headline
- follower_logo
- follower_organizationName
- follower_show_member_profile_photo
- inline_content
- intended_status
- is_serving
- jobs_button_label
- jobs_headline
- jobs_logo
- jobs_organizationName
- jobs_show_member_profile_photo
- last_modified_by
- reference
- review_status
- spotlight_callToAction
- spotlight_description
- spotlight_headline
- spotlight_landingPage
- spotlight_logo
- spotlight_organizationName
- spotlight_show_member_profile_photo
- text_ad_description
- text_ad_headline
- text_ad_image
- text_ad_landingPage
CONTENT
- _fivetran_id 🔑
- post_id 🔑
- article_description
- article_source
- article_thumbnail
- article_thumbnail_alt_text
- article_title
- carousel_id
- media_alt_text
- media_id
- media_title
- multi_image_alt_text
- poll_question
- poll_settings_duration
- poll_settings_is_voter_visible_to_author
- poll_settings_vote_selection_type
- poll_unique_voters_count
- reference_id
- type
- type_of_content
CONTENT_POLL_OPTION
- _fivetran_id 🔑
- text 🔑
- is_voted_by_viewer
- type
- vote_count
DISTRIBUTION_TARGET_INDUSTRY
- post_id 🔑
- post_last_modified_time 🔑
- industry_id 🔑
- type
DISTRIBUTION_TARGET_INTERFACE_LOCALE
- post_id 🔑
- post_last_modified_time 🔑
- country
- language
- type
DISTRIBUTION_TARGET_JOB_FUNCTION
- post_id 🔑
- post_last_modified_time 🔑
- function_id 🔑
- type
DISTRIBUTION_TARGET_LOCATION
- post_id 🔑
- post_last_modified_time
- location
- type
DISTRIBUTION_TARGET_SENIORITY
- post_id 🔑
- post_last_modified_time 🔑
- seniority_id 🔑
- type
DISTRIBUTION_TARGET_STAFF_COUNT_RANGE
- post_id 🔑
- post_last_modified_time 🔑
- staff_count_range
- type
MULTI_IMAGE
- _fivetran_id 🔑
- id 🔑
- alt_text
- title
- type
POST_HISTORY
- id 🔑
- last_modified_time 🔑
- ad_context_dsc_ad_account
- ad_context_dsc_ad_type
- ad_context_dsc_name
- ad_context_dsc_status
- ad_context_is_dsc
- author
- commentary
- container_entity
- content_call_to_action_label
- content_landing_page
- created_time
- distribution_external_distribution_channels
- distribution_feed_distribution
- first_published_at
- is_reshare_disabled_by_author
- lifecycle_state
- lifecycle_state_info_content_status
- lifecycle_state_info_is_edited_by_author
- lifecycle_state_info_review_status
- response_context_parent
- response_context_root
- type
- visibility

We have added the following new tables:

LEAD_FORM_HISTORY
LEAD_FORM_CONSENT
LEAD_FORM_HIDDEN_FIELD
LEAD_FORM_MULTIPLE_CHOICE_QUESTION_OPTION
LEAD_FORM_QUESTION
LEAD_FORM_REJECTION_REASON

We have added two new tables, SPONSORED_MESSAGE_CONTENT and SPONSORED_MESSAGE_OPTION.

October 2023

We have set timeGranularity to MONTHLY for Demographic reports, according to LinkedIn's recommendations. As a part of this change, we have made the following schema changes:

We have added the following tables:
- MONTHLY_AD_ANALYTICS_BY_MEMBER_COMPANY
- MONTHLY_AD_ANALYTICS_BY_MEMBER_COMPANY_SIZE
- MONTHLY_AD_ANALYTICS_BY_MEMBER_COUNTRY_V2
- MONTHLY_AD_ANALYTICS_BY_MEMBER_INDUSTRY
- MONTHLY_AD_ANALYTICS_BY_MEMBER_JOB_FUNCTION
- MONTHLY_AD_ANALYTICS_BY_MEMBER_JOB_TITLE
- MONTHLY_AD_ANALYTICS_BY_MEMBER_REGION_V2
- MONTHLY_AD_ANALYTICS_BY_MEMBER_SENIORITY
We have deprecated the following tables:
- 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

July 2023

We no longer maintain the VIDEO_AD_HISTORY table due to the LinkedIn API deprecation.

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.

April 2023

We have added a new field, Historical Sync Time Frame, to the connector setup form. If you are using an existing connector, you can edit the connector and set the value. The default value is ALL_TIME. We have also added support for the timeframe_months field for connectors created using the Create a Connector endpoint. For more information, see our REST API config.

January 2023

We have migrated from the Industries API to the new Industry Taxonomy Versions API.

We now use the LinkedIn Marketing APIs 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 REST API configuration, 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 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.

We have expanded the public API endpoints Create a Connector and Modify a Connector. Now you can authorize the following connectors by adding the auth section to payloads:

November 2020

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 2020

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 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 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 2020

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 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 LinkedIn's API documentation for more details.

October 2019

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 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 tables. 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

May 2019

We have dropped the following fields from the AD_ANALYTICS_BY_CAMPAIGN and AD_ANALYTICS_BY_CREATIVE tables because values for them were coming in as null:

video_mid_point_completions
viral_video_mid_point_completions
viral_comments_likes

We have replaced the dropped fields with the following fields to match with the source:

video_midpoint_completions
viral_video_midpoint_completions
viral_comment_likes

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.

Read our LinkedIn Ad Analytics connector documentation.

October 2018

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