# OpenAI Ads schema ERD

Table and field reference for the Fivetran OpenAI Ads connector.

## Table & Field Reference

### ad_group_product_set_filter_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| filter_index | Int | PK, FK |
| product_feed_id | String |  |
| value | String |  |

### ad_group_context_hint

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| hint | String |  |

### campaign_targeting_country

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| campaign_id | String | PK, FK |
| country_name | String |  |

### ad_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | FK |
| bidding_config_billing_event_type | String |  |
| bidding_config_max_bid_micros | Long |  |
| created_at | Long |  |
| description | String |  |
| name | String |  |
| product_set_product_feed_id | String |  |
| status | String |  |
| updated_at | Long |  |

### ad_group_custom_audience_bid_multiplier

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| bid_multiplier_micros | Long |  |
| custom_audience_id | String |  |

### ad

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_group_id | String | FK |
| created_at | Long |  |
| creative_body | String |  |
| creative_file_id | String |  |
| creative_image_url | String |  |
| creative_price | String |  |
| creative_target_url | String |  |
| creative_title | String |  |
| creative_type | String |  |
| name | String |  |
| review_body_reason | String |  |
| review_body_status | String |  |
| review_status | String |  |
| status | String |  |
| updated_at | Long |  |

### campaign_custom_audience

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | PK, FK |
| is_excluded | Boolean |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ad_account_id | String | FK |
| bidding_type | String |  |
| budget_daily_spend_limit_micros | Long |  |
| budget_lifetime_spend_limit_micros | Long |  |
| created_at | Long |  |
| description | String |  |
| end_time | Long |  |
| mode | String |  |
| name | String |  |
| start_time | Long |  |
| status | String |  |
| updated_at | Long |  |

### campaign_conversion_event_setting

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | PK, FK |

### ad_group_product_set_filter

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_group_id | String | PK, FK |
| field | String |  |
| operator | String |  |
| product_feed_id | String |  |

### campaign_targeting_geo_location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | PK, FK |
| country_code | String |  |
| name | String |  |
| region_code | String |  |
| type | String |  |

### ad_report_daily

| Column | Type | Keys |
| --- | --- | --- |
| date | String | PK |
| ad_id | String | PK, FK |
| ad_account_id | String | FK |
| ad_group_id | String | FK |
| campaign_id | String | FK |
| clicks | Long |  |
| cpc | Double |  |
| cpm | Double |  |
| ctr | Double |  |
| end_time | Long |  |
| impressions | Long |  |
| spend | Double |  |
| start_time | Long |  |

### ad_account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_integrity_decision | String |  |
| account_integrity_reason | String |  |
| account_integrity_review_reason | String |  |
| account_integrity_review_status | String |  |
| account_integrity_status_updated_at | String |  |
| currency_code | String |  |
| name | String |  |
| preview_url | String |  |
| review_reason | String |  |
| review_status | String |  |
| status | String |  |
| timezone | String |  |
| url | String |  |

## Relationships

- ad_group_product_set_filter_value(filter_index) → ad_group_product_set_filter(index)
- ad_group_product_set_filter_value(ad_group_id) → ad_group(id)
- ad_group_context_hint(ad_group_id) → ad_group(id)
- campaign_targeting_country(campaign_id) → campaign(id)
- ad_group(campaign_id) → campaign(id)
- ad_group_custom_audience_bid_multiplier(ad_group_id) → ad_group(id)
- ad(ad_group_id) → ad_group(id)
- campaign_custom_audience(campaign_id) → campaign(id)
- campaign(ad_account_id) → ad_account(id)
- campaign_conversion_event_setting(campaign_id) → campaign(id)
- ad_group_product_set_filter(ad_group_id) → ad_group(id)
- campaign_targeting_geo_location(campaign_id) → campaign(id)
- ad_report_daily(ad_id) → ad(id)
- ad_report_daily(ad_account_id) → ad_account(id)
- ad_report_daily(ad_group_id) → ad_group(id)
- ad_report_daily(campaign_id) → campaign(id)