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 |
| 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 | NUMERIC | 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_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. |
| impressions | NUMERIC | Impressions | The Number of Impressions Served |
| insertion_orded | TEXT | Insertion order | The name of the insertion order. |
| line_item | TEXT | Line item name | The name of the line item. |
| media_cost | NUMERIC | Media cost | The total amount spent to purchase all impressions. |
| 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_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. |
