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

> Amazon Ads reports · spCampaignNegativeTargets · Daily at 01:16 marketplace local time

- Family: ads
- Report type: `spCampaignNegativeTargets`
- How fresh: Daily — Daily at 01:16 marketplace local time
- Need it right now: [`ads_query_target`](https://sellersheetai.com/docs/mcp-api/tools/ads_query_target)
- Grain: per_mkt · sync: snapshot

## Columns

| Column | Type | Key |
|---|---|---|
| `id` | INTEGER |  |
| `store_id` | VARCHAR(36) | key |
| `profile_id` | VARCHAR(50) | key |
| `country_code` | VARCHAR(16) |  |
| `snapshot_date` | DATE | key |
| `ingested_at` | TIMESTAMP WITH TIME ZONE |  |
| `target_id` | VARCHAR(50) | key |
| `campaign_id` | VARCHAR(50) |  |
| `targeting_expression` | TEXT |  |
| `expression_type` | VARCHAR(40) |  |
| `state` | VARCHAR(20) |  |
| `extra` | JSON |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_sp_campaign_negative_targets"
    ],
    "columns": [
      "rpt_sp_campaign_negative_targets.profile_id",
      "rpt_sp_campaign_negative_targets.snapshot_date",
      "rpt_sp_campaign_negative_targets.target_id"
    ],
    "order_by": [
      {
        "column": "rpt_sp_campaign_negative_targets.snapshot_date",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```