Moloco

Explore the interactive ERD

Table & Field Reference

ad_group_user_bucket

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_group_id`	Unknown	FK
`ends`	Unknown
`start`	Unknown

ad_group_creative_group

Column	Type	Keys
`creative_group_id`	Unknown	PK
`ad_group_id`	Unknown	PKFK

ad_group_audience_target

Column	Type	Keys
`audience_target_id`	Unknown	PK
`ad_group_id`	Unknown	PKFK
`id`	Unknown	FK

ad_group

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`product_id`	Unknown	FK
`capper_amount`	Unknown
`capper_unit`	Unknown
`created_at`	Unknown
`enabling_state`	Unknown
`is_secondary`	Unknown
`paired_ad_group_id`	Unknown
`pricing_model_id`	Unknown
`title`	Unknown
`updated_at`	Unknown
`targeting_condition_`

tracking_link_attempt_id

Column	Type	Keys
`attempt_id`	Unknown	PK
`tracking_link_id`	Unknown	PKFK

tracking_link

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`product_id`	Unknown	FK
`click_through_link_status`	Unknown
`click_through_link_unverified_status_data_stored_at`	Unknown
`click_through_link_url`	Unknown
`created_at`	Unknown
`description`	Unknown
`device_os`	Unknown
`title`	Unknown
`tracking_company`	Unknown
`updated_at`	Unknown
`verified_attempt_ad_account_id`	Unknown
`verified_attempt_id`	Unknown
`verified_attempt_resolved_idfa`	Unknown
`verified_attempt_resolved_url`	Unknown
`verified_attempt_started_at`	Unknown
`verified_attempt_tracking_bundle_id`	Unknown
`verified_attempt_tracking_link_id`	Unknown
`verified_attempt_url_data_type`	Unknown
`verified_attempt_user_email`	Unknown
`verified_attempt_user_id`	Unknown
`verified_attempt_user_name`	Unknown
`verified_attempt_verified_at`	Unknown
`view_through_link_status`	Unknown
`view_through_link_stored_at`	Unknown
`view_through_link_unverified_status_data_stored_at`	Unknown
`view_through_link_url`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`advertiser_domain`	Unknown
`app_bundle_id`	Unknown
`app_category`	Unknown
`app_mmp`	Unknown
`app_rating`	Unknown
`app_store_url`	Unknown
`content_rating`	Unknown
`created_at`	Unknown
`developer_name`	Unknown
`device_os`	Unknown
`dynamic_creative_property`	Json
`mmp_allow_fingerprinting`	Unknown
`mmp_bundle_id`	Unknown
`mmp_id`	Unknown
`mmp_mmp`	Unknown
`mmp_status`	Unknown
`mmp_updated_at`	Unknown
`skadn_bundle_id`	Unknown
`skadn_effective_date`	Unknown
`skadn_mmp`	Unknown
`skadn_ownership`	Unknown
`skadn_scheme`	Unknown
`skadn_status`	Unknown
`storekit_enabled`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown
`custom_`

ad_account_product_id

Column	Type	Keys
`product_id`	Unknown	PK
`ad_account_id`	Unknown	PKFK

ad_account

Column	Type	Keys
`id`	Unknown	PK
`billing_account_id`	Unknown
`created_at`	Unknown
`currency`	Unknown
`custom_key_values_additional_prop`	Unknown
`description`	Unknown
`targets_future_preferences_product_scope`	Unknown
`timezone`	Unknown
`title`	Unknown
`updated_at`	Unknown

creative_review_creative_group

Column	Type	Keys
`creative_group_id`	Unknown	PK
`creative_review_id`	Unknown	PKFK
`title`	Unknown

creative_review_action_history

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_review_id`	Unknown	FK
`assigned_status`	Unknown
`comment`	Unknown
`created_at`	Unknown
`reason_detail`	Unknown

creative_review

Column	Type	Keys
`id`	Unknown	PK
`creative_id`	Unknown	FK
`adx_status`	Unknown
`fyber_status`	Unknown
`status`	Unknown

customer_set

Column	Type	Keys
`id`	Unknown	PK
`auto_delete_at`	Unknown
`created_at`	Unknown
`data_file_path`	Unknown
`description`	Unknown
`file_info_file_name`	Unknown
`file_info_status`	Unknown
`file_info_timestamp`	Unknown
`hash_algorithm`	Unknown
`id_type`	Unknown
`is_hashed`	Unknown
`is_upper`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Unknown

creative_companion_image

Column	Type	Keys
`_fivetran_id`	String	PK
`creative_id`	Unknown	FK
`height`	Unknown
`size_in_bytes`	Unknown
`url`	Unknown
`width`	Unknown

