Rokt
Explore the interactive ERD
Table & Field Reference
campaign_metadata
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PKFK |
campaign_id | Unknown | PKFK |
campaign_objective | Unknown | |
campaign_type | Unknown | |
country_code | Unknown | |
status | Unknown |
account_summary
| Column | Type | Keys |
|---|---|---|
account_id | Unknown | PK |
campaign_country | Unknown | PK |
campaign_id | Unknown | PK |
datetime | Unknown | PK |
acquisitions_by_conversion_time | Unknown | |
click_thru_acquisitions | Unknown | |
click_thru_acquisitions_by_conversion_time | Unknown | |
currency | Unknown | |
date_end | Unknown | |
date_start | Unknown | |
gross_cost | Unknown | |
impressions | Unknown | |
net_cost | Unknown | |
referrals | Unknown | |
time_zone_variation | Unknown | |
unique_audiences | Unknown | |
unique_campaign_countries | Unknown | |
unique_campaigns | Unknown | |
unique_creatives | Unknown |
account_campaign_breakdown
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PK |
datetime | Unknown | PK |
account_id | Unknown | PKFK |
acquisitions_by_conversion_time | Unknown | |
campaign_name | Unknown | |
currency | Unknown | |
device | Unknown | |
gross_cost | Unknown | |
impression | Unknown | |
net_cost | Unknown | |
referral | Unknown | |
time_zone_variation | Unknown | |
unique_audience | Unknown | |
unique_campaign | Unknown | |
unique_campaign_country | Unknown | |
unique_creative | Unknown |
campaign_breakdown_creative
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PK |
creative_id | Unknown | PK |
datetime | Unknown | PK |
account_id | Unknown | PKFK |
acquisitions_by_conversion_time | Unknown | |
creative_name | Unknown | |
currency | Unknown | |
device | Unknown | |
gross_cost | Unknown | |
impression | Unknown | |
net_cost | Unknown | |
referral | Unknown | |
time_zone_variation | Unknown | |
unique_audience | Unknown | |
unique_campaign | Unknown | |
unique_campaign_country | Unknown | |
unique_creative | Unknown |
campaign_breakdown_country
| Column | Type | Keys |
|---|---|---|
campaign_country | Unknown | PK |
campaign_id | Unknown | PK |
datetime | Unknown | PK |
account_id | Unknown | PKFK |
acquisitions_by_conversion_time | Unknown | |
currency | Unknown | |
device | Unknown | |
gross_cost | Unknown | |
impression | Unknown | |
net_cost | Unknown | |
referral | Unknown | |
time_zone_variation | Unknown | |
unique_audience | Unknown | |
unique_campaign | Unknown | |
unique_campaign_country | Unknown | |
unique_creative | Unknown |
campaign_breakdown_audience
| Column | Type | Keys |
|---|---|---|
audience_name | Unknown | PK |
campaign_id | Unknown | PK |
datetime | Unknown | PK |
account_id | Unknown | PKFK |
acquisitions_by_conversion_time | Unknown | |
currency | Unknown | |
device | Unknown | |
gross_cost | Unknown | |
impression | Unknown | |
net_cost | Unknown | |
referral | Unknown | |
time_zone_variation | Unknown | |
unique_audience | Unknown | |
unique_campaign | Unknown | |
unique_campaign_country | Unknown | |
unique_creative | Unknown |
account_transaction_overview
| Column | Type | Keys |
|---|---|---|
datetime | Unknown | PK |
account_id | Unknown | PKFK |
currency | Unknown | |
date_end | Unknown | |
date_start | Unknown | |
impressions | Unknown | |
layout_impressions | Unknown | |
positive_layout_engagements | Unknown | |
purchases | Unknown | |
referrals | Unknown | |
revenue | Unknown | |
rpm | Unknown | |
rpt | Unknown | |
time_zone_variation | Unknown | |
transactions | Unknown |
account_transaction_breakdown
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
account_id | Unknown | FK |
age_range | Unknown | |
currency | Unknown | |
date_end | Unknown | |
date_start | Unknown | |
datetime | Unknown | |
gender | Unknown | |
impressions | Unknown | |
layout_impressions | Unknown | |
page_type | Unknown | |
partner_id | Unknown | |
positive_layout_engagements | Unknown | |
purchases | Unknown | |
referrals | Unknown | |
revenue | Unknown | |
rpm | Unknown | |
rpt | Unknown | |
time_zone_variation | Unknown | |
transactions | Unknown |
campaign_breakdown_subvertical
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PK |
datetime | Unknown | PK |
partner_sub_vertical | Unknown | PK |
account_id | Unknown | PKFK |
acquisitions_by_conversion_time | Unknown | |
currency | Unknown | |
device | Unknown | |
gross_cost | Unknown | |
impression | Unknown | |
net_cost | Unknown | |
referral | Unknown | |
time_zone_variation | Unknown | |
unique_audience | Unknown | |
unique_campaign | Unknown | |
unique_campaign_country | Unknown | |
unique_creative | Unknown |