rpt_ads_campaign_daily

Amazon Ads reports · ads-performance-v1/campaign-daily · Delivered by Amazon Marketing Stream, hourly

How fresh is it?

Hourly

Delivered by Amazon Marketing Stream, hourly

Need it right now?

—

No live tool answers this — query the synced rows.

Family	Amazon Ads reports
Report type	`ads-performance-v1/campaign-daily`
Grain	`per_mkt`
Sync	incremental
Business date	`report_date`

Columns (145)

Column	Type	Key
`id`	`BIGINT`
`store_id`	`VARCHAR(36)`	🔑 key
`country_code`	`VARCHAR(8)`	🔑 key
`report_date`	`DATE`	🔑 key
`ad_product`	`VARCHAR(64)`	🔑 key
`campaign_id`	`VARCHAR(64)`	🔑 key
`time_zone`	`TEXT`
`currency`	`TEXT`
`advertiser_account_id`	`TEXT`
`profile_id`	`TEXT`
`attribution_window_days`	`SMALLINT`
`extra`	`JSONB`
`ingested_at`	`TIMESTAMP WITH TIME ZONE`
`impressions`	`NUMERIC(18, 8)`
`invalid_impressions`	`NUMERIC(18, 8)`
`main_imdb_ad_impressions`	`NUMERIC(18, 8)`
`clicks`	`NUMERIC(18, 8)`
`gross_clicks`	`NUMERIC(18, 8)`
`invalid_clicks`	`NUMERIC(18, 8)`
`main_imdb_ad_clicks`	`NUMERIC(18, 8)`
`measurable_impressions`	`NUMERIC(18, 8)`
`viewable_impressions`	`NUMERIC(18, 8)`
`supply_cost`	`NUMERIC(18, 8)`
`total_cost`	`NUMERIC(18, 8)`
`interactive_impressions`	`NUMERIC(18, 8)`
`notification_opens`	`NUMERIC(18, 8)`
`notification_clicks`	`NUMERIC(18, 8)`
`starts_video_ad`	`NUMERIC(18, 8)`
`first_quartile_video_ad`	`NUMERIC(18, 8)`
`midpoint_video_ad`	`NUMERIC(18, 8)`
`third_quartile_video_ad`	`NUMERIC(18, 8)`
`complete_views_video_ad`	`NUMERIC(18, 8)`
`pauses_video_ad`	`NUMERIC(18, 8)`
`resumes_video_ad`	`NUMERIC(18, 8)`
`mutes_video_ad`	`NUMERIC(18, 8)`
`starts_audio_ad`	`NUMERIC(18, 8)`
`unmutes_video_ad`	`NUMERIC(18, 8)`
`first_quartile_audio_ad`	`NUMERIC(18, 8)`
`replays_video_ad`	`NUMERIC(18, 8)`
`midpoint_audio_ad`	`NUMERIC(18, 8)`
`skips_back_video_ad`	`NUMERIC(18, 8)`
`skips_forward_video_ad`	`NUMERIC(18, 8)`
`third_quartile_audio_ad`	`NUMERIC(18, 8)`
`complete_listens_audio_ad`	`NUMERIC(18, 8)`
`impressions_video_ad`	`NUMERIC(18, 8)`
`five_second_views_video_ad`	`NUMERIC(18, 8)`
`pauses_audio_ad`	`NUMERIC(18, 8)`
`resumes_audio_ad`	`NUMERIC(18, 8)`
`mutes_audio_ad`	`NUMERIC(18, 8)`
`unmutes_audio_ad`	`NUMERIC(18, 8)`
`rewinds_audio_ad`	`NUMERIC(18, 8)`
`skips_audio_ad`	`NUMERIC(18, 8)`
`impressions_audio_ad`	`NUMERIC(18, 8)`
`plays_audio_ad`	`NUMERIC(18, 8)`
`progress_audio_ad`	`NUMERIC(18, 8)`
`purchases`	`NUMERIC(18, 8)`
`sales`	`NUMERIC(18, 8)`
`units_sold`	`NUMERIC(18, 8)`
`purchases_from_clicks`	`NUMERIC(18, 8)`
`sales_from_clicks`	`NUMERIC(18, 8)`
`units_sold_from_clicks`	`NUMERIC(18, 8)`
`purchases_from_views`	`NUMERIC(18, 8)`
`sales_from_views`	`NUMERIC(18, 8)`
`units_sold_from_views`	`NUMERIC(18, 8)`
`purchases_promoted`	`NUMERIC(18, 8)`
`sales_promoted`	`NUMERIC(18, 8)`
`units_sold_promoted`	`NUMERIC(18, 8)`
`purchases_from_clicks_promoted`	`NUMERIC(18, 8)`
`sales_from_clicks_promoted`	`NUMERIC(18, 8)`
`units_sold_from_clicks_promoted`	`NUMERIC(18, 8)`
`purchases_from_views_promoted`	`NUMERIC(18, 8)`
`sales_from_views_promoted`	`NUMERIC(18, 8)`
`units_sold_from_views_promoted`	`NUMERIC(18, 8)`
`purchases_halo`	`NUMERIC(18, 8)`
`sales_halo`	`NUMERIC(18, 8)`
`units_sold_halo`	`NUMERIC(18, 8)`
`purchases_from_clicks_halo`	`NUMERIC(18, 8)`
`sales_from_clicks_halo`	`NUMERIC(18, 8)`
`units_sold_from_clicks_halo`	`NUMERIC(18, 8)`
`purchases_from_views_halo`	`NUMERIC(18, 8)`
`sales_from_views_halo`	`NUMERIC(18, 8)`
`units_sold_from_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_purchases`	`NUMERIC(18, 8)`
`new_to_brand_sales`	`NUMERIC(18, 8)`
`new_to_brand_units_sold`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_clicks`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_clicks`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_clicks`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_views`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_views`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_views`	`NUMERIC(18, 8)`
`new_to_brand_purchases_promoted`	`NUMERIC(18, 8)`
`new_to_brand_sales_promoted`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_promoted`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_clicks_promoted`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_clicks_promoted`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_clicks_promoted`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_purchases_halo`	`NUMERIC(18, 8)`
`new_to_brand_sales_halo`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_halo`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_clicks_halo`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_clicks_halo`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_clicks_halo`	`NUMERIC(18, 8)`
`new_to_brand_purchases_from_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_sales_from_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_units_sold_from_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_clicks`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_views`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_clicks_promoted`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_clicks_halo`	`NUMERIC(18, 8)`
`new_to_brand_detail_page_views_from_views_halo`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_clicks`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_views`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_promoted`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_clicks_promoted`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_views_promoted`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_halo`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_clicks_halo`	`NUMERIC(18, 8)`
`new_to_brand_add_to_cart_from_views_halo`	`NUMERIC(18, 8)`
`detail_page_views`	`NUMERIC(18, 8)`
`detail_page_views_from_clicks`	`NUMERIC(18, 8)`
`detail_page_views_from_views`	`NUMERIC(18, 8)`
`detail_page_views_promoted`	`NUMERIC(18, 8)`
`detail_page_views_from_clicks_promoted`	`NUMERIC(18, 8)`
`detail_page_views_from_views_promoted`	`NUMERIC(18, 8)`
`detail_page_views_halo`	`NUMERIC(18, 8)`
`detail_page_views_from_clicks_halo`	`NUMERIC(18, 8)`
`detail_page_views_from_views_halo`	`NUMERIC(18, 8)`
`add_to_cart`	`NUMERIC(18, 8)`
`add_to_cart_from_clicks`	`NUMERIC(18, 8)`
`add_to_cart_from_views`	`NUMERIC(18, 8)`
`add_to_cart_promoted`	`NUMERIC(18, 8)`
`add_to_cart_from_clicks_promoted`	`NUMERIC(18, 8)`
`add_to_cart_from_views_promoted`	`NUMERIC(18, 8)`
`add_to_cart_halo`	`NUMERIC(18, 8)`
`add_to_cart_from_clicks_halo`	`NUMERIC(18, 8)`
`add_to_cart_from_views_halo`	`NUMERIC(18, 8)`

Query it

In an AI client (MCP)

tools/call

{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_ads_campaign_daily"
    ],
    "columns": [
      "rpt_ads_campaign_daily.country_code",
      "rpt_ads_campaign_daily.report_date",
      "rpt_ads_campaign_daily.ad_product",
      "rpt_ads_campaign_daily.campaign_id"
    ],
    "order_by": [
      {
        "column": "rpt_ads_campaign_daily.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_ads_campaign_daily"],"columns":["rpt_ads_campaign_daily.country_code","rpt_ads_campaign_daily.report_date","rpt_ads_campaign_daily.ad_product","rpt_ads_campaign_daily.campaign_id"],"order_by":[{"column":"rpt_ads_campaign_daily.report_date","dir":"desc"}],"limit":100}'

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

Columns (145)Copy Anchor Link

Query itCopy Anchor Link

On this page

Columns (145)

Query it