WhatConverts Connector Reference
4 metrics61 dimensions
The WhatConverts connector exposes 65 fields (4 metrics, 61 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
leads__lead_type Leads: Lead Type
Filter leads by their type.
Possible values (9)
phone_callweb_formchattransactionappointmenttext_messageemaileventother
WhatConverts Fields
WhatConverts leads fields
The leads report of the WhatConverts connector includes 31 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| additional_fields | TEXT | leads.additional_fields | Additional lead fields serialized as JSON. |
| answer_status | TEXT | leads.answer_status | Whether the call was answered. |
| call_duration_seconds | NUMERIC | leads.call_duration_seconds | The duration of the call in seconds. |
| caller_number | TEXT | leads.caller_number | The phone number of the caller. |
| city | CITY | leads.city | The city of the lead. |
| contact_company_name | TEXT | leads.contact_company_name | The company name of the contact. |
| contact_email_address | TEXT | leads.contact_email_address | The email address of the contact. |
| contact_name | TEXT | leads.contact_name | The name of the contact. |
| contact_phone_number | TEXT | leads.contact_phone_number | The phone number of the contact. |
| country | COUNTRY | leads.country | The country of the lead. |
| duplicate | BOOLEAN | leads.duplicate | Whether the lead is marked as a duplicate. |
| gclid | TEXT | leads.gclid | The Google click identifier of the lead. |
| landing_url | TEXT | leads.landing_url | The landing URL of the lead. |
| lead_campaign | TEXT | leads.lead_campaign | The marketing campaign of the lead. |
| lead_content | TEXT | leads.lead_content | The marketing content of the lead. |
| lead_custom_fields | TEXT | leads.lead_custom_fields | Custom lead fields serialized as JSON. |
| lead_id | TEXT | leads.lead_id | Unique identifier for the lead. |
| lead_keyword | TEXT | leads.lead_keyword | The keyword associated with the lead. |
| lead_medium | TEXT | leads.lead_medium | The marketing medium of the lead. |
| lead_profile_id | TEXT | leads.profile_id | Identifier of the profile the lead belongs to. |
| lead_region | REGION | leads.state | The state or region of the lead. |
| lead_score | NUMERIC | leads.lead_score | The score assigned to the lead. |
| lead_source | TEXT | leads.lead_source | The marketing source of the lead. |
| lead_status | TEXT | leads.lead_status | The current status of the lead. |
| lead_tracking_number | TEXT | leads.tracking_number | The tracking number that captured the lead. |
| lead_type | TEXT | leads.lead_type | The type of lead (phone_call, web_form, chat, and so on). |
| lead_url | TEXT | leads.lead_url | The URL where the lead was generated. |
| quotable | TEXT | leads.quotable | Whether the lead is marked as quotable. |
| quote_value | NUMERIC | leads.quote_value | The quote value assigned to the lead. |
| sales_value | NUMERIC | leads.sales_value | The sales value assigned to the lead. |
| spam | BOOLEAN | leads.spam | Whether the lead is marked as spam. |
WhatConverts tracking_forms fields
The tracking_forms report of the WhatConverts connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| attribute_type | TEXT | tracking_forms.attribute_type | The attribute type used to identify the form. |
| attribute_type_value | TEXT | tracking_forms.attribute_type_value | The value of the attribute used to identify the form. |
| form_id | TEXT | tracking_forms.form_id | Unique identifier for the tracking form. |
| form_name | TEXT | tracking_forms.form_name | The name of the tracking form. |
WhatConverts tracking_numbers fields
The tracking_numbers report of the WhatConverts connector includes 7 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| destination_number | TEXT | tracking_numbers.destination_number | The destination phone number. |
| last_used | tracking_numbers.last_used | The date and time the tracking number was last used. | |
| medium | TEXT | tracking_numbers.medium | The marketing medium of the tracking number. |
| phone_name | TEXT | tracking_numbers.phone_name | The name of the tracking phone number. |
| phone_number_id | TEXT | tracking_numbers.phone_number_id | Unique identifier for the tracking phone number. |
| source | TEXT | tracking_numbers.source | The marketing source of the tracking number. |
| tracking_number | TEXT | tracking_numbers.tracking_number | The tracking phone number. |
WhatConverts other fields
The WhatConverts connector has 23 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_created | accounts.account_created | The date and time the account was created. | accounts | |
| account_id | TEXT | Account ID | The WhatConverts account the record belongs to. | |
| account_name | TEXT | Account Name | The WhatConverts profile or account name. | |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The date of the record. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| profile_id | TEXT | profiles.profile_id | Unique identifier for the profile. | profiles |
| profile_name | TEXT | profiles.profile_name | The name of the profile. | profiles |
| today | DATE | Today | Today's date | |
| 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_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| 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 |
