Triple Whale Connector Reference

64 metrics81 dimensions

Fields

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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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	TIMESTAMP	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

API Connectors