Custom Categories Table

The Custom Categories table defines your custom ad campaign groupings, such as tactic, geography, funnel stage, or product line. One row per active subcategory, with its classification rule and provider scope. Learn more about Custom Categories for Campaign Organization.

📋

Table Guide

What You Can Answer With This Table

  • How are my custom ad campaign groups organized? — use category_name, sub_category_name, created_at
  • Which rules and platform scopes define each campaign subcategory? — use ai_rule, include_providers, exclude_providers

Before You Query

  • This table is not time-series. No event_date filter is needed. Use created_at if you want to narrow to a creation-date range.

Key Relationships

TableJoin KeyUse This Join To
Custom Category Mappingssub_category_idGroup and compare Ads performance by custom category/subcategory.

View the full Triple Whale Data Ontology →

Dimensions

Dimensions are immutable properties that can be used for grouping data.

TitleIDTypeDescription
AI Ruleai_rulestringThe AI rule used to classify campaigns into subcategories.Example values: customers aged 18-24, campaigns targeting South America, branded search ads, influencer collaborations
Category IDcategory_idstringThe ID of the category (grouping dimension, e.g., Tactic, Geography, Product).Example value: 09f58489-713a-4866-bce4-1040c9a1ee71
Category Namecategory_namestringThe name of the category (grouping dimension).Example values: Geography, Tactic, Funnel
Subcategory Created Datecreated_atdateThe date the subcategory was created.Example value: 2025-09-08
Exclude Providersexclude_providersrepeated stringThe providers excluded from the subcategory.Example values: facebook-ads, google-ads, tiktok-ads
Include Providersinclude_providersrepeated stringThe providers included in the subcategory.Example values: facebook-ads, google-ads, tiktok-ads
Subcategory IDsub_category_idstringThe ID of the subcategory.Example value: 46c71065-5bbb-4ab6-81ee-39078b23cca0
Subcategory Namesub_category_namestringThe name of the subcategory (specific group within a category).Example values: 18-24, Peru, Meta Prospecting, Google PMAX