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