# Amazon Attribution schema ERD

Table and field reference for the Fivetran Amazon Attribution connector.

## Table & Field Reference

### advertiser

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| profile_id | Unknown | FK |
| advertiser_name | Unknown |  |

### performance_report_by_creative

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Unknown |  |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| attributed_add_to_cart_clicks_14_d | Unknown |  |
| attributed_detail_page_views_clicks_14_d | Unknown |  |
| attributed_purchases_14_d | Unknown |  |
| attributed_sales_14_d | Unknown |  |
| attributed_total_add_to_cart_clicks_14_d | Unknown |  |
| attributed_total_detail_page_views_clicks_14_d | Unknown |  |
| attributed_total_purchases_14_d | Unknown |  |
| campaign_id | Unknown |  |
| click_throughs | Unknown |  |
| creative_id | Unknown |  |
| date | Unknown |  |
| kindle_edition_normalized_pages_read_14_d | Unknown |  |
| kindle_edition_normalized_pages_royalties_14_d | Unknown |  |
| publisher | Unknown |  |
| total_attributed_sales_14_d | Unknown |  |
| total_units_sold_14_d | Unknown |  |
| units_sold_14_d | Unknown |  |

### profile

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| account_marketplace_string_id | Unknown |  |
| account_name | Unknown |  |
| account_type | Unknown |  |
| account_valid_payment_method | Unknown |  |
| country_code | Unknown |  |
| currency_code | Unknown |  |
| daily_budget | Unknown |  |
| timezone | Unknown |  |

### performance_report_by_campaign

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| attributed_add_to_cart_clicks_14_d | Unknown |  |
| attributed_detail_page_views_clicks_14_d | Unknown |  |
| attributed_purchases_14_d | Unknown |  |
| attributed_sales_14_d | Unknown |  |
| attributed_total_add_to_cart_clicks_14_d | Unknown |  |
| attributed_total_detail_page_views_clicks_14_d | Unknown |  |
| attributed_total_purchases_14_d | Unknown |  |
| brb_bonus_amount | Unknown |  |
| campaign_id | Unknown |  |
| click_throughs | Unknown |  |
| date | Unknown |  |
| kindle_edition_normalized_pages_read_14_d | Unknown |  |
| kindle_edition_normalized_pages_royalties_14_d | Unknown |  |
| total_attributed_sales_14_d | Unknown |  |
| total_units_sold_14_d | Unknown |  |
| units_sold_14_d | Unknown |  |

### performance_report_by_adgroup

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Unknown |  |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| attributed_add_to_cart_clicks_14_d | Unknown |  |
| attributed_detail_page_views_clicks_14_d | Unknown |  |
| attributed_purchases_14_d | Unknown |  |
| attributed_sales_14_d | Unknown |  |
| attributed_total_add_to_cart_clicks_14_d | Unknown |  |
| attributed_total_detail_page_views_clicks_14_d | Unknown |  |
| attributed_total_purchases_14_d | Unknown |  |
| brb_bonus_amount | Unknown |  |
| campaign_id | Unknown |  |
| click_throughs | Unknown |  |
| date | Unknown |  |
| kindle_edition_normalized_pages_read_14_d | Unknown |  |
| kindle_edition_normalized_pages_royalties_14_d | Unknown |  |
| publisher | Unknown |  |
| total_attributed_sales_14_d | Unknown |  |
| total_units_sold_14_d | Unknown |  |
| units_sold_14_d | Unknown |  |

### product_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| ad_group_id | Unknown |  |
| advertiser_id | Unknown |  |
| advertiser_name | Unknown |  |
| attributed_add_to_cart_clicks_14_d | Unknown |  |
| attributed_detail_page_views_clicks_14_d | Unknown |  |
| attributed_new_to_brand_purchases_14_d | Unknown |  |
| attributed_new_to_brand_sales_14_d | Unknown |  |
| attributed_new_to_brand_units_sold_14_d | Unknown |  |
| attributed_purchases_14_d | Unknown |  |
| attributed_sales_14_d | Unknown |  |
| brand_halo_attributed_add_to_cart_clicks_14_d | Unknown |  |
| brand_halo_attributed_purchases_14_d | Unknown |  |
| brand_halo_attributed_sales_14_d | Unknown |  |
| brand_halo_detail_page_views_clicks_14_d | Unknown |  |
| brand_halo_new_to_brand_purchases_14_d | Unknown |  |
| brand_halo_new_to_brand_sales_14_d | Unknown |  |
| brand_halo_new_to_brand_units_sold_14_d | Unknown |  |
| brand_halo_units_sold_14_d | Unknown |  |
| brand_name | Unknown |  |
| campaign_id | Unknown |  |
| date | Unknown |  |
| kindle_edition_normalized_pages_read_14_d | Unknown |  |
| kindle_edition_normalized_pages_royalties_14_d | Unknown |  |
| marketplace | Unknown |  |
| product_asin | Unknown |  |
| product_category | Unknown |  |
| product_conversion_type | Unknown |  |
| product_group | Unknown |  |
| product_name | Unknown |  |
| product_subcategory | Unknown |  |
| publisher | Unknown |  |
| units_sold_14_d | Unknown |  |

## Relationships

- advertiser(profile_id) → profile(id)