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

> Amazon Ads reports · ads-roster/campaigns · Daily at 01:40 marketplace local time

- Family: ads
- Report type: `ads-roster/campaigns`
- How fresh: Daily — Daily at 01:40 marketplace local time
- Need it right now: synced only
- Grain: per_mkt · sync: incremental

## Columns

| Column | Type | Key |
|---|---|---|
| `store_id` | VARCHAR(36) | key |
| `campaign_id` | VARCHAR(64) | key |
| `name` | TEXT |  |
| `state` | TEXT |  |
| `budget` | NUMERIC(18, 4) |  |
| `budget_type` | TEXT |  |
| `portfolio_id` | TEXT |  |
| `targeting_type` | TEXT |  |
| `start_date` | TEXT |  |
| `end_date` | TEXT |  |
| `id` | BIGINT |  |
| `country_code` | VARCHAR(8) | key |
| `ad_product` | VARCHAR(32) | key |
| `profile_id` | VARCHAR(32) |  |
| `first_seen_on` | DATE |  |
| `last_seen_on` | DATE |  |
| `attributes` | JSONB |  |
| `ingested_at` | TIMESTAMP WITH TIME ZONE |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_ads_campaigns"
    ],
    "columns": [
      "rpt_ads_campaigns.campaign_id",
      "rpt_ads_campaigns.country_code",
      "rpt_ads_campaigns.ad_product"
    ],
    "order_by": [
      {
        "column": "rpt_ads_campaigns.last_seen_on",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```