account_id | TEXT | Account ID | Account ID. |
account_name | TEXT | Account Name | Account Name. |
advertiser_reference | TEXT | Advertiser Reference | The reference of the advertiser. |
campaign | TEXT | Campaign | The name of the campaign. |
campaign_id | TEXT | Campaign ID | The unique identifier of the campaign. |
campaign_title | TEXT | Campaign Title | The name of the campaign. |
click_cookie_id | TEXT | Click Cookie ID | The unique identifier of the cookie. |
click_id | TEXT | Click ID | The unique identifier of the click. |
click_last_ip | TEXT | Click Last IP | The last IP of the click. |
click_last_used | TIMESTAMP | Click Last Used | The last used date of the click. |
click_referer | TEXT | Click Referer | The referer of the click. |
click_set_ip | TEXT | Click Set IP | The set IP of the click. |
click_set_time | TIMESTAMP | Click Set Time | The set time of the click. |
click_status | TEXT | Click Status | The status of the click. |
click_type | TEXT | Click Type | The type of the click. |
clickref | TEXT | Click Reference | The reference of the click. |
commission | NUMERIC | Commission | The commission of the conversion. |
conversion_id | TEXT | Conversion ID | The unique identifier of the conversion. |
conversion_item_approved_at | TIMESTAMP | Conversion Item Approved At | The approved date of the conversion item. |
conversion_item_category | TEXT | Conversion Item Category | The category of the conversion item. |
conversion_item_commission | NUMERIC | Conversion Item Commission | The commission of the conversion item. |
conversion_item_display_to_publisher | BOOLEAN | Conversion Item Display to Publisher | The display to publisher of the conversion item. |
conversion_item_id | TEXT | Conversion Item ID | The unique identifier of the conversion item. |
conversion_item_invoice_id | TEXT | Conversion Item Invoice ID | The invoice ID of the conversion item. |
conversion_item_last_update | TIMESTAMP | Conversion Item Last Update | The last update date of the conversion item. |
conversion_item_meta_data | OBJECT | Conversion Item Meta Data | The meta data of the conversion item. |
conversion_item_publisher_commission | NUMERIC | Conversion Item Publisher Commission | The publisher commission of the conversion item. |
conversion_item_reject_reason | TEXT | Conversion Item Reject Reason | The reject reason of the conversion item. |
conversion_item_sku | TEXT | Conversion Item SKU | The SKU of the conversion item. |
conversion_item_status | TEXT | Conversion Item Status | The status of the conversion item. |
conversion_item_status_id | TEXT | Conversion Item Status ID | The status ID of the conversion item. |
conversion_item_value | NUMERIC | Conversion Item Value | The value of the conversion item. |
conversion_item_voucher_codes | OBJECT | Conversion Item Voucher Codes | The voucher codes of the conversion item. |
conversion_lag | NUMERIC | Conversion Lag | The lag of the conversion. |
conversion_reference | TEXT | Conversion Reference | The reference of the conversion. |
conversion_status | TEXT | Conversion Status | The status of the conversion. |
conversion_time | TIMESTAMP | Conversion Time | The time of the conversion. |
conversion_type | TEXT | Conversion Type | The type of the conversion. |
conversion_value_id | TEXT | Conversion Value ID | The unique identifier of the conversion value. |
country | COUNTRY | Country | The country of the conversion. |
creative_id | TEXT | Creative ID | The unique identifier of the creative. |
creative_type | TEXT | Creative Type | The type of the creative. |
currency | TEXT | Currency | The currency of the conversion. |
currency_conversion_rate | TEXT | Currency Conversion Rate | The currency conversion rate of the conversion. |
currency_original | BOOLEAN | Currency Original | The original currency of the conversion. |
customer_reference | TEXT | Customer Reference | The reference of the customer. |
customer_type | TEXT | Customer Type | The type of the customer. |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
date | DATE | Date | The date of the conversion. |
day_of_month | TEXT | Day of month | Day of the month |
device_id | TEXT | Device ID | The unique identifier of the device. |
last_modified | TIMESTAMP | Last Modified | The last modified date of the conversion. |
meta_data | OBJECT | Meta Data | The meta data of the conversion. |
month | TEXT | Month | Number of the month |
publisher_commission | NUMERIC | Publisher Commission | The publisher commission of the conversion. |
publisher_id | TEXT | Publisher ID | The unique identifier of the publisher. |
publisher_name | TEXT | Publisher Name | The name of the publisher. |
ref_conversion_metric | TEXT | Ref Conversion Metric | The reference of the conversion metric. |
ref_conversion_metric_id | TEXT | Ref Conversion Metric ID | The reference of the conversion metric ID. |
ref_device | TEXT | Ref Device | The reference of the device. |
ref_device_id | TEXT | Ref Device ID | The reference of the device ID. |
ref_partnership_model | TEXT | Ref Partnership Model | The reference of the partnership model. |
ref_partnership_model_id | TEXT | Ref Partnership Model ID | The reference of the partnership model ID. |
ref_traffic_source | TEXT | Ref Traffic Source | The reference of the traffic source. |
ref_traffic_source_id | TEXT | Ref Traffic Source ID | The reference of the traffic source ID. |
ref_user_context | TEXT | Ref User Context | The reference of the user context. |
ref_user_context_id | TEXT | Ref User Context ID | The reference of the user context ID. |
referer_ip | TEXT | Referer IP | The IP of the referer. |
source | TEXT | Source | The name of the Windsor connector returning the row |
source_referer | TEXT | Source Referer | The referer of the source. |
specific_creative_id | TEXT | Specific Creative ID | The unique identifier of the specific creative. |
today | DATE | Today | Today's date |
value | NUMERIC | Value | The value of the conversion. |
was_disputed | BOOLEAN | Was Disputed | The status of the dispute. |
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 |