How to analyze sentiment of Trustpilot Online Reviews with generative AI

Sentiment Analysis
Trustpilot

How to Analyze Sentiment of Trustpilot Online Reviews with Generative AI

As a business owner, monitoring customer feedback is essential for understanding how your company is perceived online. Trustpilot is a popular review platform where customers can leave feedback about their experiences with your business. Analyzing the sentiment of these reviews gives you insight into how customers feel about your products or services. In this post, we'll show you how to use generative AI to perform sentiment analysis on Trustpilot online reviews.

What is Sentiment Analysis?

Sentiment analysis is a natural language processing (NLP) technique that involves using machine learning algorithms to automatically identify and extract the emotions or opinions expressed in a given piece of text. The algorithms are trained on a labeled dataset of text samples, where each sample is labeled with its corresponding sentiment (positive, negative, or neutral). The model learns to recognize patterns and features in the text that are associated with different emotions, and uses these patterns to predict the sentiment of new, unseen text.

Sentiment analysis has many applications, such as customer feedback analysis, social media monitoring, and market research. It's a powerful tool for organizations that want to understand how people feel about their products or services, or to track public opinion on different issues. It can help automate tasks and extract valuable insights from large amounts of text data.

Example Use Cases

Some use cases for performing sentiment analysis on Trustpilot online reviews include:

  • Monitor customer satisfaction and identify areas for improvement
  • Identify common complaints and address them to improve customer experience
  • Track changes in sentiment over time to gauge the effectiveness of changes to your business or products
  • Compare your business's sentiment to that of competitors for competitive analysis

Teams that might find these use cases helpful include: customer support, customer success, product, marketing, and operations.

Accessing your Data and Confirming your Sentiment Scale

To access your Trustpilot reviews, log in to your account and navigate to the "Reviews" section. Here you can download a CSV file of your reviews. Your sentiment scale will depend on the tool you use for sentiment analysis. Some tools use a numerical scale from -1 to 1, where -1 is the most negative sentiment and 1 is the most positive. Others use a descriptive scale, such as:

  • Very Negative
  • Negative
  • Neutral
  • Positive
  • Very Positive

Once you have your data and sentiment scale, you can use generative AI to automatically analyze the sentiment of your Trustpilot reviews. This will help you identify trends and make improvements to your business to better meet customer needs. It can also help you maintain a positive reputation online and attract new customers.

Using AirOps to perform Keyword Identification

With AirOps, you can easily extract relevant keywords and phrases from your text-based data using the Keyword Identifier data app. Here's how:

  1. Select "Keyword Identifier" from the Data Apps page. The input required for Keyword Identifier is the "text_field" which is the input text data.

  2. Decide where you want the analysis to be performed and stored. The Keyword Identifier data app can be easily used in the AirOps Data App page and via API, but in this example, the analysis will be performed in Snowflake through an external function called AIROPS_KEYWORD_IDENTIFIER.

    Here is an example SQL query:

    SELECT
    AIROPS_KEYWORD_IDENTIFIER(text_field) as result
    FROM
    your_table
  3. Execute the keyword extraction analysis by running the SQL query. The output will contain an array of keywords and phrases extracted from the input text data.

    Example Input:

    "Hello, I am having trouble with my account. I cannot seem to log in and I have tried resetting my password multiple times."

    Example Output:

    "keywords": ["trouble", "account", "log in", "resetting", "password", "multiple times"],"summary": "A customer is having trouble logging into their account and has tried resetting their password multiple times."

Using AirOps to perform Sentiment Analysis

With AirOps, you can easily perform sentiment analysis on any text data such as reviews, support tickets, or sales calls using Sentiment Analyzer. Here’s how:

  1. Select "Sentiment Analyzer" from the Data Apps page. The only input for Sentiment Analyzer is some text to analyze.

  2. Decide where you want the analysis to be performed and stored. The Sentiment Analyzer data app can be easily used in the AirOps Data App page and via API, but in this example, the analysis will be performed in Snowflake through an external function called AIROPS_SENTIMENT_ANALYZER.

    Here is an example SQL query:

    SELECT
    AIROPS_SENTIMENT_ANALYZER(text_field) as result
    FROM
    your_table
  3. Execute the sentiment analysis by running the SQL query. The output will contain a sentiment score and sentiment summary, as well as a list of positive and negative keywords extracted from the input text data.

    Input:

    "I'm sorry to say that I had a terrible experience with your product. The customer service was unresponsive and the product didn't work as advertised."

    Output:

    "positive_keywords": [],"negative_keywords": ["terrible experience", "customer service", "unresponsive", "product", "didn't work", "advertised"],"score": -0.8,"sentiment": "Very Negative"

Using AirOps to perform Text Classification

With AirOps, you can easily perform classification using generative AI. Here’s how:

  1. Select "Text Classifier'' from the Data Apps page. Below are the possible inputs for Text Classifier.text_field: The input text data.categories (optional): Categories can be specified as a comma-separated list. Leave empty for automatic determination.multi_category: Set to “true” if the text can belong to multiple categories, or “false” if it can only belong to one category.

  2. Decide where you want the analysis to be performed and stored. The Text Classifier data app can be easily used in the AirOps Data App page and via API, but in this example, the analysis will be performed in Snowflake through an external function called AIROPS_CLASSIFIER.

    Here is an example SQL query:

    SELECT
    AIROPS_CLASSIFIER(text_field, categories, multi_category) as result
    FROM
    your_table
  3. Execute the classification analysis by running the SQL query. The output will contain a list of keywords extracted from the input text data that are relevant to the identified categories and a list of categories that the input text data belongs to based on the provided categories or automatic determination.

Want to build your own LLM Apps with AirOps👇👇