Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Triple Whale data to
Triple Whale Connector Reference
64 metrics81 dimensions
The Triple Whale connector exposes 145 fields (64 metrics, 81 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Triple Whale Fields
Triple Whale Ads fields
The Ads report of the Triple Whale connector includes 20 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| ads_ad | TEXT | Ads Ad | The name of the ad. |
| ads_ad_id | TEXT | Ads Ad ID | The unique identifier of the ad. |
| ads_ad_type | TEXT | Ads Ad Type | The type of the ad. |
| ads_adset | TEXT | Ads Ad Set | The name of the ad set. |
| ads_adset_id | TEXT | Ads Ad Set ID | The unique identifier of the ad set. |
| ads_campaign | TEXT | Ads Campaign | The name of the campaign. |
| ads_campaign_id | TEXT | Ads Campaign ID | The unique identifier of the campaign. |
| ads_channel | TEXT | Ads Channel | The marketing channel of the ad (e.g. facebook-ads). |
| ads_clicks | NUMERIC | Ads Clicks | The number of times the ad was clicked. |
| ads_conversion_value | NUMERIC | Ads Conversion Value | The total value of conversions attributed to the ad. |
| ads_conversions | NUMERIC | Ads Conversions | The number of conversions attributed to the ad. |
| ads_cpc | NUMERIC | Ads CPC | Cost per click: spend divided by clicks. |
| ads_cpm | NUMERIC | Ads CPM | Cost per mille: spend per thousand impressions. |
| ads_creative_format | TEXT | Ads Creative Format | The format of the creative (e.g. video, image). |
| ads_creative_id | TEXT | Ads Creative ID | The unique identifier of the creative. |
| ads_ctr | PERCENT | Ads CTR | Click-through rate: clicks divided by impressions. |
| ads_impressions | NUMERIC | Ads Impressions | The number of times the ad was shown. |
| ads_reach | NUMERIC | Ads Reach | The number of unique users who saw the ad. |
| ads_roas | NUMERIC | Ads ROAS | Return on ad spend: conversion value divided by spend. |
| ads_spend | NUMERIC | Ads Spend | The amount spent on the ad. |
Triple Whale Attributed Orders fields
The Attributed Orders report of the Triple Whale connector includes 17 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| attributed_order_ad_id | TEXT | Attributed Order Ad ID | The unique identifier of the attributed ad. |
| attributed_order_adset_id | TEXT | Attributed Order Ad Set ID | The unique identifier of the attributed ad set. |
| attributed_order_attribution_model | TEXT | Attributed Order Attribution Model | The attribution model applied to the order. |
| attributed_order_campaign | TEXT | Attributed Order Campaign | The name of the attributed campaign. |
| attributed_order_campaign_id | TEXT | Attributed Order Campaign ID | The unique identifier of the attributed campaign. |
| attributed_order_channel | TEXT | Attributed Order Channel | The attributed marketing channel of the order. |
| attributed_order_customer_id | TEXT | Attributed Order Customer ID | The unique identifier of the customer who placed the order. |
| attributed_order_gross_sales | NUMERIC | Attributed Order Gross Sales | Gross sales of the attributed order. |
| attributed_order_id | TEXT | Attributed Order ID | The unique identifier of the attributed order. |
| attributed_order_is_new_customer | BOOLEAN | Attributed Order Is New Customer | Whether the order was placed by a new customer. |
| attributed_order_landing_page | TEXT | Attributed Order Landing Page | The landing page associated with the order. |
| attributed_order_linear_weight | NUMERIC | Attributed Order Linear Weight | The linear attribution credit assigned to the touch. |
| attributed_order_name | TEXT | Attributed Order Name | The display name of the attributed order. |
| attributed_order_revenue | NUMERIC | Attributed Order Revenue | Revenue of the attributed order. |
| attributed_order_source_name | TEXT | Attributed Order Source Name | The attributed source of the order. |
| attributed_order_utm_medium | TEXT | Attributed Order UTM Medium | The UTM medium of the order. |
| attributed_order_utm_source | TEXT | Attributed Order UTM Source | The UTM source of the order. |
Triple Whale Attribution fields
The Attribution report of the Triple Whale connector includes 22 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| attribution_ad | TEXT | Attribution Ad | The name of the ad. |
| attribution_ad_id | TEXT | Attribution Ad ID | The unique identifier of the ad. |
| attribution_adset | TEXT | Attribution Ad Set | The name of the ad set. |
| attribution_adset_id | TEXT | Attribution Ad Set ID | The unique identifier of the ad set. |
| attribution_campaign | TEXT | Attribution Campaign | The name of the campaign. |
| attribution_campaign_id | TEXT | Attribution Campaign ID | The unique identifier of the campaign. |
| attribution_channel | TEXT | Attribution Channel | The marketing channel of the attributed performance. |
| attribution_clicks | NUMERIC | Attribution Clicks | The number of clicks for the attributed ads. |
| attribution_cost_of_goods | NUMERIC | Attribution Cost Of Goods | Cost of goods for the attributed orders. |
| attribution_creative_format | TEXT | Attribution Creative Format | The format of the creative (e.g. video, image). |
| attribution_creative_id | TEXT | Attribution Creative ID | The unique identifier of the creative. |
| attribution_ctr | PERCENT | Attribution CTR | Click-through rate: clicks divided by impressions. |
| attribution_gross_sales | NUMERIC | Attribution Gross Sales | Gross sales attributed to the ads. |
| attribution_impressions | NUMERIC | Attribution Impressions | The number of impressions for the attributed ads. |
| attribution_model | TEXT | Attribution Model | The attribution model applied to the performance. |
| attribution_new_customer_orders | NUMERIC | Attribution New Customer Orders | Number of new customer orders attributed to the ads. |
| attribution_new_customer_revenue | NUMERIC | Attribution New Customer Revenue | New customer order revenue attributed to the ads. |
| attribution_orders | NUMERIC | Attribution Orders | Number of orders attributed to the ads. |
| attribution_revenue | NUMERIC | Attribution Revenue | Order revenue attributed to the ads. |
| attribution_roas | NUMERIC | Attribution ROAS | Attributed return on ad spend: revenue divided by spend. |
| attribution_sessions | NUMERIC | Attribution Sessions | Number of sessions attributed to the ads. |
| attribution_spend | NUMERIC | Attribution Spend | The amount spent on the attributed ads. |
Triple Whale Blended Stats fields
The Blended Stats report of the Triple Whale connector includes 28 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| blended_cost_of_goods | NUMERIC | Blended Cost Of Goods | Cost of goods sold. |
| blended_cpa | NUMERIC | Blended CPA | Blended cost per acquisition: ad spend divided by orders with revenue over zero. |
| blended_discounts | NUMERIC | Blended Discounts | Total discounts applied to orders. |
| blended_gross_product_sales | NUMERIC | Blended Gross Product Sales | Gross product sales before adjustments. |
| blended_handling_fees | NUMERIC | Blended Handling Fees | Handling fees applied to orders. |
| blended_mer | NUMERIC | Blended MER | Marketing efficiency ratio: ad spend divided by order revenue (Triple Whale's inverse-of-ROAS definition). |
| blended_ncpa | NUMERIC | Blended NCPA | New customer cost per acquisition: ad spend divided by new customer orders. |
| blended_net_margin | PERCENT | Blended Net Margin | Net profit as a share of order revenue. |
| blended_net_profit | NUMERIC | Blended Net Profit | Order revenue minus refunds, ad spend and total costs. |
| blended_new_customer_orders | NUMERIC | Blended New Customer Orders | Number of orders placed by new customers. |
| blended_new_customer_revenue | NUMERIC | Blended New Customer Revenue | Order revenue from new customers. |
| blended_new_customer_roas | NUMERIC | Blended New Customer ROAS | New customer revenue divided by ad spend. |
| blended_order_revenue | NUMERIC | Blended Order Revenue | Revenue from orders after discounts, shipping, fees and taxes. |
| blended_orders | NUMERIC | Blended Orders | Total number of orders. |
| blended_orders_over_zero | NUMERIC | Blended Orders Over Zero | Number of orders with revenue greater than zero. |
| blended_payment_gateway_costs | NUMERIC | Blended Payment Gateway Costs | Costs charged by payment gateways. |
| blended_poas | NUMERIC | Blended POAS | Profit on ad spend: total sales minus total costs, divided by ad spend. |
| blended_refunded_orders | NUMERIC | Blended Refunded Orders | Number of orders that were refunded. |
| blended_refunds | NUMERIC | Blended Refunds | Total amount refunded. |
| blended_roas | NUMERIC | Blended ROAS | Blended return on ad spend: order revenue divided by ad spend. |
| blended_sessions | NUMERIC | Blended Sessions | Number of website sessions. |
| blended_shipping_costs | NUMERIC | Blended Shipping Costs | Costs incurred for shipping orders. |
| blended_shipping_price | NUMERIC | Blended Shipping Price | Shipping amount charged to customers. |
| blended_spend | NUMERIC | Blended Ad Spend | Channel ad spend across all marketing platforms. |
| blended_taxes | NUMERIC | Blended Taxes | Taxes on orders. |
| blended_total_costs | NUMERIC | Blended Total Costs | Sum of cost of goods, shipping, payment gateway, handling fees and taxes. |
| blended_total_sales | NUMERIC | Blended Total Sales | Order revenue minus refunds. |
| date | DATE | Date | The date of the record. |
Triple Whale Customer Journey fields
The Customer Journey report of the Triple Whale connector includes 14 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| journey_attribution_model | TEXT | Journey Attribution Model | The attribution model applied to the touch. |
| journey_campaign_id | TEXT | Journey Campaign ID | The campaign associated with the touch. |
| journey_customer_id | TEXT | Journey Customer ID | The unique identifier of the customer. |
| journey_device | TEXT | Journey Device | The device used during the touch. |
| journey_event_name | TEXT | Journey Event Name | The name of the journey event. |
| journey_event_time | Journey Event Time | The timestamp of the journey event. | |
| journey_event_type | TEXT | Journey Event Type | The type of the journey event (e.g. checkout, page view). |
| journey_order_id | TEXT | Journey Order ID | The unique identifier of the order, when the touch is an order. |
| journey_order_name | TEXT | Journey Order Name | The display name of the order, when the touch is an order. |
| journey_order_revenue | NUMERIC | Journey Order Revenue | Order revenue associated with the touch, when an order. |
| journey_source | TEXT | Journey Source | The source of the journey touch. |
| journey_subscription_id | TEXT | Journey Subscription ID | The subscription associated with the touch, if any. |
| journey_total_price | NUMERIC | Journey Total Price | Total price associated with the touch, when an order. |
| journey_url | TEXT | Journey URL | The URL associated with the touch. |
Triple Whale Customers fields
The Customers report of the Triple Whale connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| customer_country | COUNTRY | Customer Country | The country of the customer. |
| customer_created_at | Customer Created At | The timestamp when the customer was created. | |
| customer_id | TEXT | Customer ID | The unique identifier of the customer. |
| customer_last_order_id | TEXT | Customer Last Order ID | The unique identifier of the customer's last order. |
| customer_platform | TEXT | Customer Platform | The platform the customer record originates from. |
| customer_status | TEXT | Customer Status | The marketing subscription status of the customer. |
| customer_total_orders | NUMERIC | Customer Total Orders | The lifetime number of orders placed by the customer. |
| customer_total_spent | NUMERIC | Customer Total Spent | The lifetime amount spent by the customer. |
Triple Whale Orders fields
The Orders report of the Triple Whale connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| order_cost_of_goods | NUMERIC | Order Cost Of Goods | Cost of goods sold for the order. |
| order_customer_email | TEXT | Order Customer Email | The email of the customer who placed the order. |
| order_customer_id | TEXT | Order Customer ID | The unique identifier of the customer who placed the order. |
| order_discount_amount | NUMERIC | Order Discount Amount | Total discount amount applied to the order. |
| order_discount_code | TEXT | Order Discount Code | The discount code applied to the order. |
| order_gross_product_sales | NUMERIC | Order Gross Product Sales | Gross product sales for the order before adjustments. |
| order_id | TEXT | Order ID | The unique identifier of the order. |
| order_is_new_customer | BOOLEAN | Order Is New Customer | Whether the order was placed by a new customer. |
| order_is_subscription | BOOLEAN | Order Is Subscription | Whether the order is a subscription order. |
| order_name | TEXT | Order Name | The display name of the order. |
| order_net_revenue | NUMERIC | Order Net Revenue | Net revenue for the order. |
| order_refunded_amount | NUMERIC | Order Refunded Amount | Amount refunded for the order. |
| order_revenue | NUMERIC | Order Revenue | Revenue for the order after adjustments. |
| order_shipping_price | NUMERIC | Order Shipping Price | Shipping amount charged for the order. |
| order_source_name | TEXT | Order Source Name | The attributed source of the order. |
| order_taxes | NUMERIC | Order Taxes | Taxes charged on the order. |
Triple Whale other fields
The Triple Whale connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | The Triple Whale shop domain (e.g. example.myshopify.com). | Account |
| account_name | TEXT | Account Name | The Triple Whale shop domain, used as the account name. | Account |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |