Windsor brings all your Everflow data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Everflow Field Reference
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| account_executive | TEXT | Account Executive Name | Name of the account executive. |
| account_executive_id | TEXT | Account Executive ID | ID of the account executive. |
| account_id | TEXT | Account ID | ID of the Everflow network. |
| account_manager | TEXT | Account Manager Name | Name of the account manager. |
| account_manager_id | TEXT | Account Manager ID | ID of the account manager. |
| account_name | TEXT | Account Name | Name of the Everflow network. |
| adv1 | TEXT | Adv1 | Adv1. |
| adv2 | TEXT | Adv2 | Adv2. |
| adv3 | TEXT | Adv3 | Adv3. |
| adv4 | TEXT | Adv4 | Adv4. |
| adv5 | TEXT | Adv5 | Adv5. |
| advertiser | TEXT | Advertiser Name | Name of the advertiser. |
| advertiser_event | TEXT | Advertiser Event Name | Name of the advertiser global event. |
| advertiser_event_id | TEXT | Advertiser Event ID | ID of the advertiser global event. |
| advertiser_id | TEXT | Advertiser ID | ID of the advertiser. |
| affiliate | TEXT | Affiliate Name | Name of the affiliate. |
| affiliate_id | TEXT | Affiliate ID | ID of the affiliate. |
| affiliate_manager | TEXT | Affiliate Manager Name | Name of the affiliate manager. |
| affiliate_manager_id | TEXT | Affiliate Manager ID | ID of the affiliate manager. |
| affiliate_status | TEXT | Affiliate Status | Status of the affiliate. |
| affiliate_status_id | TEXT | Affiliate Status ID | ID of the affiliate status. |
| app_identifier | TEXT | App Identifier | Identifier of the app. |
| avg_sale_value | NUMERIC | Average Sale Value | Average sale value. |
| browser | TEXT | Browser | Name of the browser. |
| bundle | TEXT | Bundle Name | Name of the bundle. |
| bundle_id | TEXT | Bundle ID | ID of the bundle. |
| campaign | TEXT | Campaign Name | Name of the campaign. |
| campaign_id | TEXT | Campaign ID | ID of the campaign. |
| carrier | TEXT | Carrier | Name of the carrier. |
| category | TEXT | Category Name | Name of the category. |
| category_id | TEXT | Category ID | ID of the category. |
| city | CITY | City | Name of the city. |
| clicks | NUMERIC | Clicks | Number of clicks. |
| connection_type | TEXT | Connection Type | Type of the connection. |
| connection_type_id | TEXT | Connection Type ID | ID of the connection type. |
| conversions | NUMERIC | Conversions | Number of base conversions. |
| country | COUNTRY | Country | Country. |
| country_code | COUNTRY | Country Code | Code of the country. |
| coupon_code | TEXT | Coupon Code | Code of the coupon. |
| cpa | NUMERIC | CPA | Cost per action. |
| cpc | NUMERIC | CPC | Cost per click. |
| cpm | NUMERIC | CPM | Cost per mille. |
| creative | TEXT | Creative Name | Name of the creative. |
| creative_id | TEXT | Creative ID | ID of the creative. |
| ctr | PERCENT | CTR | Click-through rate. |
| currency | TEXT | Currency Name | Name of the currency. |
| currency_id | TEXT | Currency ID | ID of the currency. |
| cvr | NUMERIC | CVR | Conversion rate. |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | Date. |
| day_of_month | TEXT | Day of month | Day of the month |
| device_brand | TEXT | Device Brand | Brand of the device. |
| device_model | TEXT | Device Model | Model of the device. |
| device_type | TEXT | Device Type | Type of the device. |
| dma | TEXT | DMA | Code of the Designated Market Area. |
| duplicate_clicks | NUMERIC | Duplicate Clicks | Number of duplicate clicks. |
| epc | NUMERIC | EPC | Earnings per click. |
| event | TEXT | Event Name | Name of the event. |
| event_id | TEXT | Event ID | ID of the event. |
| event_revenue | NUMERIC | Event Revenue | Amount of the event revenue. |
| events | NUMERIC | Events | Number of events. |
| evr | PERCENT | EVR | Event rate. |
| gross_clicks | NUMERIC | Gross Clicks | Number of all clicks. |
| gross_sales | NUMERIC | Gross Sales | Amount of the gross sales. |
| impressions | NUMERIC | Impressions | Number of impressions. |
| invalid_clicks | NUMERIC | Invalid Clicks | Number of invalid clicks. |
| invalid_conversions_scrub | NUMERIC | Invalid Conversions Scrub | Number of invalid conversions scrub. |
| isp | TEXT | ISP | Name of the Internet Service Provider. |
| language | TEXT | Language | Name of the language. |
| margin | NUMERIC | Margin | Margin. |
| media_buying_cost | NUMERIC | Media Buying Cost | Cost of the media buying. |
| month | TEXT | Month | Number of the month |
| offer_group | TEXT | Offer Group Name | Name of the offer group. |
| offer_group_id | TEXT | Offer Group ID | ID of the offer group. |
| offer_id | TEXT | Offer ID | ID of the offer. |
| offer_name | TEXT | Offer Name | Name of the offer. |
| offer_status | TEXT | Offer Status | Status of the offer. |
| offer_url | TEXT | Offer URL | URL of the offer. |
| offer_url_id | TEXT | Offer URL ID | ID of the offer URL. |
| os_version | TEXT | OS Version | Version of the OS. |
| payout | NUMERIC | Payout | Amount of the payout. |
| payout_amount | TEXT | Payout Amount | Amount of the payout. |
| payout_type | TEXT | Payout Type | Type of the payout. |
| platform | TEXT | Platform | Name of the platform. |
| profit | NUMERIC | Profit | Amount of the profit. |
| project | TEXT | Project Name | Name of the project. |
| project_id | TEXT | Project ID | ID of the project. |
| referer | TEXT | Referer | Name of the referer. |
| region | REGION | Region | Name of the region. |
| revenue | NUMERIC | Revenue | Amount of the revenue. |
| revenue_amount | TEXT | Revenue Amount | Amount of the revenue. |
| revenue_type | TEXT | Revenue Type | Type of the revenue. |
| roas | PERCENT | ROAS | Return on ad spend. |
| rpa | NUMERIC | RPA | Revenue per action. |
| rpc | NUMERIC | RPC | Revenue per click. |
| rpm | NUMERIC | RPM | Revenue per mille. |
| sales_manager | TEXT | Sales Manager Name | Name of the sales manager. |
| sales_manager_id | TEXT | Sales Manager ID | ID of the sales manager. |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| source_name | TEXT | Source Name | Name of the source. |
| sub1 | TEXT | Sub1 | Sub1. |
| sub2 | TEXT | Sub2 | Sub2. |
| sub3 | TEXT | Sub3 | Sub3. |
| sub4 | TEXT | Sub4 | Sub4. |
| sub5 | TEXT | Sub5 | Sub5. |
| today | DATE | Today | Today's date |
| total_conversions | NUMERIC | Total Conversions | Number of all conversions. |
| tracking_domain | TEXT | Tracking Domain | Name of the tracking domain. |
| tracking_domain_id | TEXT | Tracking Domain ID | ID of the tracking domain. |
| unique_clicks | NUMERIC | Unique Clicks | Number of unique clicks. |
| view_through_conversions | NUMERIC | View Through Conversions | Number of view through conversions. |
| week | TEXT | Week | Week (Sun-Sat). |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
| year | TEXT | Year | Year |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |