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

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

- Family: ads
- Report type: `ads-performance-v1/campaign-daily`
- How fresh: Hourly — Delivered by Amazon Marketing Stream, hourly
- Need it right now: synced only
- Grain: per_mkt · sync: incremental

## Columns

| 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

```json
{
  "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
  }
}
```