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 專案 僅複寫專案。不支援資料管道專案。 不需要手動產生中繼資料。 僅支援變更欄資料類型操作。 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 啟動器 訂閱，因為不支援 資料移動閘道。若您有另一個訂閱層級且不想使用 資料移動閘道，選取無。 如需關於 資料移動閘道 福利的資訊以及需要此項的使用案例，請參閱 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 |