Use the Ratings & Reviews content management tool and its powerful filtering options to:

Get started

Watch this short video to learn about working with the Ratings & Reviews solution.

To start using Ratings & Reviews:

  1. Sign in to the Bazaarvoice Portal .
  2. From the navigation bar, select Ratings & Reviews > Reviews.
  3. Search, filter, or sort your review content from the list view that appears.

Required solutions and roles

To use Ratings & Reviews, you must be assigned the following:

Solution: One of these roles:
Ratings & Reviews
  • Content Administrator
  • Content Viewer
  • Content Responder
  • Content Moderator

Learn more about Portal users and permissions.

The list view

The following illustration highlights the key elements in the list view:

list view
Label UI element Label UI element
Saved filters drop-down Moderation status label
Sort methods View details
Save filters Moderation codes
Review count Review ID
Sort methods Product information
Search field Reject or Approve
Export button
Note: To view content in more detail, select Detail view to drill down into any of the displayed reviews.

Find what you’re looking for faster. Use the search bar to find reviews by entering the review ID, review title, review text, product ID, product name, campaign ID, or contributor location.

quick search
  • Best match: Enter your keywords in the search bar and press the Enter key. For example, EnduranceFlyer07.
  • Exact match: For more precise results, put your search keywords in double quotation marks. For example, enter the product name “EnduranceFlyer07” for exact results.
  • Multiple keyword search: Enter multiple keywords into the search bar separated by commas. No need to put them in double quotation marks. For example, if you’re searching for reviews for two specific products, enter their respective product IDs: 42398905,3098731831.

Sort reviews

In the list view, from the drop-down list, select one of the following:

  • Sort by rating: Low to high or High to low
  • Sort by date: Old to new or New to old
sort-reviews

Filter reviews

Filter content to find and manage your reviews more easily. To find your content, select a filter category. For example, you can filter by date, moderation status, or product content.

Tip: You can set up and save multiple personal filters to optimize your workflow.
Note: You can share a personal filter, making it available to everyone in your instance. This is especially valuable for intricate filters, as it can spare your colleagues the effort of setting up similar content filters themselves.

To apply filters:

  1. In the list view, select the filter category you’re interested in.
  2. Select your filter criteria, and enter any information required.
  3. Select Apply and close.
Note: Repeat steps 2 and 3 to apply more filters.
Tip: If you can’t find what you’re looking for, select Clear all to clear any active search filters and enter new search criteria.
filter reviews

—Filter category (Content), with (Review type) filter value and criteria selected

The following table shows the filter categories and values you can apply:

Filter category Filter values and additional criteria
Date Select one:
  • Yesterday
  • Last 7 days
  • Last 30 days
  • This month
  • Last month
  • This calendar quarter
Or enter custom dates.
Content Campaign ID: Select a web or email campaign source, or enter a custom campaign ID.
Featured: Select Featured reviews
Locale

If your instance includes more than one locale, your locales will be listed. Select one or more. For example:

  • de_US
  • en_US
  • fr_US
  • jp_US
  • no_US
Rating

Select one or more:

  • 1 star
  • 2 stars
  • 3 stars
  • 4 stars
  • 5 stars
Review type

Select one or more:

  • Rating and text
  • Rating only
Responses

Select one or more:

  • Reviews with a response
  • Reviews without a response
Review IDs: Enter at least one review ID.
Visual content

Select one or more:

  • Reviews with photos
  • Reviews without photos
  • Reviews with videos
  • Reviews without videos
Products Brand: Enter brand names or IDs as required.
Category: Enter category names or IDs as required.
Product attributes: Select a custom product attribute, such as Model Number. Enter the required filter citeria. For example, "S21 Ultra 200", "LG WM4500HBA", or "Dexl XPS 13 9310". You can add as many filter values as needed to refine your search.
Product ID: Enter product IDs as required.
Product name: Enter product names as required.
Product status

Select one or more:

  • Active products
  • Inactive products
Moderation Moderation status

Select one or more:

  • Reviews with photos
  • Reviews without photos
  • Reviews with videos
  • Reviews without videos
Moderation codes: Select one or more codes from the list. You can also select No moderation codes.
Contributor Review contributor: Enter contributor names or IDs.
Note: A contributor’s ID and email address are considered personally identifiable information (PII). To view and use the Contributor filter, your must be granted access to PII by your Account Administrator.

Set up a personal filter

  1. Select the filter values and criteria you need.
  2. Select Apply and close in each filter category you define.
  3. Select Save filters. A pop-up window appears.
  4. Enter a unique name for your personal filter and select Save.
  5. Select Share filter with all users to make your personal filter available to everyone in your instance.
    Note: Saved filters will appear in a drop-down list in the upper-left corner of the list view.
    custom filter
Note: The filter drop-down will be greyed out if you don't have any filters saved.

Delete a filter

  1. In the saved filters drop-down list, find the filter you want to delete.
  2. Hover over the name of the filter you want to delete so that it’s highlighted.
  3. Select the trash can icon to delete the highlighted name.
    custom filter
Note: A shared filter will be deleted for every user.

Manage reviews

Open the detail view to:

  • Read reviews
  • Inspect visual content
  • Explore comments and helpfulness votes contributed by consumers
  • Find product and reviewer information
  • Moderate content
  • Respond to reviews and add notes

To open up the detail view:

  • Select the title of any review.
    Or
  • Select View details.

The following illustration of the list view highlights the two ways of opening the detail view:

detail view

—Review title —View details

The detail view

The following illustration highlights the key elements in the detail view:

detail view features
Label UI element Label UI element
All reviews (list view) Previous/Next review
Product and reviewer information Moderation codes
Moderation status label Helpfulness votes
Visual content Approve or Reject
Responses Comments

To navigate quickly through reviews:

  1. From the list view, select either the review title or View details.
  2. Within the detail view, select Next to go to the next review or select Previous to go back to the previous review.
Note: This function is particularly useful when you've applied filters and you're responding to or moderating a set of reviews.

View secondary ratings

Secondary ratings provide a snapshot rating of your product’s attributes or qualities. For instance, rating attributes like quality, design, and value for money for an exercise bike can help consumers decide which bike is most suitable for their needs. Secondary product ratings appear below the review stars in the detail view, which is highlighted in the following image:

exercise bike
Note: Secondary ratings are separate from and do not affect the product’s overall rating.

Key benefits

Secondary ratings

  • Offer greater details about product qualities, which helps consumers make better purchase decisions.
  • Pinpoint areas where you fall short as a brand, allowing you to improve your products.

Product-specific questions

To enable consumers to rate specific qualities of your products, add product-specific questions to your review submission form.

For example, in addition to asking a consumer to write a review, you may want them to rate your products on attributes like Comfort, Ease of use, Delivery, or Price on a standard 1-5 rating scale.

You can customize the rating slider with different rating scales, such as 1-3, 1-5, or 1-7. Additionally, you can customize the rating scale values to meet your specific requirements. For example, if you want to create a Customer Service rating slider, you can define unique rating labels like Poor, Average, and Excellent.

Note: Use the submission form editor in Portal Configuration to add product attribute questions.

View visual content

If a review contains attached photos or videos, they are displayed as a link underneath the review text in the list view.

To view the content:

  1. Select the link. The video and photo thumbnails will appear.
  2. Select Expand and view to inspect the visual content.

Alternatively, you can select either the review title or View details, scroll to the photo or video thumbnails and select Expand and view.

Caution: It's important to inspect images and play video content before you approve a review.
Tip: To quickly find reviews that include photos or videos, select the Content filter then select Visual content.

View product details

When you select either the review title or View details to open a review, you can view information about the product itself.

The following information is displayed in the Product details panel on the left side of the review:

  • Product ID
  • Product category
  • Category ID
  • Brand ID
  • Brand
  • Product description. Select Show description to view.
Tip: Select the product link to open the product details page on your site.

View reviewer details

Under the Review contributor panel to the left side of the review, you can view the following information:

  • Contributor badge
  • Reviewer name (displays if approved during the moderation process)
  • Reviewer email address (redacted)
  • Reviewer ID (redacted)
  • Reviewer’s location (if provided)
Note: A reviewer’s email address is considered personally identifiable information (PII). PII is redacted by default and can only be viewed by users who have been granted access to PII by the Account Administrator.

