MediaGo Connector Reference

56 metrics58 dimensions

The MediaGo connector exposes 114 fields (56 metrics, 58 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


MediaGo Fields

MediaGo AdDailyReport fields

The AdDailyReport report of the MediaGo connector includes 24 fields.

ID Type Name Description
addailyreport__ad_id TEXT AdDailyReport.ad_id AdDailyReport.ad_id
addailyreport__ad_name TEXT AdDailyReport.ad_name AdDailyReport.ad_name
addailyreport__brand_name TEXT AdDailyReport.brand_name AdDailyReport.brand_name
addailyreport__campaign_id TEXT AdDailyReport.campaign_id AdDailyReport.campaign_id
addailyreport__campaign_name TEXT AdDailyReport.campaign_name AdDailyReport.campaign_name
addailyreport__click NUMERIC AdDailyReport.click AdDailyReport.click
addailyreport__conversion NUMERIC AdDailyReport.conversion AdDailyReport.conversion
addailyreport__cpc NUMERIC AdDailyReport.cpc AdDailyReport.cpc
addailyreport__cv_add_paymentinfo NUMERIC AdDailyReport.cv_add_paymentInfo AdDailyReport.cv_add_paymentInfo
addailyreport__cv_add_to_cart NUMERIC AdDailyReport.cv_add_to_cart AdDailyReport.cv_add_to_cart
addailyreport__cv_add_to_wishlist NUMERIC AdDailyReport.cv_add_to_wishlist AdDailyReport.cv_add_to_wishlist
addailyreport__cv_app_install NUMERIC AdDailyReport.cv_app_install AdDailyReport.cv_app_install
addailyreport__cv_complete_registration NUMERIC AdDailyReport.cv_complete_registration AdDailyReport.cv_complete_registration
addailyreport__cv_lead NUMERIC AdDailyReport.cv_lead AdDailyReport.cv_lead
addailyreport__cv_other NUMERIC AdDailyReport.cv_other AdDailyReport.cv_other
addailyreport__cv_purchase NUMERIC AdDailyReport.cv_purchase AdDailyReport.cv_purchase
NUMERIC AdDailyReport.cv_search AdDailyReport.cv_search
addailyreport__cv_start_checkout NUMERIC AdDailyReport.cv_start_checkout AdDailyReport.cv_start_checkout
addailyreport__cv_view_content NUMERIC AdDailyReport.cv_view_content AdDailyReport.cv_view_content
addailyreport__img_url TEXT AdDailyReport.img_url AdDailyReport.img_url
addailyreport__impression NUMERIC AdDailyReport.impression AdDailyReport.impression
addailyreport__spend NUMERIC AdDailyReport.spend AdDailyReport.spend
addailyreport__status NUMERIC AdDailyReport.status AdDailyReport.status
addailyreport__title TEXT AdDailyReport.title AdDailyReport.title

MediaGo CampaignDailyReport fields

The CampaignDailyReport report of the MediaGo connector includes 19 fields.

ID Type Name Description
campaigndailyreport__click NUMERIC CampaignDailyReport.click CampaignDailyReport.click
campaigndailyreport__conversion NUMERIC CampaignDailyReport.conversion CampaignDailyReport.conversion
campaigndailyreport__cpc NUMERIC CampaignDailyReport.cpc CampaignDailyReport.cpc
campaigndailyreport__cv_add_paymentinfo NUMERIC CampaignDailyReport.cv_add_paymentInfo CampaignDailyReport.cv_add_paymentInfo
campaigndailyreport__cv_add_to_cart NUMERIC CampaignDailyReport.cv_add_to_cart CampaignDailyReport.cv_add_to_cart
campaigndailyreport__cv_add_to_wishlist NUMERIC CampaignDailyReport.cv_add_to_wishlist CampaignDailyReport.cv_add_to_wishlist
campaigndailyreport__cv_app_install NUMERIC CampaignDailyReport.cv_app_install CampaignDailyReport.cv_app_install
campaigndailyreport__cv_complete_registration NUMERIC CampaignDailyReport.cv_complete_registration CampaignDailyReport.cv_complete_registration
campaigndailyreport__cv_lead NUMERIC CampaignDailyReport.cv_lead CampaignDailyReport.cv_lead
campaigndailyreport__cv_other NUMERIC CampaignDailyReport.cv_other CampaignDailyReport.cv_other
campaigndailyreport__cv_purchase NUMERIC CampaignDailyReport.cv_purchase CampaignDailyReport.cv_purchase
NUMERIC CampaignDailyReport.cv_search CampaignDailyReport.cv_search
campaigndailyreport__cv_start_checkout NUMERIC CampaignDailyReport.cv_start_checkout CampaignDailyReport.cv_start_checkout
campaigndailyreport__cv_view_content NUMERIC CampaignDailyReport.cv_view_content CampaignDailyReport.cv_view_content
campaigndailyreport__id TEXT CampaignDailyReport.id CampaignDailyReport.id
campaigndailyreport__impression NUMERIC CampaignDailyReport.impression CampaignDailyReport.impression
campaigndailyreport__name TEXT CampaignDailyReport.name CampaignDailyReport.name
campaigndailyreport__spend NUMERIC CampaignDailyReport.spend CampaignDailyReport.spend
campaigndailyreport__status NUMERIC CampaignDailyReport.status CampaignDailyReport.status

MediaGo GetCampaignDetail fields

The GetCampaignDetail report of the MediaGo connector includes 30 fields.

ID Type Name Description
getcampaigndetail__audience OBJECT GetCampaignDetail.audience GetCampaignDetail.audience
getcampaigndetail__brand_name TEXT GetCampaignDetail.brand_name GetCampaignDetail.brand_name
getcampaigndetail__browser OBJECT GetCampaignDetail.browser GetCampaignDetail.browser
getcampaigndetail__campaign_id TEXT GetCampaignDetail.campaign_id GetCampaignDetail.campaign_id
getcampaigndetail__campaign_name TEXT GetCampaignDetail.campaign_name GetCampaignDetail.campaign_name
getcampaigndetail__charge_type TEXT GetCampaignDetail.charge_type GetCampaignDetail.charge_type
getcampaigndetail__cpc NUMERIC GetCampaignDetail.cpc GetCampaignDetail.cpc
getcampaigndetail__daily_cap NUMERIC GetCampaignDetail.daily_cap GetCampaignDetail.daily_cap
getcampaigndetail__day_parting OBJECT GetCampaignDetail.day_parting GetCampaignDetail.day_parting
getcampaigndetail__dp_timezone TEXT GetCampaignDetail.dp_timezone GetCampaignDetail.dp_timezone
getcampaigndetail__end_time TEXT GetCampaignDetail.end_time GetCampaignDetail.end_time
getcampaigndetail__gross_cpc TEXT GetCampaignDetail.gross_cpc GetCampaignDetail.gross_cpc
getcampaigndetail__ip_targeting TEXT GetCampaignDetail.ip_targeting GetCampaignDetail.ip_targeting
getcampaigndetail__landing_page TEXT GetCampaignDetail.landing_page GetCampaignDetail.landing_page
getcampaigndetail__language TEXT GetCampaignDetail.language GetCampaignDetail.language
getcampaigndetail__location OBJECT GetCampaignDetail.location GetCampaignDetail.location
getcampaigndetail__objective TEXT GetCampaignDetail.objective GetCampaignDetail.objective
getcampaigndetail__optimization_type TEXT GetCampaignDetail.optimization_type GetCampaignDetail.optimization_type
getcampaigndetail__os OBJECT GetCampaignDetail.os GetCampaignDetail.os
getcampaigndetail__platform OBJECT GetCampaignDetail.platform GetCampaignDetail.platform
getcampaigndetail__product_type TEXT GetCampaignDetail.product_type GetCampaignDetail.product_type
getcampaigndetail__site_bid_modiefier OBJECT GetCampaignDetail.site_bid_modiefier GetCampaignDetail.site_bid_modiefier
getcampaigndetail__spend_limit NUMERIC GetCampaignDetail.spend_limit GetCampaignDetail.spend_limit
getcampaigndetail__spend_mode NUMERIC GetCampaignDetail.spend_mode GetCampaignDetail.spend_mode
getcampaigndetail__spend_renew TEXT GetCampaignDetail.spend_renew GetCampaignDetail.spend_renew
getcampaigndetail__start_time TEXT GetCampaignDetail.start_time GetCampaignDetail.start_time
getcampaigndetail__status NUMERIC GetCampaignDetail.status GetCampaignDetail.status
getcampaigndetail__target_cpa NUMERIC GetCampaignDetail.target_cpa GetCampaignDetail.target_cpa
getcampaigndetail__utm_tracking TEXT GetCampaignDetail.utm_tracking GetCampaignDetail.utm_tracking
getcampaigndetail__zipcode_country TEXT GetCampaignDetail.zipcode_country GetCampaignDetail.zipcode_country

MediaGo SiteDailyReport fields

The SiteDailyReport report of the MediaGo connector includes 20 fields.

ID Type Name Description
sitedailyreport__campaign_id TEXT SiteDailyReport.campaign_id SiteDailyReport.campaign_id
sitedailyreport__campaign_name TEXT SiteDailyReport.campaign_name SiteDailyReport.campaign_name
sitedailyreport__click NUMERIC SiteDailyReport.click SiteDailyReport.click
sitedailyreport__conversion NUMERIC SiteDailyReport.conversion SiteDailyReport.conversion
sitedailyreport__cv_add_payment_info NUMERIC SiteDailyReport.cv_add_payment_info SiteDailyReport.cv_add_payment_info
sitedailyreport__cv_add_to_cart NUMERIC SiteDailyReport.cv_add_to_cart SiteDailyReport.cv_add_to_cart
sitedailyreport__cv_add_to_wishlist NUMERIC SiteDailyReport.cv_add_to_wishlist SiteDailyReport.cv_add_to_wishlist
sitedailyreport__cv_app_install NUMERIC SiteDailyReport.cv_app_install SiteDailyReport.cv_app_install
sitedailyreport__cv_complete_registration NUMERIC SiteDailyReport.cv_complete_registration SiteDailyReport.cv_complete_registration
sitedailyreport__cv_lead NUMERIC SiteDailyReport.cv_lead SiteDailyReport.cv_lead
sitedailyreport__cv_other NUMERIC SiteDailyReport.cv_other SiteDailyReport.cv_other
sitedailyreport__cv_purchase NUMERIC SiteDailyReport.cv_purchase SiteDailyReport.cv_purchase
NUMERIC SiteDailyReport.cv_search SiteDailyReport.cv_search
sitedailyreport__cv_start_checkout NUMERIC SiteDailyReport.cv_start_checkout SiteDailyReport.cv_start_checkout
sitedailyreport__cv_view_content NUMERIC SiteDailyReport.cv_view_content SiteDailyReport.cv_view_content
sitedailyreport__impression NUMERIC SiteDailyReport.impression SiteDailyReport.impression
sitedailyreport__site_cpc NUMERIC SiteDailyReport.site_cpc SiteDailyReport.site_cpc
sitedailyreport__site_id TEXT SiteDailyReport.site_id SiteDailyReport.site_id
sitedailyreport__site_name TEXT SiteDailyReport.site_name SiteDailyReport.site_name
sitedailyreport__spend NUMERIC SiteDailyReport.spend SiteDailyReport.spend

MediaGo other fields

The MediaGo connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID connector
account_name TEXT Account name Account name connector
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
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