Gemius Connector Reference

4 metrics101 dimensions

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