View consumer comments

When you select either the review title or View details to open a review, you can read any comments that have been added by shoppers who have read the review.

  • If any comments are attached, the number will be shown in the panel to the right of the review.
  • To read the comments, select Jump to comments.

View helpfulness votes

In the panel to the right of the review, you can view the number of helpfulness votes registered by shoppers who have seen the review.

  • A thumbs-up icon is displayed above the number of votes registered by consumers who found the review helpful.
  • A thumbs-down icon is displayed above the number of votes registered by consumers who found the review unhelpful.

View additional information collected through customized questions

If your review submission forms include customized questions, the additional information you collect from contributors will be listed directly below the review text in the detail view.

Respond to reviews

The way you engage with consumer reviews in public can significantly shape the perception of your brand. Offering constructive responses to negative feedback shows your commitment to customer satisfaction.

Note: Only users who have been assigned the role of Account Administrator, Content Administrator, or Content Responder can respond to reviews and edit or delete responses. Learn more about user roles.
Note: Only responses to Approved reviews are displayed publicly.

Response to a review

When responding to a review, you must provide your department’s name. This adds credibility to your review responses.

Note: You can also add a public display name to your response. The last response name you selected from the drop-down list remains the default.
  1. Select either the review title or View details to open the review.
  2. Read the review and enter your text in the Your response text field.
  3. Under Your response details, select Add details. The Add details section appears.
  4. Enter your Department name.
  5. (Optional) Enter your public display name.
    Responder dialog
    Tip: You can select any previously saved display name from the drop-down list. Newly added display names will also appear here.
  6. Select Save.
  7. To post your public response, select Add. Your response will now appear with the review on your site.
Note: Depending on your distribution package, the updated review can also be syndicated either to the site of a selected retailer or to all retailers in the Bazaarvoice Network.
Note: You can add numerous responder details to the responders drop-down list. Select Add responder details, enter the relevant information, and then select Save.

Delete responder details

  1. Search for a review, filter reviews, or sort your reviews list.
  2. Select either the review title or View details to open a review.
  3. Find the responder details you want to delete from the drop-down list.
  4. Hover over the responder details you want to delete.
  5. Select the trashcan icon to delete the highlighted details.

Edit a response

After a response is posted, you can edit it.

Note: If you’re a retailer who participates in the Connections program, you can delete a response posted by a brand, but you can’t edit it.
  1. Search for a review, filter reviews, or sort your reviews list.
  2. Select either the review title or View details to open the review.
  3. Select Edit under the response you wish to change.
  4. Make your changes and select Update.

Delete a response

After a response is posted, you can edit or delete it.

Note: If you’re a retailer who participates in the Connections program, you can delete a response posted by a brand, but you can’t edit it.
Caution: Deleting a response is permanent and you can’t undo this action.
  1. Search for a review, filter reviews, or sort your reviews list.
  2. Select either the review title or View details to open the review.
  3. Select Delete under the response you wish to remove and confirm that you want to permanently delete the response.

Add internal notes

In the Detail view, you can add notes that will be visible to your team members. Adding internal notes can be a useful way of recording your comments about the content of the review or any responses that have been posted.

Note: Only users who have been assigned the Account Administrator, Content Administrator, Content Responder, or Content Moderator roles can add notes. Learn more about Portal roles and capabilities.

To add internal notes:

  1. Search for a review, filter reviews, or sort your reviews list.
  2. Select either the review title or View details to open the review.
  3. Read any existing entries under Internal notes.
  4. Enter your note in the text field and select Add.
Note: When you add a note, the date and time will be recorded and displayed along with your username. You can’t edit or delete internal notes.

Contributor badges

Contributor badges are labels that highlight reviewers who have submitted significant or helpful product reviews. Your consumers are more likely to be influenced by reviews written by an Expert contributor. Badges add credibility to your product reviews.

review contributor

Note: Badges are associated with a user's profile. Staff, Top contributor, or Expert badges will appear on any reviews written by that user. Badges also show up on comments left by that user, including comments on other users' reviews.

