API Connectors

users-love-us medal soc2
Send your YouGov BrandIndex data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

YouGov BrandIndex Connector Reference

7 metrics50 dimensions
Fields

The YouGov BrandIndex connector exposes 57 fields (7 metrics, 50 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


YouGov BrandIndex Fields

The YouGov BrandIndex connector includes 57 fields.

YouGov BrandIndex fields (account_id to datasource)

ID Type Name Description
account_id TEXT Account ID Account ID.
account_name TEXT Account Name Account Name.
analysis__created_at TIMESTAMP Analysis Created At Date when the analysis was created.
analysis__has_market_scanner BOOLEAN Analysis Has Market Scanner Whether the analysis has market scanner.
analysis__is_listed BOOLEAN Analysis Is Listed Whether the analysis is listed.
analysis__is_public BOOLEAN Analysis Is Public Whether the analysis is public.
analysis__resource_meta__author__email TEXT Analysis Author Email Email of the analysis author.
analysis__resource_meta__author__first_name TEXT Analysis Author First Name First Name of the analysis author.
analysis__resource_meta__author__last_name TEXT Analysis Author Last Name Last Name of the analysis author.
analysis__resource_meta__author__uuid TEXT Analysis Author UUID UUID of the analysis author.
analysis__title TEXT Analysis Title Name of the analysis.
analysis__updated_at TIMESTAMP Analysis Updated At Date when the analysis was updated.
analysis__uuid TEXT Analysis UUID UUID of the analysis.
analysis_brand_id TEXT Analysis Brand ID Analysis Brand ID
analysis_custom_sector_uuid TEXT Analysis Custom Sector UUID Analysis Custom Sector UUID
analysis_metric TEXT Analysis Metric Name Name of the metric.
analysis_metric_negatives NUMERIC Analysis Metric Negatives Negatives value of the metric.
analysis_metric_negatives_neutrals NUMERIC Analysis Metric Negatives Neutrals Negatives and neutrals value of the metric.
analysis_metric_neutrals NUMERIC Analysis Metric Neutrals Neutrals value of the metric.
analysis_metric_positives NUMERIC Analysis Metric Positives Positives value of the metric.
analysis_metric_positives_neutrals NUMERIC Analysis Metric Positives Neutrals Positives and neutrals value of the metric.
analysis_metric_score NUMERIC Analysis Metric Score Score value of the metric.
analysis_metric_volume NUMERIC Analysis Metric Volume Volume of the metric.
analysis_query__confidence_bound TEXT Analysis Query Confidence Bound Analysis Query Confidence Bound
analysis_query__is_market_scanner BOOLEAN Analysis Query Is Market Scanner Analysis Query Is Market Scanner
analysis_query__moving_average TEXT Analysis Query Moving Average Analysis Query Moving Average
analysis_query__period__end_date__date DATE Analysis Query Period End Date Analysis Query Period End Date
analysis_query__period__start_date__date DATE Analysis Query Period Start Date Analysis Query Period Start Date
analysis_query__resample TEXT Analysis Query Resample Analysis Query Resample
analysis_query__scoring TEXT Analysis Query Scoring Analysis Query Scoring
analysis_query__title TEXT Analysis Query Title Analysis Query Title
analysis_query__uuid TEXT Analysis Query UUID Analysis Query UUID
analysis_query__visualization_attributes__color TEXT Analysis Query Visualization Attributes Color Analysis Query Visualization Attributes Color
analysis_query_filters TEXT Analysis Query Filters Audience filters applied to the analysis series, resolved to labels, e.g. age groups 'Age by Year Standardized: 18-24'.
analysis_query_id TEXT Analysis Query ID Analysis Query ID
analysis_query_index TEXT Analysis Query Index Analysis Query Index
analysis_region TEXT Analysis Region Analysis Region
analysis_sector_id TEXT Analysis Sector ID Analysis Sector ID
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

YouGov BrandIndex fields (date to year_week_iso)

ID Type Name Description
date DATE Date Date of the measurement.
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