LinkedIn Ads
LinkedIn is a social networking site designed for the business community. You can use LinkedIn Ads to promote your brand, increase traffic, find new leads and more.
See the Schema section for a list of objects available for replication.复制任务： 应用更改 存储更改 在数据湖任务中登陆数据： 更改数据捕获 (CDC) 必填字段。这就是目标与源的更改保持同步的方式。 有关复制任务，请参阅计划任务 有关湖登陆任务，请参阅为湖登陆任务调度 CDC 部分支持 仅 CDC，因为满负载与此连接器无关。特性/功能 支持详情 支持的 Qlik Talend Data Integration 项目 仅 Replication 项目。不支持数据管道项目。 无需手动生成元数据。 只支持更改列数据类型操作。 复制 LOB 列（NCLOB、CLOB 和 BLOB） 不支持 已计划 CDC 通知 监视 JSON 列有效载荷的自动解密 不支持不会自动在目标上删除源数据集中的 JSON 列有效负载。
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
有关更多信息，请参阅连接到 SaaS 应用程序。
填写完所需的连接设置后，单击身份验证。
您可能会被要求登录源应用程序。
将显示一个带有身份验证代码的窗口。
将代码复制到剪贴板，然后返回到连接对话框。
粘贴使用源提供的代码完成身份验证中的代码，然后单击验证。
提示注释您可能需要向下滚动才能查看此字段。在状态为已验证时，身份验证即得到验证。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
| Setting | Description |
|---|---|
| Data gateway | 如果您的用例需要，请选择一个 数据移动网关。 信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Start Date | 按格式 |
| Accounts | A comma separated list of accounts to sync. |
| Client ID | Client ID. |
| Client Secret | Client secret. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 2.
Depending on your destination, table and column names may not appear as they are outlined below.
account_users
The account_users table contains info about the users who have permissions to an ad account.
Replication Method | CDC |
Primary Keys | account_id user_person_id |
Replication Key | last_modified_time |
| Useful links |
| Join account_users with | on |
|---|---|
| accounts | account_users.account_id = accounts.id |
| campaigns | account_users.account_id = campaigns.account_id |
| campaign_groups | account_users.account_id = campaign_groups.account_id |
| video_ads | account_users.account_id = video_ads.account_id |
account STRING |
account_id INTEGER |
campaign_contact BOOLEAN |
change_audit_stamps OBJECT This is a nested data structure:
|
created_time DATE-TIME |
last_modified_time DATE-TIME |
role STRING |
user STRING |
user_person_id STRING |
accounts
The accounts table contains info about your LinkedIn Ads ad accounts.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_time |
| Useful links |
| Join accounts with | on |
|---|---|
| account_users | accounts.id = account_users.account_id |
| campaigns | accounts.id = campaigns.account_id |
| campaign_groups | accounts.id = campaign_groups.account_id |
| video_ads | accounts.id = video_ads.account_id |
change_audit_stamps OBJECT This is a nested data structure:
|
created_time DATE-TIME |
currency STRING |
id INTEGER |
last_modified_time DATE-TIME |
name STRING |
notified_on_campaign_optimization BOOLEAN |
notified_on_creative_approval BOOLEAN |
notified_on_creative_rejection BOOLEAN |
notified_on_end_of_campaign BOOLEAN |
notified_on_new_features_enabled BOOLEAN |
reference STRING |
reference_organization_id INTEGER |
reference_person_id STRING |
serving_statuses ARRAY This is a nested data structure. |
status STRING |
test BOOLEAN |
total_budget OBJECT This is a nested data structure:
|
total_budget_ends_at DATE-TIME |
type STRING |
version OBJECT This is a nested data structure:
|
ad_analytics_by_campaign
The ad_analytics_by_campaign table contains analytics data for ads, segmented by campaign.
Note: This table is replicated using an attribution window of 7 days. Refer to the Replication section for more info.
Replication Method | CDC |
Primary Keys | campaign_id start_at |
Replication Key | end_at |
| Useful links |
action_clicks INTEGER |
ad_unit_clicks INTEGER |
approximate_unique_impressions INTEGER |
average_daily_reach_metrics OBJECT This is a nested data structure:
|
average_previous_seven_day_reach_metrics OBJECT This is a nested data structure:
|
average_previous_thirty_day_reach_metrics OBJECT This is a nested data structure:
|
campaign STRING |
campaign_id INTEGER |
card_clicks INTEGER |
card_impressions INTEGER |
clicks INTEGER |
comment_likes INTEGER |
comments INTEGER |
company_page_clicks INTEGER |
conversion_value_in_local_currency NUMBER |
cost_in_local_currency NUMBER |
cost_in_usd NUMBER |
date_range OBJECT This is a nested data structure:
|
document_completions INTEGER |
document_first_quartile_completions INTEGER |
document_midpoint_completions INTEGER |
document_third_quartile_completions INTEGER |
download_clicks INTEGER |
end_at DATE-TIME |
external_website_conversions INTEGER |
external_website_post_click_conversions INTEGER |
external_website_post_view_conversions INTEGER |
follows INTEGER |
full_screen_plays INTEGER |
impressions INTEGER |
job_applications NUMBER |
job_apply_clicks NUMBER |
landing_page_clicks INTEGER |
lead_generation_mail_contact_info_shares INTEGER |
lead_generation_mail_interested_clicks INTEGER |
likes INTEGER |
one_click_lead_form_opens INTEGER |
one_click_leads INTEGER |
opens INTEGER |
other_engagements INTEGER |
pivot STRING |
pivot_value STRING |
pivot_values ARRAY This is a nested data structure. |
post_click_job_applications NUMBER |
post_click_job_apply_clicks NUMBER |
post_click_registrations NUMBER |
post_view_job_applications NUMBER |
post_view_job_apply_clicks NUMBER |
post_view_registrations NUMBER |
reactions INTEGER |
registrations NUMBER |
sends INTEGER |
shares INTEGER |
start_at DATE-TIME |
talent_leads INTEGER |
text_url_clicks INTEGER |
total_engagements INTEGER |
video_completions INTEGER |
video_first_quartile_completions INTEGER |
video_midpoint_completions INTEGER |
video_starts INTEGER |
video_third_quartile_completions INTEGER |
video_views INTEGER |
viral_card_clicks INTEGER |
viral_card_impressions INTEGER |
viral_clicks INTEGER |
viral_comment_likes INTEGER |
viral_comments INTEGER |
viral_company_page_clicks INTEGER |
viral_document_completions INTEGER |
viral_document_first_quartile_completions INTEGER |
viral_document_midpoint_completions INTEGER |
viral_document_third_quartile_completions INTEGER |
viral_download_clicks INTEGER |
viral_external_website_conversions INTEGER |
viral_external_website_post_click_conversions INTEGER |
viral_external_website_post_view_conversions INTEGER |
viral_follows INTEGER |
viral_full_screen_plays INTEGER |
viral_impressions INTEGER |
viral_job_applications NUMBER |
viral_job_apply_clicks NUMBER |
viral_landing_page_clicks INTEGER |
viral_likes INTEGER |
viral_one_click_lead_form_opens INTEGER |
viral_one_click_leads INTEGER |
viral_other_engagements INTEGER |
viral_post_click_job_applications NUMBER |
viral_post_click_job_apply_clicks NUMBER |
viral_post_click_registrations NUMBER |
viral_post_view_job_applications NUMBER |
viral_post_view_job_apply_clicks NUMBER |
viral_post_view_registrations NUMBER |
viral_reactions INTEGER |
viral_registrations NUMBER |
viral_shares INTEGER |
viral_total_engagements INTEGER |
viral_video_completions INTEGER |
viral_video_first_quartile_completions INTEGER |
viral_video_midpoint_completions INTEGER |
viral_video_starts INTEGER |
viral_video_third_quartile_completions INTEGER |
viral_video_views INTEGER |
ad_analytics_by_creative
The ad_analytics_by_creative table contains info about ad analytics, segmented by creative.
Note: This table is replicated using an attribution window of 7 days. Refer to the Replication section for more info.
Replication Method | CDC |
Primary Keys | creative_id start_at |
Replication Key | end_at |
| Useful links |
| Join ad_analytics_by_creative with | on |
|---|---|
| creatives | ad_analytics_by_creative.creative_id = creatives.id |
action_clicks INTEGER |
ad_unit_clicks INTEGER |
approximate_unique_impressions INTEGER |
average_daily_reach_metrics OBJECT This is a nested data structure:
|
average_previous_seven_day_reach_metrics OBJECT This is a nested data structure:
|
average_previous_thirty_day_reach_metrics OBJECT This is a nested data structure:
|
card_clicks INTEGER |
card_impressions INTEGER |
clicks INTEGER |
comment_likes INTEGER |
comments INTEGER |
company_page_clicks INTEGER |
conversion_value_in_local_currency NUMBER |
cost_in_local_currency NUMBER |
cost_in_usd NUMBER |
creative STRING |
creative_id INTEGER |
date_range OBJECT This is a nested data structure:
|
document_completions INTEGER |
document_first_quartile_completions INTEGER |
document_midpoint_completions INTEGER |
document_third_quartile_completions INTEGER |
download_clicks INTEGER |
end_at DATE-TIME |
external_website_conversions INTEGER |
external_website_post_click_conversions INTEGER |
external_website_post_view_conversions INTEGER |
follows INTEGER |
full_screen_plays INTEGER |
impressions INTEGER |
job_applications NUMBER |
job_apply_clicks NUMBER |
landing_page_clicks INTEGER |
lead_generation_mail_contact_info_shares INTEGER |
lead_generation_mail_interested_clicks INTEGER |
likes INTEGER |
one_click_lead_form_opens INTEGER |
one_click_leads INTEGER |
opens INTEGER |
other_engagements INTEGER |
pivot STRING |
pivot_value STRING |
pivot_values ARRAY This is a nested data structure. |
post_click_job_applications NUMBER |
post_click_job_apply_clicks NUMBER |
post_click_registrations NUMBER |
post_view_job_applications NUMBER |
post_view_job_apply_clicks NUMBER |
post_view_registrations NUMBER |
reactions INTEGER |
registrations NUMBER |
sends INTEGER |
shares INTEGER |
start_at DATE-TIME |
talent_leads INTEGER |
text_url_clicks INTEGER |
total_engagements INTEGER |
video_completions INTEGER |
video_first_quartile_completions INTEGER |
video_midpoint_completions INTEGER |
video_starts INTEGER |
video_third_quartile_completions INTEGER |
video_views INTEGER |
viral_card_clicks INTEGER |
viral_card_impressions INTEGER |
viral_clicks INTEGER |
viral_comment_likes INTEGER |
viral_comments INTEGER |
viral_company_page_clicks INTEGER |
viral_document_completions INTEGER |
viral_document_first_quartile_completions INTEGER |
viral_document_midpoint_completions INTEGER |
viral_document_third_quartile_completions INTEGER |
viral_download_clicks INTEGER |
viral_external_website_conversions INTEGER |
viral_external_website_post_click_conversions INTEGER |
viral_external_website_post_view_conversions INTEGER |
viral_follows INTEGER |
viral_full_screen_plays INTEGER |
viral_impressions INTEGER |
viral_job_applications NUMBER |
viral_job_apply_clicks NUMBER |
viral_landing_page_clicks INTEGER |
viral_likes INTEGER |
viral_one_click_lead_form_opens INTEGER |
viral_one_click_leads INTEGER |
viral_other_engagements INTEGER |
viral_post_click_job_applications NUMBER |
viral_post_click_job_apply_clicks NUMBER |
viral_post_click_registrations NUMBER |
viral_post_view_job_applications NUMBER |
viral_post_view_job_apply_clicks NUMBER |
viral_post_view_registrations NUMBER |
viral_reactions INTEGER |
viral_registrations INTEGER |
viral_shares INTEGER |
viral_total_engagements INTEGER |
viral_video_completions INTEGER |
viral_video_first_quartile_completions INTEGER |
viral_video_midpoint_completions INTEGER |
viral_video_starts INTEGER |
viral_video_third_quartile_completions INTEGER |
viral_video_views INTEGER |
campaign_groups
The campaign_groups table contains info about the campaign groups in your LinkedIn Ads account.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_time |
| Useful links |
| Join campaign_groups with | on |
|---|---|
| account_users | campaign_groups.account_id = account_users.account_id |
| accounts | campaign_groups.account_id = accounts.id |
| campaigns | campaign_groups.account_id = campaigns.account_id campaign_groups.id = campaigns.campaign_group_id |
| video_ads | campaign_groups.account_id = video_ads.account_id |
account STRING |
account_id INTEGER |
allowed_campaign_types ARRAY This is a nested data structure. |
backfilled BOOLEAN |
change_audit_stamps OBJECT This is a nested data structure:
|
created_time DATE-TIME |
id INTEGER |
last_modified_time DATE-TIME |
name STRING |
run_schedule OBJECT This is a nested data structure:
|
serving_statuses ARRAY This is a nested data structure. |
status STRING |
test BOOLEAN |
total_budget OBJECT This is a nested data structure:
|
campaigns
The campaigns table contains info about the campaigns in your LinkedIn Ads account.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_time |
| Useful links |
| Join campaigns with | on |
|---|---|
| account_users | campaigns.account_id = account_users.account_id |
| accounts | campaigns.account_id = accounts.id |
| campaign_groups | campaigns.account_id = campaign_groups.account_id campaigns.campaign_group_id = campaign_groups.id |
| video_ads | campaigns.account_id = video_ads.account_id |
| creatives | campaigns.id = creatives.campaign_id |
| ad_analytics_by_campaign | campaigns.id = ad_analytics_by_campaign.campaign_id |
account STRING |
account_id INTEGER |
associated_entity STRING |
associated_entity_organization_id INTEGER |
associated_entity_person_id STRING |
audience_expansion_enabled BOOLEAN |
campaign_group STRING |
campaign_group_id INTEGER |
change_audit_stamps OBJECT This is a nested data structure:
|
cost_type STRING |
created_time DATE-TIME |
creative_selection STRING |
daily_budget OBJECT This is a nested data structure:
|
format STRING |
id INTEGER |
last_modified_time DATE-TIME |
locale OBJECT This is a nested data structure:
|
name STRING |
objective_type STRING |
offsite_delivery_enabled BOOLEAN |
offsite_preferences OBJECT This is a nested data structure:
|
optimization_target_type STRING |
pacing_strategy STRING |
run_schedule OBJECT This is a nested data structure:
|
serving_statuses ARRAY This is a nested data structure. |
status STRING |
targeting OBJECT This is a nested data structure:
|
targeting_criteria OBJECT This is a nested data structure:
|
test BOOLEAN |
total_budget OBJECT This is a nested data structure:
|
type STRING |
unit_cost OBJECT This is a nested data structure:
|
version OBJECT This is a nested data structure:
|
version_tag STRING |
creatives
The Creatives API contains all the data and information for visually rendering an ad.
Replication Method | CDC |
Primary Key | id |
Replication Key | last_modified_at |
| Useful links |
| Join creatives with | on |
|---|---|
| campaigns | creatives.campaign_id = campaigns.id |
| ad_analytics_by_campaign | creatives.campaign_id = ad_analytics_by_campaign.campaign_id |
| ad_analytics_by_creative | creatives.id = ad_analytics_by_creative.creative_id |
account STRING |
account_id INTEGER |
campaign STRING |
campaign_id INTEGER |
content OBJECT This is a nested data structure:
|
created_at DATE-TIME |
created_by STRING |
id STRING |
intended_status STRING |
is_serving BOOLEAN |
is_test BOOLEAN |
last_modified_at DATE-TIME |
last_modified_by STRING |
serving_hold_reasons ARRAY This is a nested data structure. |
video_ads
The video_ads table contains info about the video ads in your LinkedIn Ads account.
Replication Method | CDC |
Primary Key | content_reference |
Replication Key | last_modified_time |
| Useful links |
| Join video_ads with | on |
|---|---|
| account_users | video_ads.account_id = account_users.account_id |
| accounts | video_ads.account_id = accounts.id |
| campaigns | video_ads.account_id = campaigns.account_id |
| campaign_groups | video_ads.account_id = campaign_groups.account_id |
account STRING |
account_id INTEGER |
change_audit_stamps OBJECT This is a nested data structure:
|
content_reference STRING |
content_reference_share_id INTEGER |
content_reference_ucg_post_id INTEGER |
created_time DATE-TIME |
last_modified_time DATE-TIME |
name STRING |
owner STRING |
owner_organization_id INTEGER |
type STRING |