# RevX schema ERD

Table and field reference for the Fivetran RevX connector.

## Table & Field Reference

### rtb_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_ecpm | Unknown |  |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| advertiser_pricing | Unknown |  |
| aggregator_id | Unknown |  |
| aggregator_name | Unknown |  |
| app_category | Unknown |  |
| app_rating | Unknown |  |
| app_store_certified | Unknown |  |
| bid_strategy | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| campaign_status | Unknown |  |
| city_id | Unknown |  |
| city_name | Unknown |  |
| click | Unknown |  |
| click_txn_amount | Unknown |  |
| conv_rate | Unknown |  |
| conversion | Unknown |  |
| conversion_click | Unknown |  |
| conversion_view | Unknown |  |
| country_code | Unknown |  |
| country_id | Unknown |  |
| country_name | Unknown |  |
| creative_height | Unknown |  |
| creative_id | Unknown |  |
| creative_name | Unknown |  |
| creative_offer_type | Unknown |  |
| creative_set_id | Unknown |  |
| creative_set_name | Unknown |  |
| creative_set_type | Unknown |  |
| creative_size | Unknown |  |
| creative_width | Unknown |  |
| ctc | Unknown |  |
| ctr | Unknown |  |
| currency_code | Unknown |  |
| currency_id | Unknown |  |
| currency_name | Unknown |  |
| cvr | Unknown |  |
| device_brand | Unknown |  |
| device_model | Unknown |  |
| end_time | Unknown |  |
| imp_install | Unknown |  |
| impression | Unknown |  |
| iti | Unknown |  |
| licensee_id | Unknown |  |
| licensee_name | Unknown |  |
| media_type | Unknown |  |
| optimization_type | Unknown |  |
| os_id | Unknown |  |
| os_name | Unknown |  |
| position | Unknown |  |
| revenue | Unknown |  |
| roi | Unknown |  |
| site_id | Unknown |  |
| site_name | Unknown |  |
| source_type | Unknown |  |
| start_time | Unknown |  |
| state_id | Unknown |  |
| state_name | Unknown |  |
| strategy_id | Unknown |  |
| strategy_name | Unknown |  |
| strategy_status | Unknown |  |
| total_install | Unknown |  |
| view_txn_amount | Unknown |  |