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

> Amazon Ads reports · AMC_NTB_GATEWAY_ASINS · Every 4 weeks (on demand, 15 days after the 28-day period ends)

- Family: ads
- Report type: `AMC_NTB_GATEWAY_ASINS`
- How fresh: Weekly — Every 4 weeks (on demand, 15 days after the 28-day period ends)
- 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 |
| `period_start` | DATE | key |
| `period_days` | INTEGER |  |
| `dims_key` | VARCHAR(40) | key |
| `hidden` | BOOLEAN | key |
| `tracked_asin` | TEXT |  |
| `purchases` | BIGINT |  |
| `ntb_purchases` | BIGINT |  |
| `sales` | NUMERIC(20, 4) |  |
| `ntb_sales` | NUMERIC(20, 4) |  |
| `template_version` | INTEGER |  |
| `workflow_execution_id` | VARCHAR(64) |  |
| `extra` | JSON |  |
| `ingested_at` | TIMESTAMP WITH TIME ZONE |  |

## Query it

```json
{
  "name": "query_report_data",
  "arguments": {
    "store": "myStore-US",
    "tables": [
      "rpt_amc_ntb_gateway_asins"
    ],
    "columns": [
      "rpt_amc_ntb_gateway_asins.country_code",
      "rpt_amc_ntb_gateway_asins.period_start",
      "rpt_amc_ntb_gateway_asins.dims_key",
      "rpt_amc_ntb_gateway_asins.hidden"
    ],
    "order_by": [
      {
        "column": "rpt_amc_ntb_gateway_asins.period_start",
        "dir": "desc"
      }
    ],
    "limit": 100
  }
}
```