# Phoenix Ads schema ERD

Table and field reference for the Fivetran Phoenix Ads connector.

## Table & Field Reference

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| zone | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| ad_id | Unknown |  |
| ad_name | Unknown |  |
| adset_id | Unknown |  |
| adset_name | Unknown |  |
| campaign_id | Unknown |  |
| campaign_name | Unknown |  |
| cash_cost | Unknown |  |
| click | Unknown |  |
| ds | Unknown |  |
| event | Unknown |  |
| gift_cost | Unknown |  |
| impression | Unknown |  |
| install | Unknown |  |
| optimization_event | Unknown |  |
| revenue_type | Unknown |  |

## Relationships

- report(account_id) → account(id)