API Connectors

users-love-us medal soc2
Send your Sweet.tv FastAdPro data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Sweet.tv FastAdPro Connector Reference

8 metrics33 dimensions
Fields

The Sweet.tv FastAdPro connector exposes 41 fields (8 metrics, 33 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Sweet.tv FastAdPro Fields

Sweet.tv FastAdPro Sales fields

The Sales report of the Sweet.tv FastAdPro connector includes 21 fields.

ID Type Name Description
ad_blocks NUMERIC Ad Blocks The number of ad blocks.
ad_seconds NUMERIC Ad Seconds The total advertising time in seconds.
campaign TEXT Campaign The name of the campaign.
campaign_id TEXT Campaign ID The ID of the campaign.
channel TEXT Channel The name of the channel (FAST only).
channel_id TEXT Channel ID The ID of the channel (FAST only).
cpm NUMERIC CPM The cost per 1000 impressions.
creative TEXT Creative The name of the creative.
creative_duration TEXT Creative Duration The duration of the creative in seconds.
creative_id TEXT Creative ID The ID of the creative.
date DATE Date The date of the sales metrics.
device TEXT Device The device type: Mobile, WEB or CTV.
device_id TEXT Device ID The ID of the device type.
direction TEXT Direction The impression direction: FAST (free ad-supported streaming TV) or AVOD (advertising video on demand).
frequency NUMERIC Frequency The number of impressions per unique user, counted like Unique users.
impressions NUMERIC Impressions The number of impressions.
product TEXT Product The name of the product.
product_id TEXT Product ID The ID of the product.
spend NUMERIC Spend The expense amount in the contract currency.
unique_users NUMERIC Unique users The number of unique users per day, or for the whole date range when date is not requested.
video_completion_rate NUMERIC Video Completion Rate The share of ad views that played to the end.

Sweet.tv FastAdPro other fields

The Sweet.tv FastAdPro 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 Account ID in Windsor.ai. Accounts
account_name TEXT Account Name Account name in Windsor.ai. Accounts
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