How to Import Reviews Using CSV in Manual Review Campaign Setup

Overview

The “Import Reviews with CSV” feature is designed to streamline the process of adding multiple reviews to your campaign by using a CSV file. This is especially useful for importing reviews from past customers efficiently.

Step 1 : Navigate to the Manual Campaign

Location: Collect Review -> Manual Campaign

  • Go to your dashboard and click on “Manual Campaign.”

Step 2 : Import Reviews with CSV

  • Click on ” Import Reviews with CSV “ tab.
  • Enter a name for your import task in the “Enter import task name” field.
  • Click on the Select file… button and choose your prepared CSV file from your device.
  • After selecting your file, click on the Upload & Continue button.

1. Download Example CSV File

  • To ensure your CSV file is formatted correctly, download the example file provided.
  • Click on the here link next to “You can download example file.”

2. Review Uploaded Data

  • Once uploaded, you will see a summary of the imported reviews under “Source Name” and “Date.”
  • Verify that the data is correct and corresponds to your CSV file.

Step 3 : Field mapping

  • Field mapping is a crucial step in importing reviews from a CSV file. This process ensures that the data in your CSV file is correctly assigned to the corresponding fields in the WiserNotify system.

1. Mapping Fields

    • For each Review Field, select the appropriate column from your CSV file using the dropdown menu in the CSV Column Name column.
    • The fields you need to map include:
      • Title: The title of the review.
      • Review Text: The main content or body of the review.
      • Rating*: The rating given by the reviewer (e.g., 5 stars).
      • Review Date: The date the review was written.
      • Reviewer Name*: The name of the person who wrote the review.
      • Reviewer Email: The email address of the reviewer.
      • Product ID: The unique identifier for the product being reviewed.
      • Product Name: The name of the product being reviewed.
      • Product URL: The URL to the product’s page.
      • Product Image URL: The URL to the product’s image.
      • Review Image URL: The URL to any image associated with the review.
      • Review Video URL: The URL to any video associated with the review.
      • City: The city of the reviewer.
      • State: The state of the reviewer.
    • Fields marked with an asterisk (*) are mandatory and must be mapped.

  • Once all fields are mapped, click the Next button at the bottom right of the screen to proceed with uploading the CSV file.