Ratings & Reviews content management

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

• Quick search or filter reviews
• Respond to consumer reviews
• Approve reviews
• Reject
• Export to CSV

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:

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.

Quick search

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.

• 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

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 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: Approved Rejected Pending Expired
	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

Note: Saved filters will appear in a drop-down list in the upper-left corner of the list view.

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: If you select a time period from the Date filter, it will show data for that specific time period from the date you created the filter. For example, if you select Last 30 days on January 30, 2024, your personal filter will show data from January 1, 2024 to January 30, 2024.
   

Note: The filter drop-down will be greyed out if there aren't any saved filters.

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.
   

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:

—Review title —View details

The detail view

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

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

Navigate between reviews

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:

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.

Respond 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.

   

   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.

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.
  

• 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 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.
  

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.

Featured reviews

To highlight a product review that is particularly helpful to your consumers, you can mark it as . 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.

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.

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.

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 overview

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.

Note: It’s best practice to accept the moderation codes applied by Bazaarvoice moderators. However, if your Account Administrator has assigned you the relevant permissions, you can apply or overwrite moderation codes.

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.

With the Ratings & Reviews content management solution, you can:

• View which reviews were rejected by Bazaarvoice, and the reasons why
• Approve reviews
• Reject reviews

Note: Learn more about about the Bazaarvoice Authenticity Policy

Check Bazaarvoice moderation process

Bazaarvoice recommends checking that the moderation process is working as you expect and that your content is being approved or rejected correctly.

Caution: When you approve or reject UGC, you must make sure your moderation decisions reflect our authenticity standards and support consumer confidence. Refer to the Bazaarvoice Authenticity Policy for details of our authenticity standards.

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

• Navigate through the reviews
• Read the text
• Inspect any visual content

Roles and permissions

To approve or reject reviews, you must be assigned the:

• Ratings & Reviews solution
• Account Administrator, Content Administrator, or Content Moderator Portal role

Learn more about Portal roles and capabilities.

Moderation status labels

Each review carries one of five moderation status labels: Approved, Rejected, Pending, Expired, or On hold.

• Status labels appear above the title of each review, both in the list view and in the details view.
• The date and time Bazaarvoice moderated the review are also shown alongside the status label.

Status	Description
	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.
	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 reviews are not eligible for syndication to other sites in the Bazaarvoice Network.
	The review has not yet gone 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.
	The review was once approved and displayed, but has been removed at your request. Content can expire for several reasons. One reason is that the product has significantly changed, making older reviews irrelevant. Another reason is that you prefer to display the most current reviews so consumers see the most relevant product feedback. Note: To request the Expired status be applied to a review, you need to submit a case through Bazaarvoice Support .
	The review has gone through the Bazaarvoice moderation process and been officially approved. A review 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

If you choose to self-moderate reviews, add moderation codes to indicate the specific reasons why you approved or rejected a review.

Guidelines

• 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 details view.
• You cannot moderate an expired review.
• Once rejected, syndicated reviews will no longer appear on other sites within the Bazaarvoice Network.

Tip: To optimize your content management workflows, you can filter by selected moderation codes.

Learn more about our moderation codes and process.

Approve or reject reviews (List view)

You can approve or reject a review from the list view or the details view.

Caution: You should not reject bad reviews to improve your product ratings. This would be violating authenticity standards and reduce consumer confidence in your UGC.

To approve or reject a review from the list view:

1. Select Moderation details on any review. The Moderation details modal appears.

   

2. (Optional) Select either Approved or Rejected.
3. (Optional) Select the relevant moderation codes to indicate your reasons for rejecting or approving a review.
   Note: You can add or update moderation codes without having to update the moderation status.
4. Select Save. The moderation status updates to Approved or Rejected and the moderation timestamp is also updated.

Note: A locked moderation code, either Approved by Client (ABC) or Rejected by Client (RBC), 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.

Approve or reject reviews (Details view)

Caution: You cannot reject reviews simply to improve your product ratings. This could violate authenticity standards and reduce consumer confidence in your UGC.

Method 1: To approve or reject a review

• To approve a review, select Approve in the upper-right corner above the review title.
  
  Note: The moderation status badge updates to Approved and the moderation timestamp is also updated.
• To reject a review:
  • Select Reject in the upper-right corner above the review title. The Moderation details modal appears.
    
  • (Optional) Select the appropriate moderation codes to indicate your reasons for rejecting a review.
  • Select Save.
  • The moderation status badge updates to Rejected. The moderation timestamp also updates (whether you add moderation codes or not).

Note: A locked moderation code, either Approved by Client (ABC) or Rejected by Client (ABC), is applied automatically to show you approved content. Once applied, these moderation codes are permanently displayed with the review.

Method 2: To approve or reject a review

Note: You can add new moderation codes without having to update the moderation status.

1. Select Edit moderation codes. The Moderation details modal appears.
   

   • To approve a review, select the Approved status.
   • To reject a review, select the Rejected status.
2. (Optional) Select the appropriate moderation codes to indicate your reasons for approving or rejecting a review.
3. Select Save.

Note: A locked moderation code, either Approved by Client (ABC) or Rejected by Client (ABC), is applied automatically to show you approved content. Once applied, these moderation codes are permanently displayed with the review.

Note: If your reviews are syndicated, rejected reviews will no longer appear on any other sites within the Bazaarvoice Network.

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, Rejected, Pending, or Expired
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 Note: If multiple client responses are submitted, additional dynamic headers like Response + Number will identify each subsequent response.
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
Client response #2	Client response #2	Contents of a client’s second response to a review.

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
• Moderation codes
• 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.