LinkedIn Ad Analytics

Explore the interactive ERD

Table & Field Reference

post_history

Column	Type	Keys
`id`	String	PK
`last_modified_time`	Instant	PK
`author`	String
`commentary`	String
`container_entity`	String
`content_call_to_action_label`	String
`content_landing_page`	String
`created_time`	Instant
`distribution_external_distribution_channels`	Json
`distribution_feed_distribution`	String
`first_published_at`	Instant
`is_reshare_disabled_by_author`	Boolean
`lifecycle_state`	String
`lifecycle_state_info_content_status`	String
`lifecycle_state_info_is_edited_by_author`	Boolean
`lifecycle_state_info_review_status`	String
`response_context_parent`	String
`response_context_root`	String
`type`	String
`visibility`	String
`ad_context_`

function

Column	Type	Keys
`id`	Long	PK
`name`	String

conversion_history

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`attribution_type`	String
`conversion_method`	String
`created`	Instant
`enabled`	Boolean
`image_pixel_tag`	String
`last_callback_at`	Instant
`last_modified`	Instant
`latest_first_party_callback_at`	Instant
`name`	String
`post_click_attribution_window_size`	Int
`type`	String
`url_match_rule_expression`	Json
`value_amount`	Double
`value_currency_code`	String
`value_type`	String
`view_through_attribution_window_size`	Int

campaign_group_serving_status_history

Column	Type	Keys
`status`	String	PK
`campaign_group_id`	Long	PKFK
`campaign_group_last_modified_time`	Instant	PKFK

account_serving_status_history

Column	Type	Keys
`status`	String	PK
`account_id`	Long	PKFK
`account_last_modified_time`	Instant	PKFK

lead_form_consent

Column	Type	Keys
`id`	Long	PK
`lead_form_id`	Long	FK
`check_required`	Boolean
`consent_localized`	Json
`consent_preferred_locale_country`	String
`consent_preferred_locale_language`	String
`label`	String

lead_form_response_answer

Column	Type	Keys
`lead_form_response_id`	String	PKFK
`question_id`	Long	PKFK
`name`	String
`text_question_answer`	String

lead_form_response_multiple_choice_answers

Column	Type	Keys
`index`	Int	PK
`lead_form_response_id`	String	PKFK
`question_id`	Long	PKFK
`option`	Int

content

Column	Type	Keys
`_fivetran_id`	String	PK
`post_id`	String	PKFK
`carousel_id`	Long
`media_alt_text`	String
`media_id`	String
`media_title`	String
`multi_image_alt_text`	String
`poll_question`	String
`poll_settings_duration`	String
`poll_settings_is_voter_visible_to_author`	Boolean
`poll_settings_vote_selection_type`	String
`poll_unique_voters_count`	Long
`reference_id`	String
`type`	String
`type_of_content`	String
`article_`

