Customers with multiple shops in Triple Whale can now split data by shop in a single dashboard using the Shop ID (shop_id) field.
Previously, querying multiple shops would show aggregated stats across all selected stores, but without any way to group or filter by shop. Now, users can break out metrics by individual shop, enabling better reporting for brands with regional storefronts and agencies managing multiple clients.
Tables that now support breakdown by shop:
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 shops can break out reporting by client.
Agents can now be built using a single query across shops, with store-level breakdowns.
How to use it for SQL:
Enable multiple shops 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 Shop IDs should be applied - by default they will be the shops currently selected, but you can add/remove from here to choose different shops. (You can also come back to this popup later from the Agent editor and edit which stores are selected: Customize > Arrow next to Save button > Settings and Schedule)
Once selected and saved in an Agent, the shop selection persists when the Agent is run—even if those shops are later unchecked in the UI.
