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 | Campaign creationTS | Campaign creationTS | |
| campaign_end_ts | 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 | 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 | Campaign ruCalcModuleTS | Campaign ruCalcModuleTS | |
| campaign_ru_stat_enabled | BOOLEAN | Campaign ruStatEnabled | Campaign ruStatEnabled |
| campaign_starred | BOOLEAN | Campaign starred | Campaign starred |
| campaign_start_ts | 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 | 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 | 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 | 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 | Now | Current timestamp | |
| placement_comments | TEXT | Placement comments | Placement comments |
| placement_creation_ts | 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 | 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 |
Windsor vs Coupler.io