creative

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`product_id`	Unknown	FK
`advertiser_info_description`	Unknown
`advertiser_info_id`	Unknown
`advertiser_info_title`	Unknown
`created_at`	Unknown
`creator_tag`	Unknown
`custom_height`	Unknown
`custom_html`	Unknown
`custom_image_url`	Unknown
`custom_key_values_additional_prop`	Unknown
`custom_width`	Unknown
`enabling_state`	Unknown
`feature_type`	Unknown
`icon_image_height`	Unknown
`icon_image_size_in_byte`	Unknown
`icon_image_url`	Unknown
`icon_image_width`	Unknown
`image_height`	Unknown
`image_size_in_byte`	Unknown
`image_url`	Unknown
`image_width`	Unknown
`main_image_height`	Unknown
`main_image_size_in_byte`	Unknown
`main_image_url`	Unknown
`main_image_width`	Unknown
`original_filename`	Unknown
`shrunk_main_imageheight`	Unknown
`shrunk_main_imagesize_in_byte`	Unknown
`shrunk_main_imageurl`	Unknown
`shrunk_main_imagewidth`	Unknown
`size_in_byte`	Unknown
`title`	Unknown
`type`	Unknown
`updated_at`	Unknown
`dynamic_html_`
`rich_custom_html_`
`template_html_`
`video_`

campaign_creative_group

Column	Type	Keys
`creative_group_id`	Unknown	PK
`campaign_id`	Unknown	PKFK

campaign_country

Column	Type	Keys
`index`	Unknown	PK
`campaign_id`	Unknown	PKFK
`country`	Unknown

campaign_audience_target

Column	Type	Keys
`audience_target_id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`id`	Unknown	FK

campaign

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`product_id`	Unknown	FK
`tracking_link_id`	Unknown	FK
`ad_tracking_allowance`	Unknown
`auto_delete_at`	Unknown
`budget_schedule`	Json
`created_at`	Unknown
`currency`	Unknown
`custom_key_values_additional_prop`	Unknown
`description`	Unknown
`device_os`	Unknown
`enabling_state`	Unknown
`goal`	Json
`is_deleted`	Unknown
`landing_url`	Unknown
`priority`	Unknown
`schedule_end`	Unknown
`schedule_start`	Unknown
`skadn_input_include_traffic_without_attribution`	Unknown
`skadn_input_targeting_state`	Unknown
`state`	Unknown
`title`	Unknown
`tracking_company`	Unknown
`type`	Unknown
`updated_at`	Unknown
`targeting_condition__`*

audience_target

Column	Type	Keys
`id`	Unknown	PK
`auto_delete_at`	Unknown
`created_at`	Unknown
`targeting_condition`	Json
`title`	Unknown
`updated_at`	Unknown
`targeting_condition__`*

creative_group_id

Column	Type	Keys
`creative_id`	Unknown	PK
`creative_group_id`	Unknown	PKFK

creative_group_action_histroy

Column	Type	Keys
`id`	Unknown	PK
`creative_group_id`	Unknown	PKFK
`action_type`	Unknown
`comment`	Unknown
`created_at`	Unknown
`user_display_name`	Unknown
`user_id`	Unknown

creative_group_audience_target

Column	Type	Keys
`audience_target_id`	Unknown	PK
`creative_group_id`	Unknown	PKFK

creative_group

Column	Type	Keys
`id`	Unknown	PK
`ad_account_id`	Unknown	FK
`product_id`	Unknown	FK
`tracking_link_id`	Unknown	FK
`app_icon_url`	Unknown
`background_color`	Unknown
`brand_logo_url`	Unknown
`business_title`	Unknown
`created_at`	Unknown
`cta_color`	Unknown
`cta_text`	Unknown
`cta_text_color`	Unknown
`description`	Unknown
`disclaimer_text`	Unknown
`disclaimer_text_color`	Unknown
`enabling_state`	Unknown
`feature_type`	Unknown
`final_landing_url`	Unknown
`image_border_color`	Unknown
`landing_url`	Unknown
`main_text`	Unknown
`main_text_color`	Unknown
`mmp_tag`	Unknown
`price_locale`	Unknown
`status`	Unknown
`title`	Unknown
`title_preamble`	Unknown
`updated_at`	Unknown
`targeting_condition_`

ad_performance_report

Column	Type	Keys
`_fivetran_id`	String	PK
`ad_account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`creative_group_id`	Unknown	FK
`creative_id`	Unknown	FK
`app_id`	Unknown
`app_os`	Unknown
`app_store_id`	Unknown
`app_title`	Unknown
`campaign_country`	Unknown
`clicks`	Unknown
`creative_main_asset_location`	Unknown
`date`	Unknown
`engaged_views`	Unknown
`exchange_id`	Unknown
`impressions`	Unknown
`installs`	Unknown
`revenue`	Unknown
`site_domain`	Unknown
`site_id`	Unknown
`site_title`	Unknown
`skan_conversion_count`	Unknown
`skan_conversion_value`	Unknown
`spend`	Unknown
`sub_publisher_id`	Unknown
`sub_publisher_title`	Unknown
`traffic_is_lat`	Unknown
`traffic_mmp_effective`	Unknown
`traffic_skan_bid`	Unknown
`video_play_1_q`	Unknown
`video_play_2_q`	Unknown
`video_play_3_q`	Unknown
`video_play_4_q`	Unknown