Bazaarvoice Portal provides three distinct methods for exporting review content. Choosing the right method ensures you get the most accurate results efficiently.
1. Which option best suits my needs?
|
Export method
|
Best for
|
Notes
|
|---|---|---|
| Export CSV file |
Quick, manual snapshots of your current list view.
|
Capped at 100,000 reviews for speed.
|
| R&R Key Metrics report |
Tracking performance trends and high-level KPIs.
|
|
| Download Reviews report |
Large-scale data analysis and raw data backups.
|
|
Learn more about R&R Key Metrics or Download reviews in our Reports solution.
Important considerations for reports
- Access: Report recipients must have an active Portal account to view or download reports.
- PII security: Users without PII permissions can view reports containing sensitive data but are restricted from downloading them.
- Data latency: Allow up to 48 hours for raw data and metrics to sync from the Portal to the Reports solution.
2. How to export to CSV
Export a snapshot of your Ratings & Reviews content to a comma-separated value (CSV) file.
To export reviews:
- From the List View, apply any filters to narrow the focus of your review list.
- Select the ellipses icon (...) in the upper-right corner,
- Select Export to CSV. A progress spinner will appear.
-
Once the export is complete, the file will be saved to your default Downloads folder.
3. CSV File Structure
The exported CSV contains two types of headers:
- Fixed headers: Static columns that always appear in the same order.
- Dynamic headers: Columns that vary based on your custom data (for example, specific custom questions or multiple photos)
Fixed CSV columns
The following fixed data is included in every Ratings & Reviews CSV file. To help you find data faster, we’ve grouped the fixed columns by category.
Review content and status
| 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 |
| Review title | Review Title | Title of a consumer review |
| Review text | Review Text | Contents of a review |
| Overall rating | Overall Rating | The 1–5 star score |
| Rating-only review | Is a Ratings-Only review | Yes/No |
| Character count | Character Count | Combined character count of title and text |
| Locale | Locale | Indicated which country the review originated from |
Product and category details
| CSV column name | Workbench column name | Description |
|---|---|---|
| Product ID / Product name | Product id / Product Name | Unique identifier and name for a product in your product catalog |
| Product status | Not available | Active or Inactive status |
| Product description | Not available | Description of product |
| Product image URL | Not available | Link to the product image webpage |
| Product brand name | Product brand | The brand associated with the product. For example, Nike or Heinz |
| Product page URL | Product page URL | The direct link to the product page on your website |
| Category ID/Category name | Category ID/Category | The specific category and its hierarchy |
| Top level category (ID) | Top Level Category (ID) | The highest category in the hierarchy (Women) |
| Display code | Display Code | The Bazaarvoice code used to display content on specific product pages |
Contributor badges and campaign details
| CSV column name | Workbench column name | Description |
|---|---|---|
| Staff badge | Staff Badge | Indicates the reviewer is a verified employee. |
| Expert badge | Expert Badge | Indicates the reviewer is a recognized expert. |
| Top contributor | Top Contributor | Indicates the reviewer is a top contributor of useful content. |
| Incentivized review | Incentivized review | Highlights if an incentive was given for the review. |
| Featured review | Featured badge | Indicates helpful content highlighted by a label. |
| Campaign ID | Campaign ID | Unique ID for a product sampling campaign. |
| Would recommend | Not available | Consumer answer to "Would you recommend this?". |
Engagement and moderation metrics
| CSV column name | Workbench column name | Description |
|---|---|---|
| # Comments | # of comments | Total number of approved, rejected, and pending comments. |
| # Approved comments | # of Approved Comments | Total comments approved by moderation. |
| # Pending/ #Rejected | # of Pending/# of Rejected | Counts for comments awaiting or denied approval. |
| # Inappropriate votes | # of Inappropriate Votes | Number of inappropriate flags on a review. |
| # Helpful votes | # of Helpful Votes | Number of positive votes from the community. |
| # Not helpful votes | # of Not helpful votes | Number of negative votes from the community. |
Dynamic CSV columns
Unlike fixed headers, Dynamic columns only appear in your export if the specific data exists for the reviews you have filtered. This keeps your spreadsheet clean by excluding empty data fields.
For example, a 'Quality' column will only appear in your export if your selected reviews actually contain data for that specific question. If no data exists, the column is excluded to keep your file concise.
| Portal column name | Workbench column name | Description |
|---|---|---|
|
Custom question answers
aka Context Data Values (CDVs) |
Custom questions | Additional data such as Gender, Age range, or Body type. |
| Secondary product ratings | Secondary ratings | Additional star ratings that relate to different aspects of a product such as Quality, Value, or Ease of use. |
| Tag properties | Tag properties | Review tags that are used to highlight product strengths (pros) and weaknesses (cons). For example, good fit, sound, quality, or price. |
| Custom properties answers | Custom properties | Product-specific issues. For example, Clothing fit, Durability, Appearance, and Usability |
| Product attributes | Product attributes | Specific data related to your product catalog such as Model number or ISBN |
| Video #2 | Video #2 | Contains a URL to additional media files. These columns are generated dynamically; for example, a "Video #3" column will only appear if a review in your export contains three or more videos. |
| Photo #2 | Photo #2 | Contains a URL to additional media files. These columns are generated dynamically; for example, a "Photo #3" column will only appear if a review in your export contains three or more images. |
4. Comparing Portal and Workbench exports
If you have migrated from legacy Workbench to Portal, please note the following differences in data availability.
New data in Portal exports
The Portal Ratings & Reviews CSV export includes several data points not available in legacy Workbench exports, mainly:
- Product details: Status, Description, and Image URL.
- Consumer sentiments: "Would recommend" values.
- Engagement stats: Total counts for # Photos, # Videos, and #Responses.
Current limitations
The following fields are currently unavailable in Portal exports.
| Category | Omitted fields |
|---|---|
| Contributor information | Reviewer details (ID/email). This data can be found in Portal > Reports |
| Email status | Review published email; Review commented email |
| Moderation | Moderation codes |
| Technical data | Review authorization source; Originating domain; Session parameters |
| Comment stats | # of comments with photos or videos; Response type 1; Internal client comments (Manage Content notes) |
5. Export FAQs
Why does my export stop when I leave the Ratings & Reviews page?
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.
Can I work in other tabs or apps while waiting for export download to complete?
Yes. You can also continue working in Ratings & Reviews. Make sure the Ratings & Reviews tab remains active until the export finishes.
Why is the CSV export capacity limited to 100,000 reviews?
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. If you need to export more than 100,000 reviews, please use the Download Reviews report in the Reports solution.
