The Custom Category Mappings table assigns individual campaigns to user-defined categories and subcategories. One row per active campaign-to-subcategory mapping. Learn more about Custom Categories for Campaign Organization.

📋

Table Guide

What You Can Answer With This Table

• Which campaigns are assigned to a given subcategory? — use campaign_id, campaign_name, provider_id, filter by sub_category_id
• How are mappings distributed across categories or subcategories? — group by category_id or sub_category_id
• Which channels are most represented in my custom groupings? — group by provider_id, category_id
• What campaign-to-subcategory mappings were created recently? — use created_at, campaign_id, sub_category_id

Before You Query

• This table is not time-series. No event_date filter is needed. Use created_at if you want to narrow to when the mapping was created.
• Only active mappings are returned. Inactive mappings are excluded by the query layer and cannot be retrieved here.
• A single campaign can appear in multiple rows when it is mapped under more than one category (e.g., one row for Geography and another for Tactic).

Key Relationships

Table	Join Key	What the Join Enables
Custom Categories	sub_category_id	Category and subcategory names, AI rule definitions, and provider scopes for each mapped subcategory.
Ads	campaign_id	Campaign-level ad-platform performance (spend, clicks, conversions), so you can analyze metrics by your custom categories.

When to Use a Different Table

• For the category and subcategory definitions, AI rules, and provider scopes themselves → use Custom Categories. This table only carries the campaign-level assignments.

View the full Triple Whale Data Ontology →

Dimensions

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