Ratings & Reviews in Portal displays the following badge types:

  • Staff (affiliation badge)
    Highlights the reviewer has an affiliation with the product or retail organization, or is employed by your company.
    staff

  • Top contributor (merit badge)
    Awarded to reviewers based on the quantity and helpfulness of submitted reviews. These badges are automatically calculated and applied daily.
    top ten contributor
    • Top contributor—This is the highest ranking contributor badge.
    • Top 10 contributor—Indicates the top 10 contributors of useful content.
    • Top 25 contributor—Indicates the top 25 contributors of useful content.
    • Top 50 contributor—Indicates the top 50 contributors of useful content.
    • Top 100 contributor—Indicates the top 100 contributors of useful content.
    • Top 250 contributor—Indicates the top 250 contributors of useful content.
    • Top 500 contributor—Indicates the top 500 contributors of useful content.
    • Top 1000 contributor—Indicates the top 1000 contributors of useful content.
  • Expert
    Highlights the reviewer has a high level of expertise or experience with your products or services.
    expert
Note: Badges have a default style that adheres to Bazaarvoice's design templates. However, your Account Administrator can customize the badge image that appears on your website to align with your company's brand and styling.

To highlight a product review that is particularly helpful to your consumers, you can mark it as featured. Featured reviews will have a Featured label both in the content management solution and on your website. There is no limit to the number of reviews you can feature.

Note: Only users assigned the Content Moderator role can mark reviews as featured. Refer to Users and Permissions.

To assign a featured badge to a review:

  1. Sign in to the Bazaarvoice Portal .
  2. From the navigation bar, select Ratings & Reviews > Reviews.
  3. Search or filter reviews to find the review you want to feature.
  4. Select View details to open the review.
  5. In the lower-left corner, switch on the Feature this review toggle.

feature review

Note: To remove the featured status from a review, switch off the Feature this review toggle.

The Featured label appears next to the Review ID.
featured label

Tip: To highlight featured reviews on your website, sort them to show Most Relevant or Featured reviews at the top. You can configure how you want to automatically sort reviews for your consumers, or how you allow consumers to sort reviews themselves. Refer to Review Sorting.
Tip: To list your featured reviews, select the Content filter then select Featured.

Incentivized reviews

You must inform consumers when reviews are incentivized. To highlight that a reviewer received an incentive in exchange for a review, you can add an Incentivized review icon and label. An incentive might include a free or discounted product or service, an entry into a sweepstakes, or loyalty reward points.

incentivized review
Tip: Online shoppers expect this level of transparency, and disclosing incentivized reviews helps build trust between consumers and your company.

Bazaarvoice is committed to content authenticity. We believe consumers have a right to trust the reviews they read. Refer to the Bazaarvoice Authenticity Policy for information about content authenticity guidelines.

Moderate reviews

All user-generated content (UGC) in the Bazaarvoice Network goes through a rigorous moderation process. Ratings & Reviews content management allows you to see the outcome of the Bazaarvoice moderation process for each collected review. You can see whether reviews were approved or rejected by Bazaarvoice, and the reasons why they were rejected. You can also approve reviews, apply moderation codes, and reject reviews if the content violates Bazaarvoice guidelines.

Note: To learn more about about content authenticity requirements, refer to the Bazaarvoice Authenticity Policy

Moderation status labels

Each review carries one of four moderation statuses: Approved, Rejected, Pending, or On-hold. These labels appear above the title of each review, both in the list view and in the detailed view. The date and time Bazaarvoice moderated the review are both shown alongside the moderation status label.

  • Approved—Either the Bazaarvoice moderation process has approved the review, or it has been approved in Ratings & Reviews by a member of your team. Content with this label is currently displayed on your site. If you have a distribution package, approved content is eligible for syndication to other sites in the Bazaarvoice Network.
  • Rejected—Either the Bazaarvoice moderation process has rejected the review, or it has been rejected in Ratings & Reviews by a member of your team. Content with this label is not currently displayed on your site. If you have a distribution package, rejected content is not eligible for syndication to other sites in the Bazaarvoice Network.
  • Pending—The UGC has not yet passed through the Bazaarvoice moderation process. Content with this label is not currently displayed on your site. If you have a distribution package, pending content is not eligible for syndication to other sites in the Bazaarvoice Network.
  • On-hold—The UGC has passed through the Bazaarvoice moderation process and has been officially approved. However, content with this label will not be displayed on your site immediately, but on a pre-determined release date.