monthly_ad_analytics_by_member_industry

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_industry`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

creative_serving_status_history

Column	Type	Keys
`status`	String	PK
`creative_id`	Long	PKFK
`creative_last_modified_time`	Instant	PKFK

form_question

Column	Type	Keys
`question_id`	Int	PK
`form_id`	Long	PKFK
`member_profile_field`	String
`name`	String
`predefined_field`	String
`question`	String

ad_analytics_by_creative_with_conversion_breakdown

Column	Type	Keys
`day`	Instant	PK
`conversion_id`	Long	PKFK
`creative_id`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

lead_form_multiple_choice_question_option

Column	Type	Keys
`_fivetran_id`	String	PK
`question_id`	Long	FK
`id`	Long
`label`	String
`text_localized`	Json
`text_preferred_locale_country`	String
`text_preferred_locale_language`	String

creative_history

Column	Type	Keys
`id`	Long	PK
`last_modified_at`	Instant	PK
`leadgen_call_to_action_destination`	Long	FK
`account_id`	Long
`campaign_id`	Long
`created_at`	Instant
`created_by`	String
`document_ad_gated_leadgen_preview_page_count`	Long
`document_ad_reference`	String
`event_ad_direct_sponsored_content`	Boolean
`event_ad_event`	Long
`event_ad_hide_preview_video`	Boolean
`event_ad_post`	String
`follower_call_to_action`	String
`follower_logo`	String
`follower_organization_name`	String
`follower_show_member_profile_photo`	Boolean
`inline_content`	String
`intended_status`	String
`is_serving`	Boolean
`jobs_logo`	String
`jobs_organization_name`	String
`jobs_show_member_profile_photo`	Boolean
`last_modified_by`	String
`leadgen_call_to_action_label`	String
`name`	String
`reference`	String
`review_status`	String
`spotlight_call_to_action`	String
`spotlight_description`	String
`spotlight_headline`	String
`spotlight_landing_page`	String
`spotlight_logo`	String
`spotlight_organization_name`	String
`spotlight_show_member_profile_photo`	Boolean
`text_ad_description`	String
`text_ad_headline`	String
`text_ad_image`	String
`text_ad_landing_page`	String

geo

Column	Type	Keys
`id`	Long	PK
`value`	String

video

Column	Type	Keys
`id`	String	PK
`aspect_ratio_height`	Float
`aspect_ratio_width`	Float
`captions`	String
`download_url`	String
`download_url_expires_at`	Instant
`duration`	Long
`owner`	String
`processing_failure_reason`	String
`status`	String
`thumbnail`	String

sponsored_message_content

Column	Type	Keys
`id`	String	PK
`body_source_lead_generation_form`	Long
`body_source_media_attachment_attachment`	String
`body_source_media_attachment_text`	String
`body_source_text`	String
`sponsored_conversation_id`	Long

lead_form_question

Column	Type	Keys
`question_id`	Long	PK
`lead_form_id`	Long	FK
`label`	String
`multiple_choice_question_details_default_selected_option`	Long
`name`	String
`predefined_field`	String
`question_localized`	Json
`question_preferred_locale_country`	String
`question_preferred_locale_language`	String
`questions_submission_criteria_freemium_email_allowed`	Boolean
`response_editable`	Boolean
`response_required`	Boolean
`text_prompt_localized`	Json
`text_prompt_preferred_locale_country`	String
`text_prompt_preferred_locale_language`	String
`text_question_details_default_response`	String
`text_question_details_max_response_length`	Long

form

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`created_time`	Instant
`description`	String
`headline`	String
`landing_page`	String
`last_modified_time`	Instant
`name`	String
`privacy_policy`	String
`review_status`	String
`reviewed_at`	Instant
`status`	String
`thank_you_message`	String
`thank_you_page_call_to_action`	String
`version_tag`	String

organization_locations

Column	Type	Keys
`organization_id`	Long	PKFK
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`geo_location`	Long
`localized_description`	String
`location_type`	String
`street_address_field_state`	String
`address_`

campaign_group_allowed_campaign_type_history

Column	Type	Keys
`campaign_type`	String	PK
`campaign_group_id`	Long	PKFK
`campaign_group_last_modified_time`	Instant	PKFK

in_mail_content_history

Column	Type	Keys
`id`	Long	PK
`last_modified_at`	Instant	PK
`creative_id`	Long	FK
`account`	Long
`created_at`	Instant
`created_by`	String
`html_body`	String
`last_modified_by`	String
`name`	String
`sender`	String
`sub_content_formcall_to_action_text`	String
`sub_content_formright_rail_ad_picture`	String
`sub_content_guided_repliesright_rail_ad_picture`	String
`sub_content_guided_repliessponsored_conversation`	String
`sub_content_regularcall_to_action_landing_page_url`	String
`sub_content_regularcall_to_action_text`	String
`sub_content_regularright_rail_ad_picture`	String
`subject`	String

distribution_target_location

Column	Type	Keys
`location`	String	PK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`type`	String

conversion_associated_campaign

Column	Type	Keys
`associated_at`	Instant	PK
`campaign_id`	Long	PKFK
`conversion_id`	Long	PKFK

account_history

Column	Type	Keys
`id`	Long	PK
`last_modified_time`	Instant	PK
`created_time`	Instant
`currency`	String
`name`	String
`notified_on_campaign_optimization`	Boolean
`notified_on_creative_approval`	Boolean
`notified_on_creative_rejection`	Boolean
`notified_on_end_of_campaign`	Boolean
`reference`	String
`status`	String
`type`	String
`version_tag`	String

form_rejection_reason

Column	Type	Keys
`reason`	String	PK
`form_id`	Long	PKFK

distribution_target_interface_locale

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`country`	String
`language`	String
`type`	String

lead_form_response_consent

Column	Type	Keys
`consent_id`	Long	PK
`lead_form_response_id`	String	PKFK
`accepted`	Boolean
`consent`	String

lead_form_hidden_field

Column	Type	Keys
`index`	Int	PK
`lead_form_id`	Long	PKFK
`name`	String
`value`	String

organization

Column	Type	Keys
`id`	Long	PK
`default_locale_country`	String
`default_locale_language`	String
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`localized_description`	String
`localized_name`	String
`localized_website`	String
`logo_v_2_crop_info_height`	Int
`logo_v_2_crop_info_width`	Int
`logo_v_2_crop_info_x`	Int
`logo_v_2_crop_info_y`	Int
`logo_v_2_cropped`	String
`logo_v_2_original`	String
`name_localized`	Json
`name_preferred_locale_country`	String
`name_preferred_locale_language`	String
`organization_status`	String
`organization_type`	String
`primary_organization_type`	String
`staff_count_range`	String
`vanity_name`	String
`version_tag`	String
`website_localized`	Json
`website_preferred_locale_country`	String
`website_preferred_locale_language`	String

monthly_ad_analytics_by_member_seniority

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_seniority`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

