Bots have the ability to ask questions to subscribers using the Question . If you set up saving the answer in the field , the subscriber's answer will be saved in his profile.
You can view the answer in the "Subscribers" section by clicking on his name.
This way you can view data for any individual subscriber. This is useful when you need to see what a specific user responded to.
But what if you need data for several subscribers at once? For example, you want to see the phone numbers of people who signed up for a consultation. In this case, export .
Export allows you to not only transfer users to another account. With its help, you can get a table with all the fields in which the subscribers' answers are recorded.
We get a table with answers
To upload responses to the table, go to the "Subscribers" section. Using filters, select the desired subscribers and click the Export users . Be sure to select the "Export with all user fields" option, click Export , then Download file .
A file in "csv" format will be downloaded to your device. You can open it either through an office program, such as Excel, or through online services that allow you to open a file in this format.
The table contains data for all subscribers that were selected during export. Each row contains data for one user. The table will open approximately as follows:
To see the data more correctly, for example, in the “phone” field instead of “8.9E+10” — “89017108896”, it is enough to increase the column width:
What data is in the table?
- ID is the profile number that the messenger sends to us. It is individual for each subscriber.
- bothelp_user_id — the serial number of the subscriber's profile in the platform's account. It is unique.
- name — first and last name.
- first_name — name.
- last_name — last name.
- email, phone — standard fields from the subscriber profile.
- utm_source and others are UTM tags.
- conversations_count — the number of conversations with the subscriber.
- first_contact_at — time of first contact (subscription time, registration time).
- last_contact_at — time of last contact.
- Time is the number of seconds since January 1, 00:00, 1970.
- Other custom fields and data from them.
How to convert contact time to normal form
You can use the formula =timestamp/86400+DATE(1970;1;1), where "timestamp" is the value from the first_contact_at or last_contact_at
Example: =1500598288/86400+DATE(1970;1;1) will be converted to 07/21/2017
If you still see strange numbers, change the format of the new column to Date.
Excel spreadsheet displays strange characters
Apparently, Microsoft Excel opened a file with incorrect encoding. This happens especially often with older versions of the program.
Try changing the encoding to UTF-8 according to the instructions .
If it doesn't work, you can try to open the exported file in Google Sheets: https://www.google.ru/intl/ru/sheets/about/ and how to open a csv file: https://help.loyverse.com/ru/help/how-open-csv-file-google-sheets
If you have not found the answer to your question, ask us in the chat inside your account or write to BotHelpSupportBot or to hello@bothelp.io
Get 14 days of full functionality of the platform for creating mailings, autofunnels and chatbots BotHelp.