Many organizations keep track of customers' feedback in different ways. It is quite important to review this data frequently, otherwise, it might be too late and there is no point of collecting the data. You may also like to drive insights from your internal data sources.

If this is the case, Pivony enables you to upload custom files to the platform. Our AI engine keep tracks of the data in an automated way and you no longer need to spend weeks to analyze your customers' feedback.

How to create Dashboard with Custom File Upload?

  1. After you click on "New Dashboard", you need to choose "Customer Data".

    Untitled

  2. Then, you need to choose Turkish or English, so that AI will only include reviews with your language preference. Specify the number of Topics you would like to see (Optional field). If you have over 3000 reviews, we recommend to give a number between 30-50.

    Note: Even if you don’t specify, our optimization engine will decide by its own.

Untitled

  1. Upload a CSV or Excel file in which you have reviews on each line. You can browse your file by clicking defined area or you can drag and drop your file to upload

    Untitled

  2. Your file needs to contain headers, so that Pivony could know about which column refers to which type of data attributes. Select “Yes” to pass to the next step.

    Screenshot 2023-05-15 at 12.18.03 PM.png

  3. There’s only one mandatory field, which is the Feedback column. Specify the feedback column in your uploaded file.

    Screenshot 2023-05-15 at 12.18.24 PM.png

  4. If you need to do segmentation based on Voice of Customer, you can do it by uploading your file which contains a unique identifier for each user. You will use the Audiences page for customer segmentation.

    Screenshot 2023-05-15 at 12.18.59 PM.png

  5. If you need to do email marketing through Pivony, you can do it by uploading your file which contains an email for each user. Remember that you must have an authorized consent for each user in order to perform your outreach campaign.

    Screenshot 2023-05-15 at 12.19.15 PM.png

  6. Pivony offers data visualization by taking into account the timestamp information of each review. Select the date column in your file.

    Screenshot 2023-05-15 at 12.19.27 PM.png

  7. If you need to do sms marketing through Pivony, you can do it by uploading your file which contains a phone number for each user. Remember that you must have an authorized consent for each user in order to perform your outreach campaign.

    Screenshot 2023-05-15 at 12.19.38 PM.png

  8. Pivony offers data visualization by taking into account the rating information of each review. Select the rating column in your file. If the rating values represents the Net Promoter Score (NPS), Pivony creates special NPS charts.

    Screenshot 2023-05-15 at 12.19.55 PM.png

    Screenshot 2023-05-15 at 12.27.03 PM.png

  9. Pivony provides Pivoting functionality to group data based on certain column. Select the Pivony column if you would like to apply filtering while exploring your dashboard. It can be Dealer ID or Dealer Name, or any similar column name.

    Screenshot 2023-05-15 at 12.20.07 PM.png

  10. After you click on Submit button, your dashboard create request will be sent and you will have your Dashboard ready in less than 1 hour. You will receive an email when it gets ready.