YouGov BrandIndex Connector Reference

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