Skip to content
Book a demoStart free
Connectors

LinkedIn Ads connector

Set up the LinkedIn Ads connector in Kaivo: authentication, configuration, the 18 BigQuery tables it syncs, and answers to common questions.

LinkedIn Ads connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your LinkedIn Ads data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your marketing and sales data instead of moving it.

Sync your LinkedIn Ads campaigns, spend, and conversions into BigQuery with Kaivo to track performance alongside your other marketing channels.

CategoryMarketing & Sales
AuthenticationOAuth
SetupSelf-service

Getting started with the LinkedIn Ads connector

Section titled “Getting started with the LinkedIn Ads connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your LinkedIn Ads account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Connect by signing in to your LinkedIn Ads account. Kaivo runs the connection for you, so you never share a password.

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

| | Account ID |

Specify the account ID to pull data from. To locate the ID:

  1. Sign in to LinkedIn Campaign Manager.
  2. The account ID number is in the upper-left corner of the page, below the account name.
  3. To see your other ad accounts, click the account name. The account ID number appears below each name.

|

Tables and columns synced from LinkedIn Ads

Section titled “Tables and columns synced from LinkedIn Ads”

Kaivo syncs 18 tables from LinkedIn Ads into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

account_users (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account STRING The account associated with the user
created TIMESTAMP The date and time when the user account was created
last_modified TIMESTAMP The date and time when the user account was last modified
role STRING The role assigned to the user in the account
user STRING The user details including name, email, etc.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accounts (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
test BOOL Flag indicating if the account is in a test mode.
notified_on_creative_rejection BOOL Flag for notifications on creative rejection.
notified_on_new_features_enabled BOOL Flag for notifications on new features being enabled.
notified_on_end_of_campaign BOOL Flag for notifications on the end of campaign.
notified_on_campaign_optimization BOOL Flag for notifications on campaign optimization.
type STRING The type or category of the account.
version__version_tag STRING The version tag associated with the account.
reference STRING A reference identifier for the account.
notified_on_creative_approval BOOL Flag for notifications on creative approval.
created TIMESTAMP The timestamp indicating when the account was created.
last_modified TIMESTAMP The timestamp of the last modification made to the account.
name STRING The name of the account.
currency STRING The currency used for financial transactions in the account.
id INT64 The unique identifier for the account.
status STRING The status of the account.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • accounts__serving_statuses (4 columns)
ad_campaign_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_campaign_analytics__pivot_values (4 columns)
ad_creative_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_creative_analytics__pivot_values (4 columns)
ad_impression_device_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_impression_device_analytics__pivot_values (4 columns)
ad_member_company_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_company_analytics__pivot_values (4 columns)
ad_member_company_size_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_company_size_analytics__pivot_values (4 columns)
ad_member_country_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_country_analytics__pivot_values (4 columns)
ad_member_industry_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_industry_analytics__pivot_values (4 columns)
ad_member_job_function_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_job_function_analytics__pivot_values (4 columns)
ad_member_job_title_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_job_title_analytics__pivot_values (4 columns)
ad_member_region_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_region_analytics__pivot_values (4 columns)
ad_member_seniority_analytics (100 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_clicks FLOAT64 The number of clicks on action buttons in the ad.
ad_unit_clicks FLOAT64 The number of clicks on ad unit components.
approximate_member_reach FLOAT64 An approximation of unique ad impressions.
card_clicks FLOAT64 The number of clicks on interactive card elements.
card_impressions FLOAT64 The number of times interactive cards were displayed.
clicks FLOAT64 Total number of clicks on the ad.
comment_likes FLOAT64 The count of likes on comments related to the ad.
comments FLOAT64 The number of comments on the ad.
company_page_clicks FLOAT64 Clicks on the company page associated with the ad.
conversion_value_in_local_currency FLOAT64 Conversion value in the local currency.
cost_in_local_currency FLOAT64 Cost of ad campaign in the local currency.
cost_in_usd FLOAT64 Cost of ad campaign in USD.
document_completions FLOAT64 Number of completions for document views.
document_first_quartile_completions FLOAT64 Completions for first quartile of document views.
document_midpoint_completions FLOAT64 Completions for midpoint of document views.
document_third_quartile_completions FLOAT64 Completions for third quartile of document views.
download_clicks FLOAT64 Clicks on download links in the ad.
end_date DATE End date of the ad analytics data.
external_website_conversions FLOAT64 Conversions that lead to external websites.
external_website_post_click_conversions FLOAT64 Post-click conversions on external websites.
external_website_post_view_conversions FLOAT64 Post-view conversions on external websites.
follows FLOAT64 Number of follows generated by the ad.
full_screen_plays FLOAT64 Number of times videos were played in fullscreen mode.
impressions FLOAT64 Total number of times the ad was displayed.
… and 75 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • ad_member_seniority_analytics__pivot_values (4 columns)
campaign_groups (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
run_schedule__start INT64 The start date and time of the campaign group run schedule.
run_schedule__end INT64 The end date and time of the campaign group run schedule.
created TIMESTAMP The date and time when the campaign group was created.
last_modified TIMESTAMP The date and time when the campaign group was last modified.
name STRING Name of the campaign group.
test BOOL Indicates if the campaign group is a test campaign.
total_budget__amount STRING The total budget amount.
total_budget__currency_code STRING The currency code of the total budget.
backfilled BOOL Indicates if the campaign group was backfilled.
id INT64 Unique identifier for the campaign group.
account STRING The account associated with the campaign group.
status STRING Current status of the campaign group.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • campaign_groups__serving_statuses (4 columns)
  • campaign_groups__allowed_campaign_types (4 columns)
campaigns (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type of campaign.
locale__country STRING The country setting for the campaign.
locale__language STRING The language setting for the campaign.
version__version_tag STRING The version tag for the campaign.
associated_entity STRING The entity associated with the campaign.
run_schedule__start INT64 The start date of the campaign schedule.
run_schedule__end INT64 The end date of the campaign schedule.
optimization_target_type STRING The type of optimization target for the campaign.
created TIMESTAMP The date and time when the campaign was created.
last_modified TIMESTAMP The date and time when the campaign was last modified.
campaign_group STRING The group to which the campaign belongs.
daily_budget__amount STRING The daily budget amount for the campaign.
daily_budget__currency_code STRING The currency code for the daily budget amount.
total_budget__amount STRING The total budget amount.
total_budget__currency_code STRING The currency code for the total budget amount.
unit_cost__amount STRING The unit cost amount.
unit_cost__currency_code STRING The currency code for the unit cost amount.
creative_selection STRING Information about the creative selection for the campaign.
cost_type STRING The type of cost associated with the campaign.
name STRING The name of the campaign.
offsite_delivery_enabled BOOL Indicates if offsite delivery is enabled for the campaign.
id INT64 The unique identifier of the campaign.
audience_expansion_enabled BOOL Indicates if audience expansion is enabled for this campaign.
test BOOL Indicates if the campaign is a test campaign.
… and 7 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • campaigns__targeting_criteria__include__and (4 columns)
  • campaigns__targeting_criteria__include__and__values (4 columns)
  • campaigns__targeting_criteria__exclude__or (4 columns)
  • campaigns__targeting_criteria__exclude__or__values (4 columns)
  • campaigns__serving_statuses (4 columns)
  • campaigns__offsite_preferences__iab_categories__exclude (4 columns)
  • campaigns__offsite_preferences__publisher_restriction_files__include (4 columns)
  • campaigns__offsite_preferences__publisher_restriction_files__exclude (4 columns)
conversions (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attribution_type STRING The type of attribution for the conversion.
account STRING The account associated with the conversion data.
created INT64 Timestamp of when the conversion was created.
enabled BOOL Flag indicating if the conversion tracking is enabled.
id INT64 Unique identifier for the conversion.
image_pixel_tag STRING Pixel tag used for tracking the conversion.
name STRING Name of the conversion.
type STRING Type of conversion.
latest_first_party_callback_at INT64 Timestamp of the latest first-party callback for the conversion.
post_click_attribution_window_size INT64 Window size for post-click attribution.
view_through_attribution_window_size INT64 Window size for view-through attribution.
last_callback_at INT64 Timestamp of the last callback for the conversion.
last_modified INT64 Timestamp of the last modification made to the conversion.
value__amount STRING Numeric value of the amount.
value__currency_code STRING Currency code of the value.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • conversions__campaigns (4 columns)
  • conversions__associated_campaigns (4 columns)
  • conversions__url_match_rule_expression (4 columns)
  • conversions__url_rules (4 columns)
creatives (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
last_modified_at INT64 The timestamp when the creative was last modified.
last_modified_by STRING The user who last modified the creative.
created_at INT64 The timestamp when the creative was created.
is_test BOOL Boolean indicating if the creative is a test creative.
created_by STRING The user who created the creative.
review__status STRING The current status of the creative review.
name STRING The name of the creative.
is_serving BOOL Boolean indicating if the creative is currently serving.
campaign STRING The campaign to which the creative belongs.
id STRING The unique identifier of the creative.
intended_status STRING The intended status of the creative.
account STRING The account associated with the creative.
leadgen_call_to_action__destination STRING The destination for the call-to-action.
leadgen_call_to_action__label STRING The label of the call-to-action.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • creatives__serving_hold_reasons (4 columns)
  • creatives__review__rejection_reasons (4 columns)
lead_forms (10 columns), Lead Forms are used to request data from members responding to the Lead Form.Lead Forms can include multiple questions, hidden fields, and custom consent checkboxes.Many of these components are structured as sub-objects of the Lead Form.For details: https://learn.microsoft.com/en-us/linkedin/marketing/lead-sync/leadsync?view=li-lms-2025-02&tabs=http#lead-form-schema
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Numerical identifier for the form.
name STRING Name of the Lead Form provided by the owner.
owner__sponsored_account STRING
state STRING Information about the current state of the Lead Form.
created INT64 An epoch time corresponding to the creation of the form.
last_modified INT64 An epoch time corresponding to the last modified of of the form.
version_id INT64 The version ID of the form. This is a derived field and is generated on the server side.
version_tag STRING The number of times the form has been modified.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • lead_forms__content__questions (10 columns)
  • lead_forms__hidden_fields (5 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where LinkedIn Ads supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for LinkedIn Ads?

Section titled “How long does the initial sync take for LinkedIn Ads?”

It depends on how much history is in your LinkedIn Ads account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when LinkedIn Ads’s schema changes?

Section titled “What happens when LinkedIn Ads’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in LinkedIn Ads, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in LinkedIn Ads instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the LinkedIn Ads connector in Kaivo and all of its synced data is deleted with it.

Use ad_campaign_analytics to track impressions, clicks, spend, and conversions by campaign.

Analyse lead_forms and conversions to measure cost per lead and lead quality.

Combine LinkedIn Ads with your other ad platforms in BigQuery for one view.

Report on creative analytics to see which creatives perform best.

Use LinkedIn Ads data in your AI and BI tools

Section titled “Use LinkedIn Ads data in your AI and BI tools”

Once LinkedIn Ads data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with LinkedIn Ads data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for LinkedIn Ads connector pricing and plan details.