# Brave Ads schema ERD

Table and field reference for the Fivetran Brave Ads connector.

## Table & Field Reference

### campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| campaign_id | Unknown | FK |
| creative_instance_id | Unknown | FK |
| creative_set_id | Unknown | FK |
| advertiser_name | Unknown |  |
| attribution_window_days | Unknown |  |
| campaign_name | Unknown |  |
| click_count | Unknown |  |
| click_through_conversion_count | Unknown |  |
| conversion_count | Unknown |  |
| country | Unknown |  |
| creative_body | Unknown |  |
| creative_set_name | Unknown |  |
| creative_title | Unknown |  |
| creative_url | Unknown |  |
| day_or_hour | Unknown |  |
| dismissed_count | Unknown |  |
| impression_count | Unknown |  |
| os | Unknown |  |
| segment | Unknown |  |
| site_visit_count | Unknown |  |
| spend | Unknown |  |
| view_through_conversion_count | Unknown |  |

### advertiser_campaign_ad_set_ads

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| ad_set_id | Unknown | FK |
| advertiser_id | Unknown | FK |
| campaign_id | Unknown | FK |

### advertiser_campaign_ad_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| campaign_id | Unknown | FK |
| name | Unknown |  |

### advertiser_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| advertiser_id | Unknown | FK |
| end_at | Unknown |  |
| format | Unknown |  |
| name | Unknown |  |
| start_at | Unknown |  |

### advertiser

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

## Relationships

- campaign_report(campaign_id) → advertiser_campaign(id)
- campaign_report(creative_set_id) → advertiser_campaign_ad_set(id)
- campaign_report(creative_instance_id) → advertiser_campaign_ad_set_ads(id)
- advertiser_campaign_ad_set_ads(ad_set_id) → advertiser_campaign_ad_set(id)
- advertiser_campaign_ad_set_ads(advertiser_id) → advertiser_campaign_ad_set(advertiser_id)
- advertiser_campaign_ad_set_ads(campaign_id) → advertiser_campaign_ad_set(campaign_id)
- advertiser_campaign_ad_set(advertiser_id) → advertiser_campaign(advertiser_id)
- advertiser_campaign_ad_set(campaign_id) → advertiser_campaign(id)
- advertiser_campaign(advertiser_id) → advertiser(id)