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. |