Skip to main content

Advertising Prism Frameworks

Use these framework definitions to reconstruct Advertising Prisms as daily Explorer purchases. Follow the shared workflow in Reconstructing Prism Frameworks: refresh the rolling date window, build_framework, check_framework_price, then buy_frameworks.

This category includes 2 Prisms (Back to School Ad Spend, Leisure Ad Spend).

Purchases bill your account

buy_frameworks charges your wallet. Always price first with check_framework_price.

Framework payloads

Paste each framework object into your daily job after replacing filters.date_range with the rolling window (month-start minus 24 months → today). Keep date_resolution: "day" and aggregate: "sum".

1. Back to School Ad Spend

  • prism_id: 5a772bf9-f662-426c-9836-9672cd703560
  • latest_framework_id: 0369f4ce-34bf-41d1-83c7-c41cb49f251f
  • Growth question: Which retail categories are increasing ad spend the most?
  • Share question: Which retail categories are capturing the most ad spend?
{
  "entities": [
    {
      "carc_id": 798,
      "representation": "category",
      "entity_name": "Broadline Retail"
    },
    {
      "carc_id": 125,
      "representation": "category",
      "entity_name": "Footwear Retail"
    },
    {
      "carc_id": 809,
      "representation": "category",
      "entity_name": "Consumer Electronics Retail"
    },
    {
      "carc_id": 280,
      "representation": "category",
      "entity_name": "Sporting Goods Retail"
    },
    {
      "carc_id": 292,
      "representation": "category",
      "entity_name": "Teen Clothing Retail"
    }
  ],
  "insight": {
    "insight_id": 245,
    "insight_name": "Advertising Spend"
  },
  "filters": {
    "date_resolution": "day",
    "location_resolution": "us",
    "date_range": {
      "start_date": "2024-09-01",
      "end_date": "2026-09-12"
    }
  },
  "aggregate": "sum"
}

2. Leisure Ad Spend

  • prism_id: 069134cd-4854-4ba3-9986-1a7a5a331f04
  • latest_framework_id: d21eb3b5-e82c-46e7-8163-7bcd0254d8c9
  • Growth question: Which discretionary categories are ramping ad spend fastest?
  • Share question: Which discretionary categories are capturing the most ad spend?
{
  "entities": [
    {
      "carc_id": 114,
      "representation": "category",
      "entity_name": "Film & Tv Streaming"
    },
    {
      "carc_id": 311,
      "representation": "category",
      "entity_name": "Video Games"
    },
    {
      "carc_id": 327,
      "representation": "category",
      "entity_name": "Online Sportsbook"
    },
    {
      "carc_id": 842,
      "representation": "category",
      "entity_name": "Casino"
    },
    {
      "carc_id": 936,
      "representation": "category",
      "entity_name": "Fitness Centers"
    },
    {
      "carc_id": 5,
      "representation": "category",
      "entity_name": "Amusement Parks & Tourist Attractions"
    }
  ],
  "insight": {
    "insight_id": 245,
    "insight_name": "Advertising Spend"
  },
  "filters": {
    "date_resolution": "day",
    "location_resolution": "us",
    "date_range": {
      "start_date": "2024-09-01",
      "end_date": "2026-09-12"
    }
  },
  "aggregate": "sum"
}