Schema · Entity relationship diagram
AppLovin tables and relationships
AppLovin (Axon) web and e-commerce ads: daily campaign performance (spend, impressions, clicks, attributed purchases and revenue), serve-day cohort conversions over 0 to 28 days including new customers, creative-set performance and campaign settings. AppLovin only keeps about 88 days of history, so the warehouse becomes your long-term record from the day you connect.
applovin- AppLovin's API only serves about 88 days, so history builds up in your warehouse from the day you connect. The last 35 days are refreshed on every sync as numbers settle.
dayis the UTC day. Ratios are not stored: compute ROAS, cost per purchase, CTR and CPC from the summed columns.
Drag to pan, scroll or pinch to zoom, click a table to see what it joins to.
Table reference
4 tables · click a table for its columnscampaigns8 columnsshow in diagram
one row per campaign with the LATEST meta; last_seen_day = newest day with delivery
Primary key: campaign_id_external
| Column | Type | Key | Description |
|---|---|---|---|
| campaign_id_externalPrimary key. | varchar(64) | PK | Primary key. |
| campaign | varchar(512) | ||
| campaign_type | varchar(64) | ||
| campaign_bid_goal | decimal(18,4) | ||
| optimization_day_target | bigint | ||
| audience_strategy | varchar(64) | ||
| last_seen_day | date | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
campaign_report12 columnsshow in diagram
DAY x CAMPAIGN, event-day view (matches the AppLovin dashboard's daily view)
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | varchar(32) | PK | Primary key. |
| day | date | ||
| campaign | varchar(512) | ||
| campaign_id_externalReferences campaigns.campaign_id_external. | varchar(64) | FK | References campaigns.campaign_id_external. |
| impressions | bigint | ||
| clicks | bigint | ||
| cost | decimal(18,4) | ||
| sales | bigint | ||
| sales_click | bigint | ||
| chka_usd | decimal(18,4) | ||
| new_visitor_rate | decimal(9,4) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
campaign_cohort_report23 columnsshow in diagram
DAY x CAMPAIGN, serve-day cohorts (day_column=day, click_and_view); rows for the last ~28 days restate as cohorts mature
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | varchar(32) | PK | Primary key. |
| day | date | ||
| campaign | varchar(512) | ||
| campaign_id_externalReferences campaigns.campaign_id_external. | varchar(64) | FK | References campaigns.campaign_id_external. |
| cost | decimal(18,4) | ||
| sales | bigint | ||
| sales_0d | bigint | ||
| sales_1d | bigint | ||
| sales_3d | bigint | ||
| sales_7d | bigint | ||
| sales_14d | bigint | ||
| sales_28d | bigint | ||
| chka_usd_0d | decimal(18,4) | ||
| chka_usd_1d | decimal(18,4) | ||
| chka_usd_3d | decimal(18,4) | ||
| chka_usd_7d | decimal(18,4) | ||
| chka_usd_14d | decimal(18,4) | ||
| chka_usd_28d | decimal(18,4) | ||
| nc_d0_checkouts | bigint | ||
| nc_d0_checkout_rev | decimal(18,4) | ||
| nc_d7_checkouts | bigint | ||
| nc_d7_checkout_rev | decimal(18,4) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |
creative_report12 columnsshow in diagram
DAY x CAMPAIGN x CREATIVE_SET, event-day view, click_and_view
Primary key: id
| Column | Type | Key | Description |
|---|---|---|---|
| idPrimary key. | varchar(32) | PK | Primary key. |
| day | date | ||
| campaign | varchar(512) | ||
| campaign_id_externalReferences campaigns.campaign_id_external. | varchar(64) | FK | References campaigns.campaign_id_external. |
| creative_set | varchar(256) | ||
| creative_set_id | varchar(64) | ||
| impressions | bigint | ||
| clicks | bigint | ||
| cost | decimal(18,4) | ||
| sales | bigint | ||
| chka_usd | decimal(18,4) | ||
| _jsdata_syncedWhen jsdata last wrote this row. | timestamp | When jsdata last wrote this row. |