monthly_ad_analytics_by_member_job_title

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_job_title`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

distribution_target_staff_count_range

Column	Type	Keys
`staff_count_range`	String	PK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`type`	String

lead_form_response

Column	Type	Keys
`id`	String	PK
`lead_type`	String
`organisation_id`	Long
`sponsored_account_id`	Long
`submitted_at`	Instant
`test_lead`	Boolean
`versioned_lead_gen_form`	String

campaign_serving_status_history

Column	Type	Keys
`status`	String	PK
`campaign_id`	Long	PKFK
`campaign_last_modified_time`	Instant	PKFK

monthly_ad_analytics_by_member_company

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_organization`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

title

Column	Type	Keys
`id`	Long	PK
`name_localized`	Json
`name_preferred_locale_country`	String
`name_preferred_locale_language`	String

account_user_history

Column	Type	Keys
`account_id`	Long	PK
`id`	String	PK
`last_modified_time`	Instant	PK
`created_time`	Instant
`role`	String

monthly_ad_analytics_by_member_country

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_country`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

distribution_target_seniority

Column	Type	Keys
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`seniority_id`	Long	PKFK
`type`	String

seniority

Column	Type	Keys
`id`	Long	PK
`name`	String

targeting_criteria_include_history

Column	Type	Keys
`facet_name`	String	PK
`facet_value`	String	PK
`index`	Int	PK
`campaign_id`	Long	PKFK
`campaign_last_modified_time`	Instant	PKFK

lead_form_history

Column	Type	Keys
`id`	Long	PK
`last_modified`	Instant	PK
`created`	Instant
`description_localized`	Json
`description_preferred_locale_country`	String
`description_preferred_locale_language`	String
`headline_localized`	Json
`headline_preferred_locale_country`	String
`headline_preferred_locale_language`	String
`legal_info_legal_disclaimer_localized`	Json
`legal_info_legal_disclaimer_preferred_locale_country`	String
`legal_info_legal_disclaimer_preferred_locale_language`	String
`legal_info_legal_info_id`	Long
`locale_country`	String
`locale_language`	String
`name`	String
`organization_id`	Long
`post_submission_infocall_to_action_call_to_action_label`	String
`post_submission_infocall_to_action_landing_page_url`	String
`post_submission_infomessage_localized`	Json
`post_submission_infomessage_preferred_locale_country`	String
`post_submission_infomessage_preferred_locale_language`	String
`review_info_last_updated`	Instant
`review_info_review_status`	String
`sponsored_account_id`	Long
`state`	String
`version_id`	Long

distribution_target_industry

Column	Type	Keys
`industry_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`type`	String

campaign_group_history

