Gemius Connector Reference

The Gemius connector exposes 105 fields (4 metrics, 101 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Gemius Fields

The Gemius connector includes 105 fields.

Gemius fields (account_id to creative_campaign_id)

ID	Type	Name	Description
account_id	TEXT	Account ID	The Gemius account ID
account_name	TEXT	Account Name	The Gemius account name
campaign_action_goal	TEXT	Campaign actionGoal	Campaign actionGoal
campaign_cached_statistics	TEXT	Campaign cachedStatistics	Campaign cachedStatistics
campaign_click_goal	TEXT	Campaign clickGoal	Campaign clickGoal
campaign_client_id	TEXT	Campaign clientID	Campaign clientID
campaign_client_login	TEXT	Campaign clientLogin	Campaign clientLogin
campaign_client_name	TEXT	Campaign clientName	Campaign clientName
campaign_comments	TEXT	Campaign comments	Campaign comments
campaign_country_id	TEXT	Campaign countryID	Campaign countryID
campaign_creation_ts	TIMESTAMP	Campaign creationTS	Campaign creationTS
campaign_end_ts	TIMESTAMP	Campaign endTS	Campaign endTS
campaign_has_demography	BOOLEAN	Campaign hasDemography	Campaign hasDemography
campaign_id	TEXT	Campaign ID	Campaign ID
campaign_impression_goal	TEXT	Campaign impressionGoal	Campaign impressionGoal
campaign_is_blocked	BOOLEAN	Campaign isBlocked	Campaign isBlocked
campaign_is_created_by_me	BOOLEAN	Campaign isCreatedByMe	Campaign isCreatedByMe
campaign_is_gde_plus	BOOLEAN	Campaign isGdePlus	Campaign isGdePlus
campaign_is_read_only	BOOLEAN	Campaign isReadOnly	Campaign isReadOnly
campaign_label_1	TEXT	Campaign label1	Campaign label1
campaign_label_2	TEXT	Campaign label2	Campaign label2
campaign_modification_ts	TIMESTAMP	Campaign modificationTS	Campaign modificationTS
campaign_name	TEXT	Campaign name	Campaign name
campaign_ru_calc_module	TEXT	Campaign ruCalcModule	Campaign ruCalcModule
campaign_ru_calc_module_ts	TIMESTAMP	Campaign ruCalcModuleTS	Campaign ruCalcModuleTS
campaign_ru_stat_enabled	BOOLEAN	Campaign ruStatEnabled	Campaign ruStatEnabled
campaign_starred	BOOLEAN	Campaign starred	Campaign starred
campaign_start_ts	TIMESTAMP	Campaign startTS	Campaign startTS
campaign_status	TEXT	Campaign status	Campaign status
campaign_tag_1_id	TEXT	Campaign tag1ID	Campaign tag1ID
campaign_tag_1_name	TEXT	Campaign tag1Name	Campaign tag1Name
campaign_tag_2_id	TEXT	Campaign tag2ID	Campaign tag2ID
campaign_tag_2_name	TEXT	Campaign tag2Name	Campaign tag2Name
campaign_time_zone_id	TEXT	Campaign timeZoneID	Campaign timeZoneID
campaign_time_zone_name	TEXT	Campaign timeZoneName	Campaign timeZoneName
campaign_tracking_source	TEXT	Campaign trackingSource	Campaign trackingSource
campaign_user_login	TEXT	Campaign userLogin	Campaign userLogin
clicks	NUMERIC	Clicks	The number of clicks
creative_advertiser_name	TEXT	Creative advertiser Name	Creative advertiserName
creative_campaign_id	TEXT	Creative campaign ID	Creative campaignID

Gemius fields (creative_campaign_name to placement_is_folder)

ID	Type	Name	Description
creative_campaign_name	TEXT	Creative campaign Name	Creative campaignName
creative_comments	TEXT	Creative comments	Creative comments
creative_creation_ts	TIMESTAMP	Creative creation TS	Creative creationTS
creative_dsa_compliance	TEXT	Creative dsa Compliance	Creative dsaCompliance
creative_form_id	TEXT	Creative form ID	Creative formID
creative_form_name	TEXT	Creative form Name	Creative formName
creative_has_emitter_code	TEXT	Creative has Emitter Code	Creative hasEmitterCode
creative_id	TEXT	Creative ID	Creative ID
creative_is_blocked	BOOLEAN	Creative is Blocked	Creative isBlocked
creative_is_gde_plus	BOOLEAN	Creative is Gde Plus	Creative isGdePlus
creative_is_retargeted	BOOLEAN	Creative is Retargeted	Creative isRetargeted
creative_label_1	TEXT	Creative label 1	Creative label1
creative_label_2	TEXT	Creative label 2	Creative label2
creative_modification_ts	TIMESTAMP	Creative modification TS	Creative modificationTS
creative_name	TEXT	Creative name	Creative name
creative_sponsor_name	TEXT	Creative sponsor Name	Creative sponsorName
creative_tag_1_id	TEXT	Creative tag 1 ID	Creative tag1ID
creative_tag_1_name	TEXT	Creative tag 1 Name	Creative tag1Name
creative_tag_2_id	TEXT	Creative tag 2 ID	Creative tag2ID
creative_tag_2_name	TEXT	Creative tag 2 Name	Creative tag2Name
creative_template_id	TEXT	Creative template ID	Creative templateID
creative_template_name	TEXT	Creative template Name	Creative templateName
creative_type_id	TEXT	Creative type ID	Creative typeID
creative_type_name	TEXT	Creative type Name	Creative typeName
creative_unresolved_macros	TEXT	Creative unresolved Macros	Creative unresolvedMacros
creative_version	TEXT	Creative version	Creative version
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
date	DATE	Date	The date of the statistics record
day_of_month	TEXT	Day of month	Day of the month
dimension_placement_tag1	TEXT	Placement Tag 1	Placement Tag 1
impressions	NUMERIC	Impressions	The number of impressions
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
placement_comments	TEXT	Placement comments	Placement comments
placement_creation_ts	TIMESTAMP	Placement creation TS	Placement creationTS
placement_domains	TEXT	Placement domains	Placement domains
placement_environment	TEXT	Placement environment	Placement environment
placement_id	TEXT	Placement ID	Placement ID
placement_is_folder	BOOLEAN	Placement isFolder	Placement isFolder

Gemius fields (placement_is_gde_plus to year_week_iso)

ID	Type	Name	Description
placement_is_gde_plus	NUMERIC	Placement is Gde Plus	Placement isGdePlus
placement_label_1	TEXT	Placement label 1	Placement label1
placement_label_2	TEXT	Placement label 2	Placement label2
placement_modification_ts	TIMESTAMP	Placement modification TS	Placement modificationTS
placement_name	TEXT	Placement name	Placement name
placement_orders_count	NUMERIC	Placement orders Count	Placement ordersCount
placement_parent_id	TEXT	Placement parent ID	Placement parentID
placement_placement_full_path	TEXT	Placement Full Path	Placement Full Path
placement_placement_path	TEXT	Placement Path	Placement Path
placement_protocol	TEXT	Placement protocol	Placement protocol
placement_tag_1_id	TEXT	Placement tag 1 ID	Placement tag1 ID
placement_tag_2_id	TEXT	Placement tag 2 ID	Placement tag2ID
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