Note: The Bazaarvoice moderation process can take up to 48 hours. If some of your reviews are labeled On-hold or Pending for more than 48 hours, it is likely a customized setting has been added to the moderation process for your UGC. To report unexpected delays in the moderation process, contact Bazaarvoice Support .

Moderation codes

Add moderation codes to indicate the specific reasons why you approved or rejected a review.

  • Reviews rejected by Bazaarvoice moderation will always be tagged with at least one moderation code.
  • You can add moderation codes to your reviews after you’ve read them and inspected any visual content.
  • Moderation codes are displayed in both the list view and the detail view.
Tip: To optimize your content management workflows, you can filter by selected moderation codes.

For more information about the moderation codes used for tagging reviews in the Bazaarvoice Network, learn about our moderation process.

Approve and reject reviews

You might want to check that the Bazaarvoice moderation process is working as you expected, and that content is being approved or rejected correctly. To do this efficiently, set up a custom filter to find the set of reviews you’re interested in.

Before deciding whether the UGC was moderated correctly, use your saved filter to:

  • Navigate through the reviews
  • Read the text
  • Inspect any visual content
Caution: If you approve or reject UGC, you must make sure your moderation decisions reflect high authenticity standards and support consumer confidence. Refer to the Bazaarvoice Authenticity Policy for more information about content authenticity requirements.
Note: To approve and reject reviews, you must be assigned the role of Account Administrator, Content Administrator, or Content Moderator. Learn more about Portal roles and capabilities.

Approve reviews

  1. Select either the review title or View details to open a review.
  2. Read the review and view any included visual content.
  3. (Optional) In the panel to the right of the review content, select Edit moderation codes, add any appropriate tags, and select Apply.
  4. Select Approve to approve a review for publication and syndication. Make sure you’ve viewed images and video content before approving a review.
Note: The locked moderation code Approved by Client (ABC) is applied automatically to show you approved content. Once applied, these moderation codes are permanently displayed with the review.
Tip: To optimize your workflow when moderating reviews, set up a custom filter that displays the set of reviews you want to explore.

Reject reviews

Caution: You cannot reject reviews simply to improve your product ratings as this would violate authenticity standards and lead to a loss of consumer confidence in your UGC.

There are some legitimate reasons to remove reviews from your site (and other sites if you have a Network distribution package). For example, you might need to remove reviews that refer to an older product version that’s no longer available.

To reject a review:

  1. Select either the review title or View details to open a review.
  2. Read the review and view any included visual content.
  3. (Optional) In the panel to the right of the review content:
    • Select Edit moderation codes and add a moderation code to indicate your reason for rejecting the review.
    • Under Internal notes, add a note to explain why you’re rejecting the review.
    • Select Apply.
  4. Select Reject to remove the review from your site. If your reviews are syndicated, the rejected review will no longer appear on any other sites within the Bazaarvoice Network.
Note: The locked moderation code Rejected by Client (RBC) is applied automatically to show that you rejected content. Once applied, these moderation codes are permanently displayed with the review in Ratings & Reviews.
Note: If you need to approve the review again, you can remove the assigned moderation codes and select Approve. However, reviews that have been approved or rejected by a client are permanently tagged as Approved by Client (ABC) or Rejected by Client (RBC). You can't remove these locked tags.

Export Ratings & Reviews content

Export your Ratings & Reviews content to help you analyze and better understand your consumer reviews. You can examine reviews from specific timeframes, specific product categories, or reviews with notably low ratings.

To export your Ratings & Reviews content, select one of the following three options:

  • Export CSV file—Download a CSV file directly from the Ratings & Reviews solution. Each row in an exported CSV file is an individual review. The CSV file has a maximum capacity of 100,000 reviews.
  • R&R Key Metrics report—Generate and download a CSV or XLSX file from the Reports solution.
  • Data Export list—Generate and download a CSV or XLSX file from the Reports solution. The Data Export list can contain up to 1,000,000 reviews.
