# rpt_sb_targets (https://sellersheetai.com/docs/data/rpt_sb_targets)

> Amazon Ads reports · sbTargets · Daily at 01:00 marketplace local time

- Family: ads
- Report type: `sbTargets`
- How fresh: Daily — Daily at 01:00 marketplace local time
- Need it right now: [`ads_query_target`](https://sellersheetai.com/docs/mcp-api/tools/ads_query_target) (current bids and state)
- Grain: per_mkt · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `profile_id` | VARCHAR(50) | key |
| `country_code` | VARCHAR(16) |  |
| `report_date` | DATE | key |
| `start_date` | DATE |  |
| `end_date` | DATE |  |
| `ingested_at` | TIMESTAMP WITH TIME ZONE |  |
| `currency_code` | VARCHAR(10) |  |
| `campaign_id` | VARCHAR(100) | key |
| `campaign_name` | TEXT |  |
| `campaign_budget` | NUMERIC(14, 4) |  |
| `campaign_budget_type` | VARCHAR(50) |  |
| `ad_group_id` | VARCHAR(100) | key |
| `ad_group_name` | TEXT |  |
| `target_id` | VARCHAR(100) | key |
| `targeting_expression` | TEXT |  |
| `targeting_text` | TEXT |  |
| `targeting_type` | VARCHAR(100) |  |
| `match_type` | VARCHAR(100) |  |
| `target_status` | VARCHAR(50) |  |
| `bid` | NUMERIC(10, 4) |  |
| `campaign_status` | VARCHAR(50) |  |
| `cost_type` | VARCHAR(50) |  |
| `impressions` | INTEGER |  |
| `clicks` | INTEGER |  |
| `cost` | NUMERIC(14, 4) |  |
| `top_of_search_impression_share` | NUMERIC(10, 4) |  |
| `detail_page_views` | INTEGER |  |
| `detail_page_views_clicks` | INTEGER |  |
| `add_to_cart` | INTEGER |  |
| `add_to_cart_clicks` | INTEGER |  |
| `add_to_cart_rate` | NUMERIC(10, 4) |  |
| `e_cp_add_to_cart` | NUMERIC(14, 4) |  |
| `purchases` | INTEGER |  |
| `purchases_clicks` | INTEGER |  |
| `purchases_promoted` | INTEGER |  |
| `sales` | NUMERIC(14, 4) |  |
| `sales_clicks` | NUMERIC(14, 4) |  |
| `sales_promoted` | NUMERIC(14, 4) |  |
| `units_sold` | INTEGER |  |
| `units_sold_clicks` | INTEGER |  |
| `new_to_brand_purchases` | INTEGER |  |
| `new_to_brand_purchases_clicks` | INTEGER |  |
| `new_to_brand_purchases_rate` | NUMERIC(10, 4) |  |
| `new_to_brand_purchases_percentage` | NUMERIC(10, 4) |  |
| `new_to_brand_sales` | NUMERIC(14, 4) |  |
| `new_to_brand_sales_clicks` | NUMERIC(14, 4) |  |
| `new_to_brand_sales_percentage` | NUMERIC(10, 4) |  |
| `new_to_brand_units_sold` | INTEGER |  |
| `new_to_brand_units_sold_clicks` | INTEGER |  |
| `new_to_brand_units_sold_percentage` | NUMERIC(10, 4) |  |
| `new_to_brand_detail_page_views` | INTEGER |  |
| `new_to_brand_detail_page_views_clicks` | INTEGER |  |
| `new_to_brand_detail_page_view_rate` | NUMERIC(10, 4) |  |
| `new_to_brand_e_cp_detail_page_view` | NUMERIC(14, 4) |  |
| `branded_searches` | INTEGER |  |
| `branded_searches_clicks` | INTEGER |  |
| `video_complete_views` | INTEGER |  |
| `video_midpoint_views` | INTEGER |  |
| `video_first_quartile_views` | INTEGER |  |
| `video_third_quartile_views` | INTEGER |  |
| `video_5_second_views` | INTEGER |  |
| `video_5_second_view_rate` | NUMERIC(10, 4) |  |
| `video_unmutes` | INTEGER |  |
| `viewable_impressions` | INTEGER |  |
| `viewability_rate` | NUMERIC(10, 4) |  |
| `view_click_through_rate` | NUMERIC(10, 4) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_sb_targets"
    ],
    "columns": [
      "rpt_sb_targets.profile_id",
      "rpt_sb_targets.report_date",
      "rpt_sb_targets.campaign_id",
      "rpt_sb_targets.ad_group_id"
    ],
    "order_by": [
      {
        "column": "rpt_sb_targets.report_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```