Column	Type	Keys
`id`	Long	PK
`last_modified_time`	Instant	PK
`account_id`	Long
`backfilled`	Boolean
`budget_optimization_bid_strategy`	String
`budget_optimization_budget_optimization_strategy`	String
`created_time`	Instant
`daily_budget`	BigDecimal
`name`	String
`objective_type`	String
`run_schedule_end`	Instant
`run_schedule_start`	Instant
`status`	String
`test`	Boolean
`total_budget_amount`	BigDecimal
`total_budget_currency_code`	String

monthly_ad_analytics_by_member_company_size

Column	Type	Keys
`member_company_size`	String	PK
`month`	String	PK
`campaign_id`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

image

Column	Type	Keys
`id`	String	PK
`alt_text`	String
`aspect_ratio_height`	Double
`aspect_ratio_width`	Double
`download_url`	String
`download_url_expires_at`	Instant
`owner`	String
`status`	String

campaign_history

Column	Type	Keys
`id`	Long	PK
`last_modified_time`	Instant	PK
`account_id`	Long
`associated_entity`	String
`audience_expansion_enabled`	Boolean
`campaign_group_id`	Long
`connected_television_only`	Boolean
`cost_type`	String
`created_time`	Instant
`creative_selection`	String
`daily_budget_amount`	Double
`daily_budget_currency_code`	String
`format`	String
`frequency_optimization_preference_frequency`	Int
`frequency_optimization_preference_optimization_type`	String
`frequency_optimization_preference_time_span_duration`	Long
`frequency_optimization_preference_time_span_unit`	String
`locale_country`	String
`locale_language`	String
`name`	String
`objective_type`	String
`offsite_delivery_enabled`	Boolean
`optimization_target_type`	String
`run_schedule_end`	Instant
`run_schedule_start`	Instant
`status`	String
`total_budget_amount`	BigDecimal
`total_budget_currency_code`	String
`type`	String
`unit_cost_amount`	Double
`unit_cost_currency_code`	String
`version_tag`	String

distribution_target_job_function

Column	Type	Keys
`function_id`	Long	PKFK
`last_modified_time`	Instant	PKFK
`post_id`	String	PKFK
`type`	String