Note: It can take up to 24 hours to generate the Key Metrics report and the Data Export list.

Best export option

Use this comparison table to work out which option best fits your needs.

Key benefits Export to CSV file
Ratings & Reviews
R&R Key Metrics report
Reports
Data Exports list
Reports
Find common trends across your reviews
Download a quick snapshot of reviews. Capped at 100,000 reviews
Download important key metrics about your reviews
In-depth analyses of your rating and reviews
Export a large data set of reviews. Capacity 1M reviews
Receive automated daily, weekly, or monthly reports
Customize report templates to analyze specific data points
Email shareholders directly
Download format CSV only CSV or XLSX CSV or XLSX
Note: To view or download a Data Exports or R&R Key Metrics report, shareholders and email recipients must have an active Portal account.

Learn more about R&R Key Metrics or Data Exports reports.

Export to CSV

Export a snapshot of your Ratings & Reviews content to a comma-separated value (CSV) file. Open the CSV file in a spreadsheet for analysis and share this information with colleagues. For example, you might want to download a list of reviews that received extremely low ratings.

Note: Each row in the downloaded CSV file represents one product review. The CSV file can contain up to a maximum of 100,000 reviews.

To export reviews:

  1. Select Export in the upper-right corner of the page.
    Tip: Before exporting, use filters to narrow the size and focus of your review list.
  2. Select Export to CSV. A progress spinner indicates that the download is in progress.
    Caution: Don’t navigate away from Ratings & Reviews during the download. You can continue working in the solution.
  3. When the export is complete, the CSV file is saved to your default downloads folder.
Note: The export file will be saved with a .CSV file extension. You can open it in a spreadsheet application, such as Microsoft Excel.

Watch this video for a quick walkthrough of exports.

CSV file

There are two types of column headers in the CSV file:

  • Fixed column headers—These column headers are static and will always appear in a specific order in the exported CSV file. They hold important information about each product review.
  • Dynamic column headers—These column headers can vary by review. As the CSV file is downloaded, these columns will be inserted dynamically to include any custom data relevant to product reviews.

Fixed CSV columns

The following fixed data is included in every Ratings & Reviews CSV file:

CSV column name Workbench column name Description
Review ID Review ID Unique identifier for a review
Submission date Submission Date Date the review was submitted
Initial publish date Initial Publish Date Date the review was published
Moderation status Moderation Status Accepted, Pending, or Rejected status
Content moderation codes Content Codes Moderation content codes. For example, Inappropriate Image (IMG)
Review title Review Title Title of a consumer review
Review text Review Text Contents of a review. For example, "Love my new sports watch! Happy with my purchase."
Overall rating Overall Rating The overall average rating for a product
Ratings-only review Is a Ratings-Only Review Reviews with a rating but no review text. Value: Yes or No
Product ID Product id Unique identifier for a product in your product catalog
Product name Product Name Name of product in your product catalog
Product status Not available in Workbench Status of product. Value: Active or Inactive
Product description Not available in Workbench Description of product
Product image URL Not available in Workbench URL or link pointing to the webpage hosting the product image
Product brand name Product brand Product brand. For example, Nike or Heinz
Category ID Category ID Unique identifier for a product category
Category name Category Name of product category. For example, Toys
Top level category Top Level Category Name of first product category in the category hierarchy. For example, in the hierarchy Women > Accessories > Watches, the top level category would be Women
Top level category ID Top Level Category ID Unique identifier for the top level product category. Hierarchy of product categories. For example, Food & Beverages > Beverages > Drink Mixes
Staff badge Staff Badge Shows whether the reviewer is employed by or affiliated with your company
Expert badge Expert Badge Shows the reviewer has a high level of experience with your products or services
Top contributor Merit Rank Shows the reviewer is a top contributor of useful content
Character count Not available in Workbench Shows how many characters are in both the review title and text combined
# Comments # of comments Total number of approved, rejected, and pending comments
# Approved comments # of Approved Comments Number of comments approved by moderation
# Pending comments # of Pending Comments Number of comments with the Pending status
# Rejected comments # of Rejected Comments Number of comments rejected by moderation
# Inappropriate votes # of Inappropriate Votes Number of inappropriate votes on approved reviews
# Helpful votes # of Helpful Votes Number of helpful or positive votes on approved reviews
# Not helpful votes # of Not helpful votes Number of unhelpful or negative votes on approved reviews
Would recommend Not available in Workbench Reviewers that answered Yes to the question "Would you recommend this product to a friend?". Value: Yes or No
Locale Locale Locale where the review was submitted
Display code Display Code Bazaarvoice display code used to show Ratings & Reviews content on product pages
Product page URL Product Page URL Link to the product page on your website
Campaign ID Campaign ID Unique number used to identify a product sampling campaign.
Featured review Featured Badge Indicates review contains helpful content. Review is highlighted with a Featured label
Incentivized review Incentivized Review Highlights that a reviewer received an incentive in exchange for this review
# Photos Not available in Workbench Number of attached photos for an approved review
# Videos Not available in Workbench Number of attached videos for an approved review
Video 1 Video 1 URL or link pointing to the webpage hosting the first product video
If multiple videos are submitted, additional dynamic headers like Video + number will identify each subsequent video
Note: If there are no videos associated with a batch of reviews, the Video column will not appear in the export file.
Photo 1 Photo 1 URL or link pointing to the webpage hosting the first product photo
If multiple photos are submitted, additional dynamic headers like Photo + number will identify each subsequent photo
Note: If there are no photos associated with a batch of reviews, the Photo column will not appear in the export file.
# Responses Not available in Workbench Number of responses to an approved product review
Client response 1 Client Response 1 Contents of a client’s first response to a review
Response department 1 Response Department 1 First department name entered when responding to a review
Response name 1 Response name 1 Public display name of individual who responded to an approved review
Consumer comment 1 Not available in Workbench First consumer comment associated with a review

