Vistar Media Connector Reference

4 metrics39 dimensions

The Vistar Media connector exposes 43 fields (4 metrics, 39 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Vistar Media Fields

Vistar Media Report fields

The Report report of the Vistar Media connector includes 23 fields.

IDTypeNameDescription
advertiserTEXTAdvertiserThe advertiser name.
campaign_idTEXTCampaign IDThe campaign identifier.
campaign_nameTEXTCampaign NameThe campaign name.
countryCOUNTRYCountry / TerritoryThe country or territory of the screens.
creative_idTEXTCreative IDThe creative identifier.
creative_nameTEXTCreative NameThe creative name.
dateDATEDateThe day of the report metrics.
fixed_ecpmNUMERICFixed eCPMThe effective cost per mille, shown as CPM in the Vistar report.
impressionsNUMERICImpressionsThe number of estimated impressions.
insertion_order_idTEXTInsertion Order IDThe insertion order identifier.
insertion_order_nameTEXTInsertion Order NameThe insertion order name.
latitudeTEXTLatitudeThe latitude of the venue.
longitudeTEXTLongitudeThe longitude of the venue.
media_ownerTEXTMedia OwnerThe media owner that operates the screens.
metro_areaTEXTMetro AreaThe metropolitan area of the screens.
network_idTEXTNetwork IDThe network identifier for the venue.
provinceTEXTProvinceThe province or state of the screens.
quarterTEXTQuarterQuarter as the date of its first day, formatted as yyyy-MM-dd.
revenueNUMERICRevenue (Investment)The spend, shown as Investment in the Vistar report.
spotsNUMERICSpotsThe number of spots played.
targeting_idTEXTTargeting IDThe targeting identifier for the venue.
venue_nameTEXTVenue NameThe venue name.
venue_typeTEXTVenue TypeThe venue type of the screens.

Vistar Media other fields

The Vistar Media connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe Vistar Media account identifier.Account
account_nameTEXTAccount NameThe Vistar Media account name.Account
data_fetched_atTIMESTAMPData fetched atUTC 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.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
day_of_monthTEXTDay of monthDay of the month
monthTEXTMonthNumber of the month
nowTIMESTAMPNowCurrent timestamp
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_month_nameTEXTYear month nameYear and month with the month name written out, e.g. "Jan 2025".
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20