Connect SWEET.TV to Data Studio
Bring your SWEET.TV data into Data Studio with Windsor.ai, so your reports read live video ad campaign data.
Pick the SWEET.TV 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 SWEET.TV data into Data Studio
SWEET.TV is connected once in Windsor.ai, and these are the use cases the fields support:
See spend and CPM by campaign
Spend, Impressions and CPM come per Campaign and Product, so the cost of every campaign sits in one table.
Compare devices
Device splits delivery into Mobile, WEB and CTV, so you can compare Impressions and Video Completion Rate on each screen type.
Compare FAST and AVOD
Direction separates free ad-supported TV channels from on-demand video, and Channel shows which FAST channels carried your ads.
Using Windsor.ai to connect data from SWEET.TV to Data Studio
Windsor.ai moves your SWEET.TV 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 SWEET.TV to Data Studio with Windsor.ai
Explore a step-by-step guide to integrate your SWEET.TV data into Data Studio with the Windsor.ai connector.
Select your data source
Choose SWEET.TV (listed as Sweet.tv FastAdPro) as your data source and enter your FastAdPro Analytics API token.
Select the reporting fields
Choose the SWEET.TV 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 SWEET.TV account(s), and clicking Connect, then Create Report.
FAQs
What SWEET.TV data can I load into Data Studio?
Windsor.ai gives access to 23 SWEET.TV fields. These are the groups; the SWEET.TV field reference lists all of them:
- Cost: Spend (in the contract currency) and CPM.
- Delivery: Impressions, Unique users, Frequency, Video Completion Rate, Ad Blocks, Ad Seconds.
- Campaign structure: Product, Campaign, Creative and their IDs, and Creative Duration.
- Where ads ran: Direction (FAST or AVOD), Channel and Channel ID for FAST, Device (Mobile, WEB or CTV).
- Time and account: Date, Account ID, Account Name.
How does Windsor.ai load SWEET.TV data into Data Studio?
Windsor.ai provides a Data Studio connector. You authorize it once, select your SWEET.TV account and the fields you want, and build the report on live data.
Can I combine SWEET.TV data with other sources in my reports?
Yes. Windsor.ai supports 350+ data sources, so SWEET.TV data can sit next to other connected sources in the same reports. For example, put SWEET.TV Spend and Impressions by week next to Meta Ads and Google Ads spend for the same weeks, so streaming TV, social and search spend sit in one table.
Do I need to code to connect SWEET.TV to Data Studio?
No. You connect SWEET.TV in the Windsor.ai dashboard, pick the fields you want, and Windsor.ai handles the transfer.
How much does it cost to integrate SWEET.TV with Data Studio using Windsor.ai?
The free forever plan covers 1 data source, so connecting SWEET.TV on its own costs nothing and needs no credit card. Combining SWEET.TV 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 SWEET.TV and Data Studio?
Yes. These are the resources to start with for the SWEET.TV to Data Studio integration:
Tired of manual SWEET.TV data exports? Try Windsor.ai today to work on live data

