# LinkedIn Ad Analytics schema ERD

Table and field reference for the Fivetran LinkedIn Ad Analytics connector.

## 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 | PK, FK |
| campaign_group_last_modified_time | Instant | PK, FK |

### account_serving_status_history

| Column | Type | Keys |
| --- | --- | --- |
| status | String | PK |
| account_id | Long | PK, FK |
| account_last_modified_time | Instant | PK, FK |

### 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 | PK, FK |
| question_id | Long | PK, FK |
| name | String |  |
| text_question_answer | String |  |

### lead_form_response_multiple_choice_answers

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| lead_form_response_id | String | PK, FK |
| question_id | Long | PK, FK |
| option | Int |  |

### content

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| post_id | String | PK, FK |
| 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 | PK, FK |
| member_industry | Long | PK, FK |
| 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 | PK, FK |
| creative_last_modified_time | Instant | PK, FK |

### form_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Int | PK |
| form_id | Long | PK, FK |
| 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 | PK, FK |
| creative_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| campaign_group_last_modified_time | Instant | PK, FK |

### 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 | PK, FK |
| post_id | String | PK, FK |
| type | String |  |

### conversion_associated_campaign

| Column | Type | Keys |
| --- | --- | --- |
| associated_at | Instant | PK |
| campaign_id | Long | PK, FK |
| conversion_id | Long | PK, FK |

### 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 | PK, FK |

### distribution_target_interface_locale

| Column | Type | Keys |
| --- | --- | --- |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |
| country | String |  |
| language | String |  |
| type | String |  |

### lead_form_response_consent

| Column | Type | Keys |
| --- | --- | --- |
| consent_id | Long | PK |
| lead_form_response_id | String | PK, FK |
| accepted | Boolean |  |
| consent | String |  |

### lead_form_hidden_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| lead_form_id | Long | PK, FK |
| 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 | PK, FK |
| member_seniority | Long | PK, FK |
| 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 | PK, FK |
| member_job_title | Long | PK, FK |
| 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 | PK, FK |
| post_id | String | PK, FK |
| 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 | PK, FK |
| campaign_last_modified_time | Instant | PK, FK |

### monthly_ad_analytics_by_member_company

| Column | Type | Keys |
| --- | --- | --- |
| month | String | PK |
| campaign_id | Long | PK, FK |
| member_organization | Long | PK, FK |
| 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 | PK, FK |
| member_country | Long | PK, FK |
| 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 | PK, FK |
| post_id | String | PK, FK |
| seniority_id | Long | PK, FK |
| 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 | PK, FK |
| campaign_last_modified_time | Instant | PK, FK |

### 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 | PK, FK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |
| type | String |  |

### monthly_ad_analytics_by_member_region

| Column | Type | Keys |
| --- | --- | --- |
| month | String | PK |
| campaign_id | Long | PK, FK |
| member_region | Long | PK, FK |
| 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 | PK, FK |
| campaign_last_modified_time | Instant | PK, FK |

### content_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| text | String | PK |
| _fivetran_id | String | PK, FK |
| 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 | PK, FK |
| member_job_function | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| alt_text | String |  |
| title | String |  |
| type | String |  |

### lead_form_rejection_reason

| Column | Type | Keys |
| --- | --- | --- |
| reason | String | PK |
| lead_form_id | Long | PK, FK |

### form_hidden_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| form_id | Long | PK, FK |
| name | String |  |
| value | String |  |

### ad_analytics_by_creative

| Column | Type | Keys |
| --- | --- | --- |
| day | Instant | PK |
| creative_id | Long | PK, FK |
| 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 | PK, FK |
| consent_required | String |  |
| content | String |  |

### carousel_card

| Column | Type | Keys |
| --- | --- | --- |
| media_id | String | PK |
| _fivetran_id | String | PK, FK |
| landing_page | String |  |
| media_alt_text | String |  |
| media_title | String |  |
| type | String |  |

## Relationships