Dynamic CSV columns

These columns in the CSV file can hold custom information collected from reviewers. For example, you can ask about the Quality, Value, or Ease of Use of a new coffee machine that you just launched.

The following are possible dynamtic headers included in a CSV file:

CSV column name Workbench column name Description
Custom question answers
aka Context Data Values (CDVs)
Custom questions Additional information about reviewers who use your products. For example, Gender, Age range, or Body type
Secondary product ratings Secondary ratings Optional star ratings that relate to different aspects of a product. Default qualities include Quality, Value, or Ease of use
Tag properties Tag properties Optional review tags such as sound, quality, or price
Note: Review tags are used to highligh product strengths (pros), weaknesses (cons), or notable features on your website.
Custom properties answers Custom properties Indicates reviewers’ product-specific issues. For example, Clothing fit, Durability, Appearance, and Usability
Product attributes Product attributes Product catalog attributes, such as Model number or ISBN
Video #2 Video #2 URL or link pointing to the webpage hosting the second and all other product videos
Photo #2 Photo #2 URL or link pointing to the webpage hosting the second and all other product photos

Workbench export versus Portal export

The following data is not available in Workbench export but is included in the Portal Ratings & Reviews export:

  • Product status
  • Product description
  • Product image URL
  • Would recommend
  • # Photos
  • # Videos
  • # Responses

The Portal Ratings & Reviews export currently does not include any of the following:

  • Reviewer contributor details. This data can be found in Portal > Reports.
  • Review authorization source
  • Review published email
  • Review commented email
  • Client comments (Internal notes in Manage Content)
  • # of comments with photo
  • # of comments with video
  • Originating domain
  • Session parameters
  • Response type 1
Note: We will continue to expand the export capacity in our future updates to provide an even better user experience.

Common export questions

Question: Why does my export stop when I leave the Ratings & Reviews page?
Answer: The export download may stop if you close the Ratings & Reviews page as this interrupts the reports generator connection. Make sure you keep the Ratings & Reviews tab open until the download finishes.

Question: Can I work in other tabs or apps while waiting for export download to complete?
Answer: Yes. You can also continue working in Ratings & Reviews. Make sure the Ratings & Reviews tab remains active until the export finishes.

Question: Why is the CSV export capacity limited to 100,000 reviews?
Answer: To make sure that this functionality consistently performs well, we’ve set a cap of 100,000 reviews for CSV exports. Workbench currently allows a maximum of 65,000 reviews.