LinkedIn Ads schema

20 tables · 9 joins

About the connector Start free

20 tables

Loading diagram…

account

campaign

campaign_group

creative

post

account

16

id

string

test

boolean

notified_on_creative_approval

boolean

notified_on_creative_rejection

boolean

notified_on_end_of_campaign

boolean

notified_on_campaign_optimization

boolean

notified_on_new_features_enabled

boolean

type

string

version_tag

double

account_serving_status

3

account_id

string

status

string

_weld_synced

date

account_user

6

id

string

account_id

string

role

string

created_time

date

last_modified_time

date

_weld_synced

date

ad_analytics_by_campaign

66

campaign_id

string

action_clicks

int

external_website_post_click_conversions

int

comments

int

external_website_post_view_conversions

int

cost_in_usd

double

comment_likes

int

ad_unit_clicks

int

company_page_clicks

int

ad_analytics_by_creative

66

creative_id

string

action_clicks

int

external_website_post_click_conversions

int

comments

int

external_website_post_view_conversions

int

cost_in_usd

double

comment_likes

int

ad_unit_clicks

int

company_page_clicks

int

campaign

29

id

string

campaign_group_id

string

account_id

string

story_delivery_enabled

boolean

pacing_strategy

string

locale_country

string

locale_language

string

type

string

optimization_target_type

string

run_schedule_start

date

run_schedule_end

date

campaign_serving_status

3

campaign_id

string

status

string

_weld_synced

date

targeting_criteria_include

5

campaign_id

string

index

int

facet_name

string

facet_value

string

_weld_synced

date

targeting_criteria_exclude

5

campaign_id

string

index

int

facet_name

string

facet_value

string

_weld_synced

date

campaign_group

11

id

string

account_id

string

run_schedule_start

date

run_schedule_end

date

test

boolean

created_time

date

last_modified_time

date

name

string

backfilled

boolean

status

string

_weld_synced

date

campaign_group_serving_status

3

campaign_group_id

string

status

string

_weld_synced

date

campaign_group_allowed_type

3

campaign_group_id

string

type

string

_weld_synced

date

creative

15

id

string

account_id

string

campaign_id

string

content_reference

string

is_test

boolean

is_serving

boolean

created_at

date

created_by

string

last_modified_at

date

last_modified_by

string

intended_status

string

leadgen_call_to_action_label

string

leadgen_call_to_action_destination

string

title

string

_weld_synced

date

serving_hold_reasons

3

creative_id

string

status

string

_weld_synced

date

post

21

id

string

account_id

string

lifecycleState

string

lastModifiedAt

date

createdAt

date

visibility

string

publishedAt

date

author

string

contentCallToActionLabel

string

distribution_feedDistribution

string

poll_content

8

post_id

string

question

string

options

string

settings_voteSelectionType

string

settings_duration

string

settings_isVoterVisibleToAuthor

boolean

uniqueVotersCount

double

_weld_synced

date

carousel_content

7

post_id

string

media_id

string

landing_page

string

media_title

string

media_alt_text

string

media_tagged_entities

string

_weld_synced

date

media_content

5

id

string

post_id

string

title

string

alt_text

string

_weld_synced

date

article_content

7

post_id

string

title

string

description

string

source

string

thumbnail

string

thumbnail_alt_text

string

_weld_synced

date

celebration_content

7

post_id

string

media

string

text

string

type

string

tagged_entities

string

recipients

string

_weld_synced

date