Connect Triple Whale to Data Studio
Bring your Triple Whale data into Data Studio with Windsor.ai, so your reports read live store and ad performance data.
Pick the Triple Whale fields you need, and Windsor.ai keeps them flowing without a CSV export in between.
Forget CSVs. Stop copy/paste. Connect in minutes. No code required.
Get your Triple Whale data into Data Studio
Triple Whale is connected once in Windsor.ai, and these are the use cases the fields support:
Track profit next to revenue
Blended Net Profit and Blended Net Margin by Week, next to Blended Cost Of Goods, Blended Shipping Costs and Blended Payment Gateway Costs, show where costs grow.
Compare ad channels
Ads Spend, Ads Conversion Value and Ads ROAS per Ads Channel and Ads Campaign show which channels and campaigns return the most for their spend.
Watch what new customers cost
Blended New Customer Orders, Blended NCPA and Blended New Customer ROAS by Month show how the cost of each new customer changes.
Using Windsor.ai to connect data from Triple Whale to Data Studio
Windsor.ai moves your Triple Whale fields into Data Studio on a connection you set up once, so the reports stay on live records rather than a CSV someone exported last week.
Pick the fields you need and Windsor.ai handles the rest.
How to connect Triple Whale to Data Studio with Windsor.ai
Explore a step-by-step guide to integrate your Triple Whale data into Data Studio with the Windsor.ai connector.
Select your data source
Choose Triple Whale as your data source and enter your shop domain (for example my-store.myshopify.com) and a Triple Whale API key. To create the key, go to Data > APIs in Triple Whale and click Generate. Then click Add Account.
Select the reporting fields
Choose the Triple Whale fields you want in Data Studio on the right side, and preview your data before export.
Select Data Studio as your data destination
Scroll down to the list of data destinations and click Data Studio. Install the Windsor.ai connector by authorizing your account, selecting the required Triple Whale account(s), and clicking Connect, then Create Report.
FAQs
What Triple Whale data can I load into Data Studio?
Windsor.ai gives access to 145 Triple Whale fields. These are the groups; the Triple Whale field reference lists all of them:
- Store totals: Blended Order Revenue, Blended Orders, Blended Ad Spend, Blended ROAS, Blended MER, Blended POAS, Blended Sessions.
- Profit and costs: Blended Net Profit, Blended Net Margin, Blended Cost Of Goods, Blended Shipping Costs, Blended Payment Gateway Costs, Blended Refunds, Blended Discounts.
- New customers: Blended New Customer Orders, Blended New Customer Revenue, Blended NCPA, Blended New Customer ROAS.
- Ads: Ads Channel, Ads Campaign, Ads Ad Set, Ads Ad, Ads Spend, Ads Impressions, Ads Clicks, Ads CTR, Ads CPC, Ads Conversions, Ads Conversion Value, Ads ROAS.
- Orders and customers: Order ID, Order Revenue, Order Net Revenue, Order Discount Code, Order Is New Customer, Customer Country, Customer Total Orders, Customer Total Spent.
- Customer journeys: Journey Event Name, Journey Source, Journey Device, Journey URL.
- Date and account: Date, Week, Month, Year, Account Name.
How does Windsor.ai load Triple Whale data into Data Studio?
Windsor.ai provides a Data Studio connector. You authorize it once, select your Triple Whale account and the fields you want, and build the report on live data.
Does the Triple Whale connector include customer details?
Yes. Orders carry the Order Customer Email and Order Customer ID, and customer records carry the Customer ID and Customer Country. Pick only the fields you need when you set up a report or ask a question.
Can I combine Triple Whale data with other sources in my reports?
Yes. Windsor.ai supports 350+ data sources, so Triple Whale data can sit next to other connected sources in the same reports. For example, put Triple Whale Blended Order Revenue and Blended Sessions by Week next to Google Search Console Clicks and Impressions for the same weeks, to see how organic search traffic moves with store revenue.
Do I need to code to connect Triple Whale to Data Studio?
No. You connect Triple Whale in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.
How much does it cost to integrate Triple Whale with Data Studio using Windsor.ai?
The free forever plan covers 1 data source, so connecting Triple Whale on its own costs nothing and needs no credit card. Combining Triple Whale with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with Triple Whale and Data Studio?
Yes. These are the resources to start with for the Triple Whale to Data Studio integration:
Tired of manual Triple Whale data exports? Try Windsor.ai today to work on live data

