What reports can I extract from my campaign?

There are 3 different reports that are available for each campaign you run. You can download them from the 'Manage Conversations' page for your campaign.

 

 

Chronologically Ordered Report​

 

This report is mainly used to view the chronological message history of each contact's conversation.

 

The first few headers of this report contain the contact information and custom data (if any) that was set during contact upload:

 

 

 

The next set of cells show a summary of the contact's activity. This section starts with Last Activity: the last time that we sent or received a message to/from this contact. This column is helpful for long running-campaigns because if you sort by Last Activity, you can see only the contacts with activity since a certain date.

 

Next is a list of all nodes in the conversation. These can vary between each campaign/solution, but basically it denotes whether or not (TRUE/FALSE) a contact visited a particular node in the solution:

 

 

 

After that, the chronological message history is listed from left to right for each contact, with Timestamp, direction and the message content for each message:

 

 

 

 

Node Ordered Report​

 

This report is similar to the chronological report, except with one key difference: messages are broken in to columns based on each node in the conversation. This can be useful if you want to use Excel filters to show only the users who reached a particular node in the conversation, and perhaps what they said at that node.

 

 

 

Extracted Data​ Report

 

This report is most helpful for getting the results of your campaign back into a CRM. The contact information set on upload is shown first, along with the Date Started, and Last Activity: 

 

 

As mentioned above, Last Activity is useful for helping you see only the contacts with activity since a certain date.

 

The extracted data report will show some basic extracted fields (wrong number, cancelled, etc), along with some specific campaign data, such as whether a contact confirmed their address or whether they were interested in attending an event:

 

 

It's worth making specific mention of the unreachableNumber column. If this is 'yes' then it means that our SMS provider tried multiple times to deliver the message to this contact, but that they were unsuccessful. This can be because the number is no longer connected or the user does not have mobile coverage or has their phone turned off for an extended period of time.

 

Some column sets have a format like: newEmail, newEmail_message, potential_newEmail, like so:

 

 

newEmail: This is the extracted email from the message, in this case [e-mail]

newEmail_message: This is the message from which we extracted the email

potential_newEmail: This is a message that looks like it might contain an email, but it is not properly formatted