# Moloco schema ERD

Table and field reference for the Fivetran Moloco connector.

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

### ad_group_audience_target

| Column | Type | Keys |
| --- | --- | --- |
| audience_target_id | Unknown | PK |
| ad_group_id | Unknown | PK, FK |
| 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 | PK, FK |

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

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

### campaign_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| country | Unknown |  |

### campaign_audience_target

| Column | Type | Keys |
| --- | --- | --- |
| audience_target_id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| 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 | PK, FK |

### creative_group_action_histroy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creative_group_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 |  |

## Relationships

- ad_group_user_bucket(ad_group_id) → ad_group(id)
- ad_group_creative_group(ad_group_id) → ad_group(id)
- ad_group_audience_target(id) → audience_target(id)
- ad_group_audience_target(ad_group_id) → ad_group(id)
- ad_group(product_id) → product(id)
- ad_group(ad_account_id) → ad_account(id)
- ad_group(campaign_id) → campaign(id)
- tracking_link_attempt_id(tracking_link_id) → tracking_link(id)
- tracking_link(product_id) → product(id)
- tracking_link(ad_account_id) → ad_account(id)
- product(ad_account_id) → ad_account(id)
- ad_account_product_id(ad_account_id) → ad_account(id)
- creative_review_creative_group(creative_review_id) → creative_review(id)
- creative_review_action_history(creative_review_id) → creative_review(id)
- creative_review(creative_id) → creative(id)
- creative_companion_image(creative_id) → creative(id)
- creative(product_id) → product(id)
- creative(ad_account_id) → ad_account(id)
- campaign_creative_group(campaign_id) → campaign(id)
- campaign_country(campaign_id) → campaign(id)
- campaign_audience_target(id) → audience_target(id)
- campaign_audience_target(campaign_id) → campaign(id)
- campaign(product_id) → product(id)
- campaign(ad_account_id) → ad_account(id)
- campaign(tracking_link_id) → tracking_link(id)
- creative_group_id(creative_group_id) → creative_group(id)
- creative_group_action_histroy(creative_group_id) → creative_group(id)
- creative_group_audience_target(creative_group_id) → creative_group(id)
- creative_group(product_id) → product(id)
- creative_group(ad_account_id) → ad_account(id)
- creative_group(tracking_link_id) → tracking_link(id)
- ad_performance_report(creative_group_id) → creative_group(id)
- ad_performance_report(ad_account_id) → ad_account(id)
- ad_performance_report(campaign_id) → campaign(id)
- ad_performance_report(ad_group_id) → ad_group(id)
- ad_performance_report(creative_id) → creative(id)