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 each category or subcategory? — use campaign_id, provider_id, sub_category_id
• Which channels or categories have the most mapped campaigns? — group by provider_id, category_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.
• A campaign can appear more than once when it is mapped to multiple categories or subcategories.

Key Relationships

Table	Join Key	Use This Join To
Custom Categories	sub_category_id	Group mapped campaigns by configured category/subcategory labels and rules.
Ads	campaign_id, provider_id to channel	Roll campaign-level ad-platform performance up to custom categories.

View the full Triple Whale Data Ontology →

Dimensions

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