rpt_sb_keywords

How fresh is it?

Daily

Daily at 01:00 marketplace local time

Need it right now?

ads_query_targetread

Live: current bids and state

Family	Amazon Ads reports
Report type	`sbKeywords`
Grain	`per_mkt`
Sync	incremental
Business date	`report_date`

Columns (68)

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`
`keyword_id`	`VARCHAR(100)`	🔑 key
`keyword`	`TEXT`
`match_type`	`VARCHAR(100)`	🔑 key
`campaign_status`	`VARCHAR(50)`
`keyword_status`	`VARCHAR(50)`
`keyword_bid`	`NUMERIC(10, 4)`
`keyword_type`	`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

In an AI client (MCP)

tools/call

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

From code (Tool API)

curl -X POST https://api.sellersheetai.com/api/v1/tools/query_report_data \
  -H "Authorization: Bearer $SELLERSHEET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"store":"myStore-US","tables":["rpt_sb_keywords"],"columns":["rpt_sb_keywords.profile_id","rpt_sb_keywords.report_date","rpt_sb_keywords.campaign_id","rpt_sb_keywords.ad_group_id"],"order_by":[{"column":"rpt_sb_keywords.report_date","dir":"desc"}],"limit":100}'

Early access — the Tool API is open on request, contact us.

Columns (68)Copy Anchor Link

Query itCopy Anchor Link

On this page

Columns (68)

Query it