monthly_ad_analytics_by_member_region

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_region`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

industry

Column	Type	Keys
`id`	Long	PK
`name`	String

targeting_criteria_exclude_history

Column	Type	Keys
`facet_name`	String	PK
`facet_value`	String	PK
`campaign_id`	Long	PKFK
`campaign_last_modified_time`	Instant	PKFK

content_poll_option

Column	Type	Keys
`text`	String	PK
`_fivetran_id`	String	PKFK
`is_voted_by_viewer`	Boolean
`type`	String
`vote_count`	Long

monthly_ad_analytics_by_member_job_function

Column	Type	Keys
`month`	String	PK
`campaign_id`	Long	PKFK
`member_job_function`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

sponsored_message_option

Column	Type	Keys
`_fivetran_id`	String	PK
`sponsored_message_content_id`	String	PKFK
`landing_page`	String
`next_content`	String
`option_text`	String
`reply_type`	String

ad_analytics_by_campaign

Column	Type	Keys
`day`	Instant	PK
`campaign_id`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

document

Column	Type	Keys
`id`	String	PK
`download_url`	String
`download_url_expires_at`	Instant
`owner`	String
`status`	String

multi_image

Column	Type	Keys
`id`	String	PK
`_fivetran_id`	String	PKFK
`alt_text`	String
`title`	String
`type`	String

lead_form_rejection_reason

Column	Type	Keys
`reason`	String	PK
`lead_form_id`	Long	PKFK

form_hidden_field

Column	Type	Keys
`index`	Int	PK
`form_id`	Long	PKFK
`name`	String
`value`	String

ad_analytics_by_creative

Column	Type	Keys
`day`	Instant	PK
`creative_id`	Long	PKFK
`action_clicks`	Long
`ad_unit_clicks`	Long
`approximate_member_reach`	Long
`audience_penetration`	Double
`average_dwell_time`	Long
`average_event_watch_time`	Double
`average_event_watch_time_over_15_seconds`	Double
`average_event_watch_time_over_2_minutes`	Double
`average_event_watch_time_over_30_seconds`	Double
`average_video_watch_time`	Double
`card_clicks`	Long
`card_impressions`	Long
`clicks`	Long
`comment_likes`	Long
`comments`	Long
`company_page_clicks`	Long
`conversion_value_in_local_currency`	BigDecimal
`cost_in_local_currency`	BigDecimal
`cost_in_usd`	BigDecimal
`cost_per_event_view`	Double
`cost_per_event_view_over_15_seconds`	Double
`cost_per_event_view_over_2_minutes`	Double
`cost_per_event_view_over_30_seconds`	Double
`cost_per_qualified_lead`	BigDecimal
`document_completions`	Long
`document_first_quartile_completions`	Long
`document_midpoint_completions`	Long
`document_third_quartile_completions`	Long
`download_clicks`	Long
`event_views`	Long
`event_views_over_15_seconds`	Long
`event_views_over_2_minutes`	Long
`event_views_over_30_seconds`	Long
`event_watch_time`	Long
`external_website_conversions`	Long
`external_website_post_click_conversions`	Long
`external_website_post_view_conversions`	Long
`follows`	Long
`full_screen_plays`	Long
`headline_clicks`	Long
`headline_impressions`	Long
`impressions`	Long
`landing_page_clicks`	Long
`lead_generation_mail_contact_info_shares`	Long
`lead_generation_mail_interested_clicks`	Long
`likes`	Long
`one_click_lead_form_opens`	Long
`one_click_leads`	Long
`opens`	Long
`other_engagements`	Long
`post_click_job_applications`	BigDecimal
`post_click_job_apply_clicks`	BigDecimal
`post_click_registrations`	BigDecimal
`post_view_job_applications`	BigDecimal
`post_view_job_apply_clicks`	BigDecimal
`post_view_registrations`	BigDecimal
`qualified_leads`	Long
`reactions`	Long
`registrations`	BigDecimal
`sends`	Long
`shares`	Long
`subscription_clicks`	Long
`talent_leads`	Long
`text_url_clicks`	Long
`total_engagements`	Long
`valid_work_email_leads`	Long
`video_completions`	Long
`video_first_quartile_completions`	Long
`video_midpoint_completions`	Long
`video_starts`	Long
`video_third_quartile_completions`	Long
`video_views`	Long
`video_watch_time`	Long
`viral_card_clicks`	Long
`viral_card_impressions`	Long
`viral_clicks`	Long
`viral_comment_likes`	Long
`viral_comments`	Long
`viral_company_page_clicks`	Long
`viral_document_completions`	Long
`viral_document_first_quartile_completions`	Long
`viral_document_midpoint_completions`	Long
`viral_document_third_quartile_completions`	Long
`viral_download_clicks`	Long
`viral_external_website_conversions`	Long
`viral_external_website_post_click_conversions`	Long
`viral_external_website_post_view_conversions`	Long
`viral_follows`	Long
`viral_full_screen_plays`	Long
`viral_impressions`	Long
`viral_job_applications`	BigDecimal
`viral_job_apply_clicks`	BigDecimal
`viral_landing_page_clicks`	Long
`viral_likes`	Long
`viral_one_click_lead_form_opens`	Long
`viral_one_click_leads`	Long
`viral_other_engagements`	Long
`viral_post_click_job_applications`	BigDecimal
`viral_post_click_job_apply_clicks`	BigDecimal
`viral_post_click_registrations`	BigDecimal
`viral_post_view_job_applications`	BigDecimal
`viral_post_view_job_apply_clicks`	BigDecimal
`viral_post_view_registrations`	BigDecimal
`viral_reactions`	Long
`viral_registrations`	BigDecimal
`viral_shares`	Long
`viral_subscription_clicks`	Long
`viral_total_engagements`	Long
`viral_video_completions`	Long
`viral_video_first_quartile_completions`	Long
`viral_video_midpoint_completions`	Long
`viral_video_starts`	Long
`viral_video_third_quartile_completions`	Long
`viral_video_views`	Long

form_consent

Column	Type	Keys
`consent_id`	Int	PK
`form_id`	Long	PKFK
`consent_required`	String
`content`	String

carousel_card

Column	Type	Keys
`media_id`	String	PK
`_fivetran_id`	String	PKFK
`landing_page`	String
`media_alt_text`	String
`media_title`	String
`type`	String