LinkedIn Ads Migration Guide

Availability

Core Standard Plus Pro Enterprise Flex Self-Managed Enterprise PyAirbyte

Support Level

Airbyte

Connector Version

5.7.0 (last updated 5 hours ago)

Sync Success Rate

High

Usage Rate

High

Data workers used

0.2 per sync (Learn more)

Definition ID

137ece28-5434-455c-8f34-69dc3782f451

Upgrading to 6.0.0

LinkedIn Ads v6.0.0 batches analytics requests for up to 50 campaigns at a time for the following streams:

• ad_campaign_analytics
• ad_creative_analytics
• ad_impression_device_analytics

This non-breaking performance improvement reduces sync time by approximately 98% for these streams on large accounts.

The breaking change in this release is limited to ad_impression_device_analytics. Its primary key now includes sponsoredCampaign, which keeps records from different campaigns with the same device type and date distinct. This fixes incomplete data in deduplication mode, where those records could previously be collapsed into one row.

Stream	Old primary key	New primary key
ad_impression_device_analytics	[string_of_pivot_values, end_date]	[string_of_pivot_values, end_date, sponsoredCampaign]

Migration steps

After upgrading, refresh the source schema for every LinkedIn Ads connection that syncs ad_impression_device_analytics:

1. In the navigation bar, select Connections, then open the affected connection.
2. Select the Schema tab.
3. Select Refresh source schema, then select OK after Airbyte detects the changes.
4. Confirm ad_impression_device_analytics is selected.
5. Select Save changes.

If ad_impression_device_analytics uses incremental append with deduplication, rebuild its destination data with the corrected primary key:

1. Select the Status tab.
2. For ad_impression_device_analytics, select the three dots (⋮), then select Refresh stream.
3. Select Refresh stream and remove records, then confirm the refresh.

This rebuild restores records that may have been collapsed under the previous primary key. Connections using append without deduplication do not have the primary-key collision and do not need to rebuild destination data.

For more information about refresh options, see Refresh data.

Upgrading to 5.0.0

With LinkedIn Ads v5.0.0, we modified primary keys for stream(s): ad_campaign_analytics, Custom Ad Analytics Reports, account_users.

This enhances data integrity and improves the efficiency of your syncs. Users with deduping enabled on those streams might have missing data as records would have been collapsed on the wrong primary key. We highly recommend initiating a connection refresh to ensure all the data is available in the destination.

• ad_campaign_analytics
• Custom Ad Analytics Reports

Old PK	New PK
[string_of_pivot_values, end_date]	[string_of_pivot_values, end_date, sponsoredCampaign]

• account_users

Old PK	New PK
[account]	[account, user]

Migration Steps

Clearing your data is required for the affected streams in order to continue syncing successfully. To clear your data for the affected streams, follow the steps below:

1. Select Connections in the main navbar and select the connection(s) affected by the update.
2. Select the Schema tab.
   1. Select Refresh source schema to bring in any schema changes. Any detected schema changes will be listed for your review.
   2. Select OK to approve changes.
3. Select Save changes at the bottom of the page.
   1. Ensure the Clear affected streams option is checked to ensure your streams continue syncing successfully with the new schema.
4. Select Save connection.

This will clear the data in your destination for the subset of streams with schema changes. After the clear succeeds, trigger a sync by clicking Sync Now. For more information on clearing your data in Airbyte, see this page.

Upgrading to 4.0.0

Version 3.X.X introduced a regression in the connector that was reverted in 4.0.0. If you were using 3.X.X, please go through the migration steps. If you were still using 2.X.X, please upgrade to 4.0.0; after that, there are no additional actions required.

Migration Steps

Clearing your data is required for the affected streams in order to continue syncing successfully. To clear your data for the affected streams, follow the steps below:

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Schema tab.
3. Uncheck all streams except the affected ones.
4. Select Save changes at the bottom of the page.
5. Select the Settings tab.
6. Press the Clear your data button.
7. Return to the Schema tab.
8. Check all your streams.

