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
ID | Type | Name | Description |
---|
advertiser | TEXT | Advertiser name | The unique identification number for each advertiser. |
advertiser_id | TEXT | Advertiser id | The unique identification number for each advertiser. |
campaign | TEXT | Campaign | The Campaign Name |
campaign_id | TEXT | Campaign ID | The Campaign ID |
clicks | NUMERIC | Clicks | The Number of Clicks |
completion_rate | NUMERIC | Video completion rate | The ratio of video completions to impressions, expressed as a percentage. |
conversion_rate | PERCENT | Conversion rate | The rate of conversions to impressions. |
cpa | NUMERIC | cpa | The cost per acquisition. |
cpc | NUMERIC | cpc | The cost per click. |
cpm | NUMERIC | cpm | The cost per 1,000 impressions. |
creative_id | TEXT | Creative ID | The unique identification number of the creative. |
creative_media_url | TEXT | Creative media URL | The URL of the creative - can be image, flash, HTML, javascript (see format). |
creative_name | TEXT | Creative name | The display name of the creative. |
ctr | PERCENT | Ctr | The rate of clicks to impressions. |
date | DATE | Date | The Date |
deal_name | TEXT | Deal name | The name of the deal. |
ecpa | NUMERIC | Ecpa | The effective advertiser spend per conversion/acquisition. |
ecpc | NUMERIC | Ecpc | The effective advertiser spend per click. |
ecpm | NUMERIC | Ecpm | The effective advertiser spend per 1000 impressions. |
gender | TEXT | Gender | The gender of the user. For impressions older than 100 days, the gender will be 'u'. |
impressions | NUMERIC | Impressions | The Number of Impressions Served |
insertion_order | TEXT | Insertion order | The name of the insertion order. |
insertion_order_id | TEXT | Insertion order ID | The unique identification number of the insertion order. |
insertion_order_name | TEXT | Insertion order name | The name of the insertion order. |
line_item | TEXT | Line item name | The name of the line item. |
line_item_end_date | DATE | Line item start | The date and time when the non-seamless line item should stop serving. This value reflects the Advertiser's time zone. |
line_item_id | TEXT | Line item ID | The unique identification number of the line item. |
line_item_start_date | DATE | Line item start | The date and time when the non-seamless line item should start serving. This value reflects the Advertiser's time zone. |
media_cost | NUMERIC | Media cost | The total amount spent to purchase all impressions. |
placement_id | TEXT | Placement ID | Placement ID |
placement_name | TEXT | Placement Name | The name of the placement |
spend | NUMERIC | Spend | The Media Spend |
spend_advertiser | NUMERIC | Spend for advertiser | The total amount spent by the advertiser in the advertiser's preferred currency. |
supply_type | TEXT | Type of app | The type of inventory. |
total_conversions | NUMERIC | Total conversions | The total number of post view and post click conversions. |
total_convs | NUMERIC | Total conversion | The total number of post view and post click conversions. |
totalcost | NUMERIC | Total Cost | The Media Spend (Duplicate) |
totalrevenue | NUMERIC | Total revenue | The total amount of post view and post click revenue. |
view_impressions | NUMERIC | Viewable impressions | The number of measured impressions that were viewable |
view_impressions_rate | NUMERIC | Viewability rate | The percentage of impressions that were viewable out of the total number of impressions. |
view_measurement_rate | NUMERIC | View measuremen rate | The percentage of impressions measured for viewability out of the total number of impressions. |