Customers with multiple businesses in Triple Whale can now split data by business in a single dashboard using the Business ID (shop_id) field.
Previously, querying multiple businesses would show aggregated stats across all selected businesses, but without any way to group or filter by business. Now, users can break out metrics by individual business, enabling better reporting for brands with regional storefronts and agencies managing multiple clients.
Tables that now support breakdown by business:
Orders (
orders_table)Pixel Orders (
pixel_orders_table)Pixel Add to Carts (
pixel_add_to_carts_table)Sessions (
sessions_table)Pixel Joined (
pixel_joined_tvf())
Key use cases:
Brands with regional storefronts (e.g., US / UK / CA) can compare performance by region.
Agencies managing multiple client businesses can break out reporting by client.
Agents can now be built using a single query across businesses, with business level breakdowns.
How to use it for SQL:
Enable multiple businesses in the selector at the top left menu.
Use
shop_idin your SQL query to break down results, just like you would for any other dimension (e.g. campaign_id, product_id, customer_id)
How to use it for Agents:
In the Finish Up popup, confirm which Business IDs should be applied - by default they will be the businesses currently selected, but you can add/remove from here to choose different businesses. (You can also come back to this popup later from the Agent editor and edit which businesses are selected: Customize > Arrow next to Save button > Settings and Schedule)
Once selected and saved in an Agent, the business selection persists when the Agent is run—even if those businesses are later unchecked in the UI.