This will clear the data in your destination for the subset of streams with schema changes. After the clear succeeds, trigger a sync by clicking Sync Now. For more information on clearing your data in Airbyte, see this page.

Upgrading to 3.0.0

We're continuously striving to enhance the quality and reliability of our connectors at Airbyte. As part of our commitment to delivering exceptional service, we are transitioning source-linkedin-ads from the Python Connector Development Kit (CDK) to our innovative low-code framework. This is part of a strategic move to streamline many processes across connectors, bolstering maintainability and freeing us to focus more of our efforts on improving the performance and features of our evolving platform and growing catalog. However, due to differences between the Python and low-code CDKs, this migration constitutes a breaking change.

Migration Steps

Clearing your data is required for the affected streams in order to continue syncing successfully. To clear your data for the affected streams, follow the steps below:

1. Select Connections in the main navbar.
   1. Select the connection(s) affected by the update.
2. Select the Schema tab.
3. Uncheck all streams except the affected ones.
4. Select Save changes at the bottom of the page.
5. Select the Settings tab.
6. Press the Clear your data button.
7. Return to the Schema tab.
8. Check all your streams.

This will clear the data in your destination for the subset of streams with schema changes. After the clear succeeds, trigger a sync by clicking Sync Now. For more information on clearing your data in Airbyte, see this page.

Upgrading to 2.0.0

Version 2.0.0 introduces changes in the primary key selected for all *-analytics streams (including custom ones) from pivotValues[array of strings] to string_of_pivot_values[string] so that it is compatible with more destination types.

• "ad_campaign_analytics"
• "ad_creative_analytics"
• "ad_impression_device_analytics"
• "ad_member_company_size_analytics"
• "ad_member_country_analytics"
• "ad_member_job_function_analytics"
• "ad_member_job_title_analytics"
• "ad_member_industry_analytics"
• "ad_member_seniority_analytics"
• "ad_member_region_analytics"
• "ad_member_company_analytics"

Migration Steps

Clearing your data is required for the affected streams in order to continue syncing successfully. To clear your data for the affected streams, follow the steps below:

1. Select Connections in the main navbar and select the connection(s) affected by the update.
2. Select the Schema tab.
   1. Select Refresh source schema to bring in any schema changes. Any detected schema changes will be listed for your review.
   2. Select OK to approve changes.
3. Select Save changes at the bottom of the page.
   1. Ensure the Clear affected streams option is checked to ensure your streams continue syncing successfully with the new schema.
4. Select Save connection.

This will clear the data in your destination for the subset of streams with schema changes. After the clear succeeds, trigger a sync by clicking Sync Now. For more information on clearing your data in Airbyte, see this page.

Upgrading to 1.0.0

Version 1.0.0 introduces changes in the primary key selected for all *-analytics streams (including custom ones).

• "ad_campaign_analytics"
• "ad_creative_analytics"
• "ad_impression_device_analytics"
• "ad_member_company_size_analytics"
• "ad_member_country_analytics"
• "ad_member_job_function_analytics"
• "ad_member_job_title_analytics"
• "ad_member_industry_analytics"
• "ad_member_seniority_analytics"
• "ad_member_region_analytics"
• "ad_member_company_analytics"

Migration Steps

Clearing your data is required for the affected streams in order to continue syncing successfully. To clear your data for the affected streams, follow the steps below:

1. Select Connections in the main navbar and select the connection(s) affected by the update.
2. Select the Schema tab.
   1. Select Refresh source schema to bring in any schema changes. Any detected schema changes will be listed for your review.
   2. Select OK to approve changes.
3. Select Save changes at the bottom of the page.
   1. Ensure the Clear affected streams option is checked to ensure your streams continue syncing successfully with the new schema.
4. Select Save connection.

This will clear the data in your destination for the subset of streams with schema changes. After the clear succeeds, trigger a sync by clicking Sync Now. For more information on clearing your data in Airbyte, see this page.