Appnexus

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
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_rateNUMERICVideo 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.
dateDATEDateThe Date
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.
placement_idTEXTPlacement IDPlacement ID
placement_nameTEXTPlacement NameThe name of the placement
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.
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.
view_impressionsNUMERICViewable impressionsThe number of measured impressions that were viewable
view_impressions_rateNUMERICViewability rateThe percentage of impressions that were viewable out of the total number of impressions.
view_measurement_rateNUMERICView measuremen rateThe percentage of impressions measured for viewability out of the total number of impressions.