Appnexus Field Reference

Sample

https://connectors.windsor.ai/appnexus?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv


Fields

IDTypeNameDescription
account_idTEXTAccount IDThe Account ID
advertiserTEXTAdvertiser nameThe unique identification number for each advertiser.
advertiser_idTEXTAdvertiser idThe unique identification number for each advertiser.
campaignTEXTCampaignThe Campaign Name
campaign_idTEXTCampaign IDThe Campaign ID
clicksNUMERICClicksThe Number of Clicks
completion_ratePERCENTVideo completion rateThe ratio of video completions to impressions, expressed as a percentage.
conversion_ratePERCENTConversion rateThe rate of conversions to impressions.
cpaNUMERICCPAThe cost per acquisition.
cpcNUMERICCPCThe cost per click.
cpmNUMERICcpmThe cost per 1,000 impressions.
creative_idTEXTCreative IDThe unique identification number of the creative.
creative_media_urlTEXTCreative media URLThe URL of the creative - can be image, flash, HTML, javascript (see format).
creative_nameTEXTCreative nameThe display name of the creative.
ctrPERCENTCTRThe rate of clicks to impressions.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
day_of_monthTEXTDay of monthDay of the month
deal_nameTEXTDeal nameThe name of the deal.
ecpaNUMERICEcpaThe effective advertiser spend per conversion/acquisition.
ecpcNUMERICEcpcThe effective advertiser spend per click.
ecpmNUMERICEcpmThe effective advertiser spend per 1000 impressions.
genderTEXTGenderThe gender of the user. For impressions older than 100 days, the gender will be 'u'.
impressionsNUMERICImpressionsThe Number of Impressions Served
insertion_orderTEXTInsertion orderThe name of the insertion order.
insertion_order_idTEXTInsertion order IDThe unique identification number of the insertion order.
insertion_order_nameTEXTInsertion order nameThe name of the insertion order.
line_itemTEXTLine item nameThe name of the line item.
line_item_end_dateDATELine item startThe date and time when the non-seamless line item should stop serving. This value reflects the Advertiser's time zone.
line_item_idTEXTLine item IDThe unique identification number of the line item.
line_item_start_dateDATELine item startThe date and time when the non-seamless line item should start serving. This value reflects the Advertiser's time zone.
media_costNUMERICMedia costThe total amount spent to purchase all impressions.
monthTEXTMonthNumber of the month
pixel_idNUMERICPixel IDThe ID of the conversion pixel.
pixel_nameTEXTPixel NameThe name of the conversion pixel.
placement_idTEXTPlacement IDPlacement ID
placement_nameTEXTPlacement NameThe name of the placement
post_click_or_post_view_convTEXTPost Click or Post View ConversionThe type of conversion. If 'Post Click', the conversion is attributed to a user clicking a creative.If 'Post View', the conversion is attributed to a user viewing a creative..
post_click_or_post_view_revenueNUMERICPost Click or Post View RevenueThe revenue optionally passed in the conversion pixel using the 'value' parameter.
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendThe Media Spend
spend_advertiserNUMERICSpend for advertiserThe total amount spent by the advertiser in the advertiser's preferred currency.
supply_typeTEXTType of appThe type of inventory.
todayDATETodayToday's date
total_conversionsNUMERICTotal conversionsThe total number of post view and post click conversions.
total_convsNUMERICTotal conversionThe total number of post view and post click conversions.
totalcostNUMERICTotal CostThe Media Spend (Duplicate)
totalrevenueNUMERICTotal revenueThe total amount of post view and post click revenue.
video_completionsNUMERICVideo CompletionsThe total number of times the video creatives played for the entire duration.
view_impressionsNUMERICViewable impressionsThe number of measured impressions that were viewable
view_impressions_ratePERCENTViewability rateThe percentage of impressions that were viewable out of the total number of impressions.
view_measured_impsNUMERICView measured impressionsThe total number of impressions that were measured for viewability.
view_measurement_ratePERCENTView measuremen rateThe percentage of impressions measured for viewability out of the total number of impressions.
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_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