WhatConverts | Leads Standard Dataset
Taylor Nall
Below are the measures and dimensions Alight Analytics considers standard for the WhatConverts Lead dataset. The last 7 days of data are pulled each day. This is an activate-able dataset through ChannelMix Control Center.
Note on Attribution: WhatConverts does provide attribution options like first click and last click to users, but those MUST be adjusted within the user interface. Due to API limitations, we are unable to make changes to attribution when we pull the data.
Pro Tip: If needing greater than 30 days of data refresh, please let the Product Support team know and they can adjust the refresh window to your preference.
| Field Name | Field Type | Description |
| Report Date | DATE | Date and time when the lead was created |
| Date Created | TIMESTAMP | Date and time when the lead was created in ISO 8601 format (UTC). |
| Account Id | INTEGER | Unique identifier for the account in which to return leads from. Supported when using an Agency Key. |
| Profile Id | INTEGER | Unique identifier for the profile in which to return leads from. Supported when using an Agency Key. |
| Profile | STRING | The name of the profile. |
| Lead Id | INTEGER | Unique identifier for the lead. |
| Lead Type | STRING | Lead type to return for this request; chat, email, event, other, phone_call, text_message, transaction or web_form. |
| Lead Status | STRING | Lead status to return for this request; repeat or unique leads. |
| Lead Source | STRING | Return leads that have this lead source. |
| Lead Medium | STRING | Return leads that have this lead source. |
| Lead Campaign | STRING | Return leads that have this lead campaign. |
| Lead Content | STRING | Return leads that have this lead content. |
| Lead Keyword | STRING | Return leads that have this lead keyword. |
| Lead Url | STRING | The URL where the lead took place. |
| Landing Url | STRING | The URL where the user arrived on the website. |
| Additional Fields | STRING | Additional fields for the lead. |
| Answer Status | STRING | The answer status for the lead; Answered, No Answer, or Busy. Applicable to phone_call lead type. |
| Browser | STRING | The browser used by the user. |
| Call Duration | STRING | The formatted duration of the call for the lead. Applicable to phone_call lead type. |
| Call Duration Seconds | STRING | The duration of the call in seconds for the lead. Applicable to phone_call lead type. |
| Call Status | STRING | The call status for the lead; In Progress, or Completed. Applicable to phone_call lead type. |
| Caller City | STRING | The caller's city for the lead based on the caller_number. Applicable to phone_call and text_message lead type. |
| Caller Country | STRING | The two-letter ISO country code of the caller for the lead based on the caller_number. Applicable to phone_call and text_message lead type. |
| Caller Name | STRING | The name of the caller |
| Caller Number | STRING | The E.164 formatted caller's number for the lead. Applicable to phone_call and text_message lead type. |
| Caller State | STRING | The caller's state for the lead based on the caller_number. Applicable to phone_call and text_message lead type. |
| Caller Zip | STRING | The caller's zip for the lead based on the caller_number. Applicable to phone_call and text_message lead type. |
| Chat Status | STRING | The chat status for the lead; In Progress, or Completed. Applicable to chat lead type. |
| Destination Number | STRING | The E.164 formatted destination number for the lead. Applicable to phone_call lead type. |
| Device Make | STRING | The device make used by the user. |
| Device Type | STRING | The device type used by the user. |
| Duplicate | STRING | If true will return only duplicate leads. |
| Email Address | STRING | Return leads for the contact that have this email address. |
| Form Name | STRING | The form name |
| Gclid | STRING | The Google click identifier for the lead. |
| Google Analytics Client Id | STRING | The Google Analytics client ID for the lead. |
| Hubspot Visitor Id | STRING | The Hubspot visitor ID for the lead. |
| Ip Address | STRING | The user IP address for the lead. |
| Line Type | STRING | The line type of the caller for the lead. Applicable to phone_call and text_message lead type. |
| Mapped Fields Menu Options | STRING | The selection the caller made within the voice directory. |
| Msclkid | STRING | The Microsoft click identifier for the lead. |
| Operating System | STRING | The operating system used by the user. |
| Phone Name | STRING | The name of the tracking number for the lead. Applicable to phone_call and text_message lead type. |
| Phone Number | STRING | Return leads for the contacts that have this E.164 formatted phone number. |
| Play Recording | STRING | The URL to play the call recording. Applicable to phone_call lead type. |
| Play Voicemail | STRING | The URL to play the voicemail. Applicable to phone_call lead type. |
| Quotable | STRING | Quotable type to return for this request; yes, no, pending or not_set. |
| Quote Value | DECIMAL | Return leads that have a quote value; has_value or no_value. |
| Recording | STRING | The URL to download the call recording. Applicable to phone_call lead type. |
| Sales Value | DECIMAL | Return leads that have a sales value; has_value or no_value. |
| Spam | STRING | If true will return only spam leads. |
| Tracking Number | STRING | The E.164 formatted tracking number for the lead. Applicable to phone_call and text_message lead type. |
| User Id | STRING | Return leads for the contact that have this user id. |
| Voicemail | STRING | The URL to download the voicemail. Applicable to phone_call lead type. |
| Insert Date | TIMESTAMP | ChannelMix Field - When the row was inserted into ChannelMix |
| Channelmix Profile | STRING | ChannelMix Field - The descriptive name assigned to this data segment |