Conversation Export Column Definitions
CSV Column Definitions
- Participant ID:
- Person ID:
- Conversation ID: The unique ID assigned to this conversation. As seen in the value for the Conversation Link field, appending the Conversation ID to the web link “app.chatfunnels.com/#/chat/[Conversation ID]” will provide you with the link of the chat that you can access in your account.
- Conversation Link: The URL where you can access the full chat.
- Conversation Timestamp: The date and time that the first message was sent (usually by the chatbot)
- Time zone: The time zone of the person chatting in.
- Conversation Status: Whether the chat has a status of “Open” or “Closed”.
- Closed Timestamp: The time the conversation was closed
- Agent Routed Timestamp: The time that the first agent was routed to the conversation.
- Routed Agent Name: The name of the agent who the chatbot routed to the conversation, based on the Routing Settings established in the bot’s live chat skill.
- Routed Agent ID: The numerical ID associated with the agent who was routed
- First Responding Agent: The name of the agent who first responded to the web visitor in the chat.
- Responding Agent ID: The numerical ID associated with the agent who first responded.
- First Agent Response Time (seconds): The amount of time in seconds that transpired between when the bot routed a conversation to an agent and when an agent first responded to the web visitor. This is not the amount of time between when the web visitor first interacted with the bot and when an agent first responded; it is the time between when the bot routed the visitor to an agent and when an agent first responded.
- Country: The country where the web visitor chatted in from, according to their IP address.
- State or Region: The state, province, or region where the web visitor chatted in from, according to their IP address.
- City: The city where the web visitor chatted in from, according to their IP address.
- Zip Code: The zip code where the web visitor chatted in from, according to their IP address.
- Bot ID: The unique ID of the chatbot that generated the conversation. Appending this ID to the web link “https://app.chatfunnels.com/#/bots/[Bot ID]” will provide you the link of the chatbot in the Bot Management tab in your account.
- Bot Name: The name of the chatbot that generated that conversation.
- Lead Score: The lead score assigned to the conversation. For more information regarding lead scores, please refer to this support page.
- Contact Email: The email associated is saved in the email contact field for the web visitor in this conversation.
- Email Captured: Whether or not the contact’s email address was captured in this conversation.
Note: You may see that the email captured field is “FALSE” for a conversation although it has a value in the contact email column. This can occur for returning web visitors – if you have previously captured the contact’s email address, the system recognizes the contact, and the conversation does not capture their email address, the email captured field can be “FALSE” while still having a value for contact email.
- Email Captured By: Indicates whether or not the email was captured in the bot’s flow or manually by the chat agent, and if so, which chat agent captured the email address.
- Meeting Booked Timestamp: If a meeting was scheduled during this conversation, you will see the timestamp from when a web visitor booked the meeting.
- Meeting With Agent: The name of the agent on whose calendar the meeting was booked.
- Meeting Scheduled For: If a meeting is scheduled in the conversation, the date and time.
- Scheduled Meeting Length: If a meeting is scheduled in the conversation, how long in minutes the meeting was scheduled for.
- Meeting Held:
- Conversation Tags: A comma-separated list of any conversation tags tagged to this conversation. For more information regarding conversation tags, please refer to this support page.
- Conversation Start URL: The URL of the website where the web visitor began the conversation with the chatbot.
- Conversation Origin: How the web visitor first began interacting with your bot. If they entered a text response in order to first interact with your bot, this field will have a value of “bot prompt”; if they clicked a button answer choice, this field will have a value of “button click”.
- Number of Interactions: The number of inputted statements by both your bot and the web visitor. Every time your bot presents a message to the web visitor, this will count as an interaction in this calculation.
- Primary Goal Reached: The primary goal(s) reached in the automated portion of the conversation.
- Secondary Goal Reached: The secondary goal(s) reached in the automated portion of the conversation.
- Bot Participation: This indicates who interacted with the web visitor in this bot. If no live chat agent interacted with the web visitor in this conversation, the value for this field will be “Only bot”. If a live chat agent also interacted with the web visitor, the value for this field will be “Bot plus human”.
- Tracking info: UTM Source, UTM Medium, UTM Campaign, UTM Term, UTM Content, Google Click ID, Google Ad Source (gclsrc), Display Click ID, Facebook Click ID, Zanox Click ID
- Conversation Rating: Results of the conversation rating skill
- Feedback Prompt: From conversation rating skill
- Feedback: Visitor response to feedback prompt in conversation rating skill
- Latitude: The latitude where the web visitor chatted in from, according to their IP address.
- Longitude: The longitude where the web visitor chatted in from, according to the IP address.
- First Name: The value saved in the “First Name” field for the contact associated with this conversation.
- Last Name: The value saved in the “Last Name” field for the contact associated with this conversation.
- Email Address: The value saved in the “Email Address” field for the contact associated with this conversation.
- Phone: The value saved in the “Phone” field for the contact associated with this conversation.
- Company Name: The value saved in the “Company Name” field for the contact associated with this conversation.
- Company Website: The value is saved in the “Company Website” field for the contact associated with this conversation.
- Company Industry: The value is saved in the “Industry” field for the contact associated with this conversation.
- Company Employee Count: The value saved in the “Employee Count” field for the contact associated with this conversation.
- Company Revenue: The value saved in the “Annual Revenue” field for the contact associated with this conversation
Note: Fields that pull contact information (i.e., First Name, Last Name, Email Address, Phone, Company Name, Company Website, Company Industry, Company Employee Count, Company Revenue) pull the current data associated with the contact. So, if these values are changed for a contact, the next Reports Dashboard export will include the updated contact information, not the values that were true at the time of the conversation.
- Meeting_Booked: True/False, whether a meeting was booked in the conversation or not.
- Last Activity Timestamp: The date and time of the last activity in the chat
- First Visitor Chat Timestamp: The date and time that the visitor sent their first message.
- Calendar Drop: True/False, whether a calendar was dropped in the conversation or not.