- conversion_history(account_id) → account_history(id)
- campaign_group_serving_status_history(campaign_group_id) → campaign_group_history(id)
- campaign_group_serving_status_history(campaign_group_last_modified_time) → campaign_group_history(id)
- account_serving_status_history(account_id) → account_history(id)
- account_serving_status_history(account_last_modified_time) → account_history(id)
- lead_form_consent(lead_form_id) → lead_form_history(id)
- lead_form_response_answer(lead_form_response_id) → lead_form_response(id)
- lead_form_response_answer(question_id) → lead_form_question(question_id)
- lead_form_response_multiple_choice_answers(lead_form_response_id) → lead_form_response(id)
- lead_form_response_multiple_choice_answers(question_id) → lead_form_question(question_id)
- content(post_id) → post_history(id)
- monthly_ad_analytics_by_member_industry(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_industry(member_industry) → industry(id)
- creative_serving_status_history(creative_id) → creative_history(id)
- creative_serving_status_history(creative_last_modified_time) → creative_history(id)
- form_question(form_id) → form(id)
- ad_analytics_by_creative_with_conversion_breakdown(conversion_id) → conversion_history(id)
- ad_analytics_by_creative_with_conversion_breakdown(creative_id) → creative_history(id)
- lead_form_multiple_choice_question_option(question_id) → lead_form_question(question_id)
- creative_history(leadgen_call_to_action_destination) → lead_form_history(id)
- lead_form_question(lead_form_id) → lead_form_history(id)
- form(account_id) → account_history(id)
- organization_locations(organization_id) → organization(id)
- campaign_group_allowed_campaign_type_history(campaign_group_id) → campaign_group_history(id)
- campaign_group_allowed_campaign_type_history(campaign_group_last_modified_time) → campaign_group_history(id)
- in_mail_content_history(creative_id) → creative_history(id)
- distribution_target_location(post_id) → post_history(id)
- distribution_target_location(last_modified_time) → post_history(id)
- conversion_associated_campaign(conversion_id) → conversion_history(id)
- conversion_associated_campaign(campaign_id) → campaign_history(id)
- form_rejection_reason(form_id) → form(id)
- distribution_target_interface_locale(post_id) → post_history(id)
- distribution_target_interface_locale(last_modified_time) → post_history(id)
- lead_form_response_consent(lead_form_response_id) → lead_form_response(id)
- lead_form_hidden_field(lead_form_id) → lead_form_history(id)
- monthly_ad_analytics_by_member_seniority(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_seniority(member_seniority) → seniority(id)
- monthly_ad_analytics_by_member_job_title(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_job_title(member_job_title) → title(id)
- distribution_target_staff_count_range(post_id) → post_history(id)
- distribution_target_staff_count_range(last_modified_time) → post_history(id)
- campaign_serving_status_history(campaign_id) → campaign_history(id)
- campaign_serving_status_history(campaign_last_modified_time) → campaign_history(id)
- monthly_ad_analytics_by_member_company(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_company(member_organization) → organization(id)
- monthly_ad_analytics_by_member_country(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_country(member_country) → geo(id)
- distribution_target_seniority(post_id) → post_history(id)
- distribution_target_seniority(last_modified_time) → post_history(id)
- distribution_target_seniority(seniority_id) → seniority(id)
- targeting_criteria_include_history(campaign_id) → campaign_history(id)
- targeting_criteria_include_history(campaign_last_modified_time) → campaign_history(id)
- distribution_target_industry(post_id) → post_history(id)
- distribution_target_industry(last_modified_time) → post_history(id)
- distribution_target_industry(industry_id) → industry(id)
- monthly_ad_analytics_by_member_company_size(campaign_id) → campaign_history(id)
- distribution_target_job_function(post_id) → post_history(id)
- distribution_target_job_function(last_modified_time) → post_history(id)
- distribution_target_job_function(function_id) → function(id)
- monthly_ad_analytics_by_member_region(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_region(member_region) → geo(id)
- targeting_criteria_exclude_history(campaign_id) → campaign_history(id)
- targeting_criteria_exclude_history(campaign_last_modified_time) → campaign_history(id)
- content_poll_option(_fivetran_id) → content(_fivetran_id)
- monthly_ad_analytics_by_member_job_function(campaign_id) → campaign_history(id)
- monthly_ad_analytics_by_member_job_function(member_job_function) → function(id)
- sponsored_message_option(sponsored_message_content_id) → sponsored_message_content(id)
- ad_analytics_by_campaign(campaign_id) → campaign_history(id)
- multi_image(_fivetran_id) → content(post_id)
- lead_form_rejection_reason(lead_form_id) → lead_form_history(id)
- form_hidden_field(form_id) → form(id)
- ad_analytics_by_creative(creative_id) → creative_history(id)
- form_consent(form_id) → form(id)
- carousel_card(_fivetran_id) → content(post_id)