What are the limitations of the Excel file expected for the upload ?
- Limitations: Max 50.000 lines / Max 100 columns (ie. A from CV columns) for your data
- Your data should be portrait-oriented (If it is not the case, please copy with transpose).
- Your data should have columns with headers on the first line only. (Additional header lines will be considered as data to analyze: please delete them).
- The header will be the filters you will refind in the solution: correct them if necessary to get clean data.
- Minimum one column with text to analyze (Called with the Header Status "Text", see Worksheet 2.). If you have several columns, it is managed by the solution.
- We expect one date column in the following format YYYY-MM-DD for each line. This can be the date of comment (or preferably) the date of the experience or any random date. (Called with the Header Status "Date", see Worksheet 2.)
- If your data do not contain any column, we will propose you to give us one beginning and one end date to choose random date into the interval period.
- Personal data: email, addresses, personal names, credit card customer information, etc. are prohibited for GDPR reasons. Please do not send us this data, this kind of data is of no use for our analysis.
- No special characters in headers: A-Z;a-z are better (Points in header(s) will be automatically replaced with the character "-")
- if you insert 3 different files several times with 3 different headers for the same concept, different filters will be created. We advise you to keep the same format to group easily the filter names and facilitate further searches.
- Satisfaction score maximum and minimum will be detected from your data. The Satisfaction score will then appear like this: 3/10 on the platform (if 10 is the max)
- Recommendation scores are expected from 0 to 10. Adjust it to this scale so that the NPS calculated will be correct.
All rights reserved: Qemotion France SAS (2021)
Qemotion proposes CXinsights.io, a Customer experience solution: A SaaS solution that is capturing emotions from survey comments and webreviews and that is unlocking valuable insights.
The customer experience management platform showcases the emotions along your real customer journey, the interactions with the staff described by your clients etc.
You can therefore determine in an easier way the key action levers like:
- key insights and variations,
- main irritating points,
- main enchantment points.
The platform helps you manage and prioritize the improvement actions you want to launch in order to improve the customer experience. As a consequence, you will increase loyalty and decrease churn levels.
The platform helps you also diffuse information into your organization with automated emotional alert systems, that transform your CRM into a Customer Enriched Emotion Management system (CEEM).
More information on: https://www.qemotion.com
Related Articles
How to integrate or upload an Excel file into an existing project ?
If you want to integrate or upload an Excel file into an existing project, it is simple. Please read the following articles depending of your plans: Key instructions for Excel File Upload: Read the article Excel File Upload for Emotion Corporate ...What are the key concepts to understand before uploading an Excel file ?
Q°emotion solution will integrate the data according to your needs. The Excel file you want to upload is not only made with comments, but also other kind of data that are contextual, and may be interesting to you to filter / group the information. ...I don't want to send my data file by email or using SFTP, what can I do ?
If you don't want to send your data files by email or using the SFTP protocol to transfer your data, another solution existe: It's possible, in a totally secured way, to load your files directly on the following link of the platform: ...What shall I do if new fields emerged in some filter columns of my data file(s) ?
General Principle When in a filter column of your data file, a new field is arising, the corresponding entry will be immediately and automatically accessible since the data processing. Therefore, if you add a new store or a new hotel in your filter ...When shall I create a new project and when shall I incorporate my data to an existing project ?
The number of projects that you can create on the platform is not limited. We advise you to create a new project when one of the 3 following cases arise: The use case or the audience are totally different Examples: Comments about the brands vs. ...