# Rokt schema ERD

Table and field reference for the Fivetran Rokt connector.

## Table & Field Reference

### campaign_metadata

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

## Relationships

- campaign_metadata(account_id) → account_summary(account_id)
- campaign_metadata(campaign_id) → account_campaign_breakdown(campaign_id)
- account_campaign_breakdown(account_id) → account_summary(account_id)
- campaign_breakdown_creative(account_id) → account_summary(account_id)
- campaign_breakdown_country(account_id) → account_summary(account_id)
- campaign_breakdown_audience(account_id) → account_summary(account_id)
- account_transaction_overview(account_id) → account_summary(account_id)
- account_transaction_breakdown(account_id) → account_summary(account_id)
- campaign_breakdown_subvertical(account_id) → account_summary(account_id)