Sentiment Analysis for Unstructured Text (CSV Import)

 

You can now use all of Appbot’s clustering tools, including Sentiment, Topics, Custom Topics and more, to analyze other sources of customer feedback. Try it out for:

  • Survey responses
  • Support tickets
  • NPS comments
  • Social media feeds
  • or other unstructured text.

Appbot’s text mining analysis can analyze any unstructured text data, provided it can be placed in a csv. Once you upload the csv to Appbot, that source will appear in your apps list and you can investigate the data using all the various features and tools of Appbot.

Uploading Unstructured Text CSVs To Appbot

  1. To upload a csv to Appbot, login to your Appbot account and navigate to the Manage Apps page from the top navigation.
  2. Click “Add New Source”.
  3. On the Adding New Source page, click CSV Import.

  4. From here, clicking + Add New Source in the top right hand corner will open a dialogue box in which you’re able to enter the:
    – Name
    – Icon URL (if you wish to have an icon for your custom data set)
    Once you’re ready to go, select Create Data Source.
  5. Now click the Import CSV button.
  6. From there, you’ll be redirected to the Import Source page where you can import your CSV file. Just select Choose File, and locate your custom data csv.
    text mining
  7. In order to ensure the fields are imported correctly, you must map your columns of data to the fields in Appbot. The Unique ID and the Published Date are required fields, but the other fields can be mapped to your requirement.
  8. If your import already contains headers, you can select to toggle on CSV Contains Header which will take that into account when importing your data set.
    *Note: It is important to note that if you have many columns being imported that you may need to scroll across to the right in order to see and map all of them.
  9. Once this is complete, you will be able to review the rows being imported in the summary box at the bottom of the page.
  10. When you’re happy with the mapping, select Start Import and your data will begin uploading.
  11. After your data has finished importing you will see the following screen, notifying you of its completion.
    *Note: Any lines containing errors will not be uploaded, you’ll need to fix the errors and re-upload the file.text mining
  12. Once you’re happy with your data set, select Finish and commence browsing your data in Appbot!

Importing new rows to your existing CSV source

  1. Navigate to Manage Sources > Add New Source > CSV. You will land here.
  2. Select “Import CSV” beside the source you want to add more data to.
  3. Follow the prompts to complete your import.

If you have imported a unique ID column to your CSV source Appbot will do the following:

  • Add a new row of data for any row with a unique ID that does not already exist in this source.
  • Update (overwrite) the row for any row of data where the unique ID already exists.

We also offer integrations to analyze the sentiment of your Zendesk tickets, and Twitter posts.

Feel free to contact us at support@appbot.co with any questions about importing custom data sources or check out our FAQ section here.