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 |