Liftoff
Explore the interactive ERD
Table & Field Reference
creative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
creative_type | Unknown | |
full_html_preview_url | Unknown | |
height | Unknown | |
name | Unknown | |
preview_url | Unknown | |
width | Unknown |
app
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_store_id | Unknown | |
bundle_id | Unknown | |
name | Unknown | |
optimization_event_id | Unknown | |
optimization_event_name | Unknown | |
platform | Unknown | |
state | Unknown | |
title | Unknown |
event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_id | Unknown | FK |
name | Unknown |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
app_id | Unknown | FK |
campaign_type | Unknown | |
max_os_version | Unknown | |
min_os_version | Unknown | |
name | Unknown | |
state | Unknown | |
state_last_changed_at | Unknown | |
tracker_type | Unknown |
report
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
app_id | Unknown | FK |
campaign_id | Unknown | FK |
creative_id | Unknown | FK |
ad_format | Unknown | |
clicks | Unknown | |
country_code | Unknown | |
cpa | Unknown | |
cpc | Unknown | |
cpi | Unknown | |
cpm | Unknown | |
ctr | Unknown | |
date | Unknown | |
event_number | Unknown | |
impressions | Unknown | |
installs | Unknown | |
publisher_app_store_id | Unknown | |
publisher_name | Unknown | |
skan_installs_with_conversion_value | Unknown | |
skan_installs_with_no_conversion_value | Unknown | |
spend | Unknown | |
custom_** |