# Rakuten Advertising schema ERD

Table and field reference for the Fivetran Rakuten Advertising connector.

## Table & Field Reference

### report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| average_item_value | Unknown |  |
| average_order_value | Unknown |  |
| click_position | Unknown |  |
| click_through_rate | Unknown |  |
| commission_type | Unknown |  |
| consumer_country | Unknown |  |
| estimated_commissions | Unknown |  |
| link_type | Unknown |  |
| net_items_per_order | Unknown |  |
| no_of_cancelled_items | Unknown |  |
| no_of_clicks | Unknown |  |
| no_of_impressions | Unknown |  |
| no_of_items | Unknown |  |
| no_of_net_items | Unknown |  |
| no_of_orders | Unknown |  |
| no_of_orders_or_clicks | Unknown |  |
| offer_group_id | Unknown |  |
| offer_name | Unknown |  |
| order_id | Unknown |  |
| process_date | Unknown |  |
| product_name | Unknown |  |
| publisher_id | Unknown |  |
| publisher_name | Unknown |  |
| report_name | String |  |
| sales | Unknown |  |
| sku | Unknown |  |
| total_commission | Unknown |  |
| transaction_date | LocalDate |  |
| transaction_id | Unknown |  |
| transaction_time | Unknown |  |
| transaction_week_begin_date | LocalDate |  |
| transaction_week_end_date | LocalDate |  |