Use reports to quickly access, analyze, and share important metrics and improve key areas of your Bazaarvoice program.

Here are a few examples of what you can do with reports:

  • Track the ratings for a specific product, product category, or brand.
  • Provide executive-level performance summaries for multiple brands.
  • Inform your customer service team about reviews that moderators have tagged with customer service issues.
  • Alert your legal department about reviews that might contain legal liability issues.
  • Track Bazaarvoice moderation approvals and rejections.

Watch this video to learn more about working with Bazaarvoice reports.

Read the following information about creating and optimizing reports:

Required solutions and roles

To work with reports, you must be assigned the following solutions and roles.

You must have this solution: and one of these roles:
Reports
  • Reports Contributor
  • Reports Administrator
  • Account Administrator

Capabilities

The following table lists tasks and the roles needed to perform them.

Note: Unless specifically indicated, allowed actions apply to all reports created by any user in the same Bazaarvoice instance.
Task Reports Contributor Account Administrator
Reports Administrator
Create reports
View reports
Duplicate reports
Download reports
Edit reports report owner only
Delete reports report owner only

Learn more about how solutions and roles are assigned in the Bazaarvoice Portal.

Personally identifiable information

Reporting capabilities are further refined based on access to personally identifiable information (PII). The PII access permission setting grants active Portal users access to PII.

Note: An active Portal user is any email address associated with an active Bazaarvoice Portal (SSO) user account.

Refer to the following table for rules that apply to sending and receiving reports that contain PII.

  Who can send? Who can receive?
Report does not contain PII Any active Portal user with access to reports Any active Portal user
Report contains PII Any active Portal user with access to reports and PI access permission Any active Portal user with PII access permission

Users without PII access permission can see reports that contain PII in the list of reports, but cannot take action on them.

Redacted PII

The ability to view information contained in reviews, questions, answers, and comments that contain PII is restricted based on report sender and recipient permissions. If a sender or recipient does not have PII access permission and content is marked with the PII content moderation code, information contained in text and title fields may be redacted from R&R Export and Q&A Export reports.

Learn how to get PII access.

Get started with Reports

To view and manage reports:

  1. Sign in to the Bazaarvoice Portal .

    Note: If you cannot sign in, contact your Bazaarvoice Engagement Manager for assistance. Learn more about Portal permissions and user accounts.
  2. From the navigation bar, select Analytics.
  3. Select Custom Reports.
  4. If your company has more than one instance, use the instance selector (located near the upper-right corner) to move between them. Type the name or scroll through the list to select the one you want.

    The list refreshes to display reports associated with your selected instance.

Reports

Go to the Reports page to manage reports. It provides at-a-glance status information about current reports, including:

  • Creator email address
  • Date created
  • Run schedule (daily, weekly, monthly, or none)
  • Last run date

Sort reports

Select a column heading to sort the list by that column. Select the column heading again to change the sort order.

Search for reports

Use search field to locate a report by name or creator. Enter search information, then press Enter to search.

Action Menu

Select the Action Menu () to:

Note: Available actions depend on your assigned role and report availability. See Required solutions and roles for details about role-based capabilities and limitations.

Generate reports on demand

Select Generate from the Action Menu to generate reports at any time. Generating a report on demand does not impact its scheduled run days.

Create reports

Select + New report to create a report.

Each report begins with a template. Available templates differ depending on your implemented Bazaarvoice solutions.

Templates are grouped in two categories: product and program performance, and data exports.

Product and program performance templates

The R&R key metrics template returns summarized, calculated metrics to show how your Ratings & Reviews program is performing.

This template groups data by non-numerical fields you choose. For example, to create a report of data broken down by product, include the Product ID or Product Name attributes in the report. Alternatively, to see data aggregated by Brand or Category, add those attributes to the report and remove the Product ID and Product Name attributes. A third option would be to use Brand and Category to break down data and generate a report in which each row would show data by those attributes.

The following table describes the metrics available in this report template.

Metric Description
# Products Number of products, based on your current product catalog.
# Submitted reviews Number of reviews submitted directly by consumers. Excludes syndicated reviews and reviews flagged as inauthentic.
# Approved reviews Number of reviews that were collected directly from consumers and approved during moderation.
% Approved reviews Percentage of submitted reviews that were approved.
# Rejected reviews Number of reviews that were rejected during moderation.
% Rejected reviews Percentage of submitted reviews that were rejected during moderation.
Approved average rating Average rating of approved reviews.
% 1, 2, 3, 4, or 5-Star Percentage of approved reviews with a product rating of 1, 2, 3, 4, or 5 stars.
% Would recommend to a friend Percentage of approved native reviews that answered "Yes" to the question "Would you recommend this product to a friend?", divided by the total number of "Yes" and "No" responses.
Net promoter score Percentage of promoters minus the percentage of detractors. A widely-used metric for understanding consumer sentiment for a product, brand, or feature.
# Ratings-only reviews Number of approved reviews with a rating but no review text.
# Not helpful votes Number of not helpful votes on approved reviews.
# Helpful votes Number of helpful votes on approved reviews.
# Total helpfulness votes Number of helpful and not helpful votes on approved reviews.
# Inappropriate votes Number of inappropriate votes on approved reviews.
# Attached photos (total) Number of attached photos on approved reviews.
# Attached videos (total) Number of attached videos on approved reviews.
Average days to first response Average number of days from review published to response posted.
% Reviews with client response Percentage of approved reviews that have a client response.

The Q&A Key Metrics template returns summarized, calculated metrics to show how your Questions & Answers program is performing.

This template groups data by non-numerical fields you choose. For example, to create a report of data broken down by product, include the Product ID or Product Name attributes in the report. Alternatively, to see data aggregated by Brand or Category, add those attributes to the report and remove the Product ID and Product Name attributes. A third option would be to use Brand and Category to break down data and generate a report in which each row would show data by those attributes.

The following table describes the metrics available in this report template.

Metric Description
# Questions asked Number of questions asked on your site.
# Approved questions Number of questions approved by moderation.
% Approved questions Percentage of asked questions that were approved.
% Rejected questions Percentage of asked questions that were rejected.
# Questions answered Number of questions on your site that were answered.
% Questions answered Percentage of approved questions that were answered.
Average word count (Questions) Average word count of questions.
Question tags Company-specific tags per question.
# Total attached photos (Questions) Number of photos attached on approved questions.
# Total attached videos (Questions) Number of videos attached on approved questions.
# Helpful votes (Questions) Number of questions with helpful votes.
# Not helpful votes (Questions) Number of questions with not helpful votes.
# Helpful votes (Answers) Number of answers with helpful votes.
# Not helpful votes (Answers) Number of answers with not helpful votes.
% Helpful votes (Questions) Percentage of questions with helpful votes.
% Not helpful votes (Questions) Percentage of questions with not helpful votes.
% Helpful votes (Answers) Percentage of answers with helpful votes.
% Not helpful votes (Answers) Percentage of answers with not helpful votes.
# Total helpfulness votes (Questions) Number of helpful and not helpful votes on questions.
# Total helpfulness votes (Answers) Number of helpful and not helpful votes on answers.
% Questions that have brand answers Percentage of questions answered by brand.
% Approved answers Percentage of answers that were approved.
% Rejected answers Percentage of answers that were rejected.
Average word count (Answers) Average word count of answers.
# Total attached photos (Answers) Number of photos attached on approved answers.
# Total attached videos (Answers) Number of videos attached on approved answers.
# Best answer votes Number of answers on your site voted best answer.
Average days to first answer Average number of days from question published to answer posted.

Limited to users with access to more than one instance, this template offers key summary data of volume, coverage, and consumer sentiment across multiple instances.

To support data privacy, users cannot:

  • Create a Multi-instance R&R Key Metrics report that includes an instance they cannot access
  • Download, duplicate, edit, or delete Multi-Instance R&R Key Metrics reports that contain data for instances they cannot access

The following table describes the metrics available in this report template.

Metric Description
# Approved reviews Number of reviews collected directly from consumers and approved during moderation.
# Displayable reviews Number of reviews that are eligible to be displayed for the product(s). Includes approved native reviews, reviews shared within product families, and inbound syndicated reviews. Excludes reviews that were rejected in moderation.
# Submitted reviews Number of reviews submitted directly by consumers. Excludes syndicated reviews and reviews flagged as inauthentic.
# Syndicated reviews (inbound) Reviews syndicated to your site from the Bazaarvoice Network.
# Products Number of products, based on your current product catalog.
# Family shared reviews Reviews being shared with products by other products within the product family.
# Product page views Number of product pages viewed by consumers. Based only on pages where Bazaarvoice is installed and with Page View events. Page View events must include a product ID to be counted as a product page view.
% Product page views with reviews Percentage of product page views that displayed reviews for shoppers to view. A supplemental measurement of product coverage, which considers shopper viewership.
% Products with displayable reviews Percentage of products with reviews that could be displayed to shoppers. Commonly used to measure product coverage.
Approved average rating Average rating of approved reviews.
% 4+ Star reviews (Approved Native) Percentage of approved native reviews with a 4-star or 5-star rating.
% Would recommend to a friend (Approved Native) Percentage of approved native reviews that answered "Yes" to the question "Would you recommend this product to a friend?", divided by total number of "Yes" and "No" responses.
Net promoter score Percentage of promoters minus the percentage of detractors. A widely-used metric for understanding consumer sentiment for a product, brand, or feature.
% Promoters Number of NPS responses that are 9 or 10, divided by the total number of responses.
% Detractors Number of NPS responses that are 0 through 6, divided by the total number of responses.
% Products with 1, 2, 3, 4, or 5 stars (from displayable reviews) Percentage of products with product ratings from displayable reviews.
% Negative reviews not addressed by client Percentage of 3-star and below reviews without a response.

Limited to users with access to more than one instance, this template offers key summary data of how content syndicated from multiple instances has impacted Network destination review collection and matched product coverage.

To support data privacy, users cannot:

  • Create a Multi-Instance Network Impact report that includes an instance they cannot access
  • Download, duplicate, edit, or delete Multi-Instance Network Impact reports that contain data for instances they cannot access

The following table describes the metrics available in this report template.

Metric Description
# Network sources Number of Network sources matched to Network destinations via syndication.
# Network destinations Number of Network destinations matched to Network sources via syndication.
# Network destination products Number of products at Network destinations matched to products from your instance via syndication.
# Network destination reviews without syndication Number of reviews on Network destination products without syndication from the identified Network sources matched via syndication.
# Network destination reviews with syndication Number of reviews on Network destination products with syndication from the identified Network sources matched via syndication.
# Syndicated reviews (Outbound) Reviews syndicated from your instance(s) to other instances within the Bazaarvoice Network.
% Displayable reviews on matched Network destination products are syndicated reviews Percentage of outbound syndicated reviews to total displayable reviews at the Network destination.
% Network destination products with only syndicated reviews Percentage of Network destination products that only have reviews from your outbound syndication.

This limited-availability template is designed to help retailers make data-driven recommendations. These recommendations help vendors and brands improve their content and presence on the digital shelf.

To configure the report, add or remove fields and data such as Vendor Name and other custom product attributes that are important to your vendor management strategy. As with other reports, sorting and filtering the data allows you to improve focus and reduce report size.

The following table describes the metrics available in this report template.

Metric Description
# Products Number of products, based on your current product catalog.
# Products with displayable reviews Number of products with approved, displayable reviews.
% Products with displayable reviews Percentage of products with reviews that could be displayed to shoppers. Commonly used to measure product coverage.
% Products with approved reviews Percentage of products that have at least one approved review.
# Syndicated reviews (inbound) Reviews syndicated to your site from the Bazaarvoice Network.
# Approved reviews Number of reviews approved in moderation.
Approved average rating Average rating of approved reviews.
# Displayable reviews Number of reviews that are eligible to be displayed for the product(s). Includes approved native reviews, reviews shared within product families, and inbound syndicated reviews. Excludes reviews that were rejected in moderation.
# Approved questions Number of questions approved by moderation.
# Questions asked Number of questions asked.
# Questions answered Number of questions answered.
# Submitted answers (native) Number of submitted answers coming from a native source.
% Questions answered Percentage of questions answered.

Watch this video to learn more.

The Coverage Opportunity template highlights two key product metrics: number of product page views and number of displayable reviews. This comparison reveals how to improve product coverage by collecting reviews for products that need them most.

The following table describes the metrics available in this report template.

Metric Description
# Product page views Total number of product pages viewed by consumers. Based only on pages where Bazaarvoice is installed and with Page View events. Page View events must include a product ID to be counted as a product page view.
# Displayable reviews Number of reviews that are eligible to be displayed for the product(s). Includes approved native reviews, reviews shared within product families, and inbound syndicated reviews. Excludes reviews that were rejected in moderation.
Description Written representation of the product
Image URL Address of a webpage where the image is hosted.
Displayable average rating Average rating of approved, displayable reviews.

This template presents key engagement data to help you understand the performance of your review collection methods such as email notifications and review request email and text message campaigns.

The following table describes the metrics available in this report template.

Metric Description
# Sent Number of messages that were sent from Bazaarvoice systems.
# Delivered Number of messages that were successfully delivered to users’ inboxes.
% Delivered Percentage difference between the number of messages delivered and sent.
# Total opened Number of times that messages were opened at least once each hour.
% Total opened Open rate based on the number of times that messages were opened at least once each hour, divided by the number of messages sent.
# Unique opened Number of messages that were opened for the first time.
% Unique opened Percentage difference in the number of messages opened for the first time and the number of messages sent.
# Total clicked Number of times that messages with call-to-action (CTA) links that were clicked at least once each hour.
% Total clicked Click rate based on the number of times that messages with call-to-action links were clicked at least once each hour, divided by the number of messages sent.
# Unique clicked Number of messages with call-to-action (CTA) links that were clicked for the first time.
% Unique clicked Percentage difference between the number of messages with call-to-action links that were clicked for the first time and the number of messages sent.
# Total submitted Number of times that content was submitted at least once each hour.
% Total submitted Submit rate based on the number of times that content was submitted at least once each hour, divided by the number of messages sent.
# Unique submitted Number of messages that generated their first submission.
% Unique submitted Percentage difference between the number of messages that generated their first submission and the number of messages sent.
Unsubscribed Number of messages that included an “Unsubscribe” link clicked by users to unsubscribe from receiving future messages.
Bounced Number of messages that were not deliverable.
Complained Number of messages that caused users to complain. Users can complain by selecting “This is spam” in their email clients or by filing complaints with their email providers.

Apply filters to narrow the focus of your report. Filters available in this report:

  • Date range
  • Message type
  • Deployment zone
  • Locale

Group message engagement by device type and time of day/week to inform your review request campaign strategy and optimize performance. Dimensions available in this report include:

  • Message type (Default)
  • Device type
    Note: Sent and delivered metrics are not available when grouping data by device type.
  • Time of day
  • Day of week

This template shows how your ReviewSource program has impacted review volume, review coverage, and product ratings on your site during the previous 12 months.

The following table describes the metrics available in this report template.

Metric Description
Product name Name of product in your product catalog.
Product ID Identification number for product used across the Bazaarvoice Network.
Product status Product status, either active or inactive.
Brand name Name of brand.
Brand ID Universal brand ID for this brand.
Category name Name of category.
Category ID Category identification number used across the Bazaarvoice Network.
# Approved reviews (without ReviewSource) Total number of approved reviews without ReviewSource.
Approved average rating (without ReviewSource) Average rating of approved reviews without ReviewSource.
# Reviewsource reviews total delivered Total number of approved ReviewSource reviews delivered.
ReviewSource average rating Average rating of ReviewSource reviews.
# Displayable reviews (without ReviewSource) Total number of approved displayable reviews without ReviewSource.
# Displayable reviews (with ReviewSource) Total number of approved displayable reviews with ReviewSource.
Displayable average rating (without ReviewSource) Average rating of approved displayable reviews without ReviewSource.
Displayable average rating (with ReviewSource) Total number of approved reviews with ReviewSource.
% Change in review volume due to ReviewSource Percentage change in review volume due to ReviewSource.
% Change in average rating due to ReviewSource Percentage change in average rating due to ReviewSource.
# ReviewSource reviews delivered (Last 30 Days) Number of approved ReviewSource reviews delivered in the last 30 days.
# ReviewSource reviews delivered (Last 365 Days) Number of approved ReviewSource reviews delivered in the last 365 days.
Absolute change in review volume due to ReviewSource Numerical change in review volume due to ReviewSource.
Absolute change in average rating due to ReviewSource Numerical change in average rating due to ReviewSource.

This template returns aggregated data showing how the ReviewSource program has impacted review volume, review coverage, and product ratings for each site you syndicate to.

The following table describes the metrics available in this report template.

Metric Description
Network destination (Destination instance) Name of the destination site to which you syndicate reviews.
Destination product status Product status, either active or inactive.
# Approved native reviews at destination (without ReviewSource) Total number of approved native reviews at destination without ReviewSource
# Syndicated reviews at destination (without ReviewSource) Total number of syndicated reviews at destination without ReviewSource.
# ReviewSource reviews syndicated to destination Total number of ReviewSource reviews syndicated to destination.
ReviewSource average rating Average rating of ReviewSource reviews.
# Total syndicated reviews (with ReviewSource) Total number of syndicated reviews with ReviewSource.
# Total displayable reviews (without ReviewSource) Total number of displayable reviews without ReviewSource
# Total displayable reviews (with ReviewSource) Total number of displayable reviews with ReviewSource.
Displayable average rating (without ReviewSource) Average approved displayable reviews without ReviewSource.
Displayable average rating (with ReviewSource) Average approved displayable reviews with ReviewSource.
% Change in displayable review volume due to ReviewSource Percentage change in displayable review volume due to ReviewSource.
% Change in displayable average rating due to ReviewSource Percentage change in displayable average rating due to ReviewSource.
Absolute change in displayable review volume due to ReviewSource Numerical change in displayable review volume due to ReviewSource.
Absolute change in displayable average rating due to ReviewSource Numerical change in displayable average rating due to ReviewSource.
# Products Number of products, based on your current product catalog.
# Products with ReviewSource reviews Total number of products with ReviewSource reviews.
% Products with ReviewSource reviews Percentage of products with ReviewSource reviews.

This template returns aggregated data showing how the ReviewSource program has impacted review volume, review coverage, and product ratings for each product at each site you syndicate to.

By default, the report includes active and inactive products for the native and network product sets. To limit results to active products syndicating to active destination products, you must manually remove products from the report whose Product Status or Destination Product Status are Inactive.

The following table describes the metrics available in this report template.

Metric Description
Product name Name of product in your product catalog.
Product ID Identification number for product used across the Bazaarvoice Network.
Product status Product status, either active or inactive.
Product page URL Product display page URL.
Category Name of category.
Category ID Category identification number used across the Bazaarvoice Network.
Network destination (Destination instance) Name of the destination site to which you syndicate reviews.
Destination product name Name of product in the destination site product catalog.
Destination product ID Identification number for product in the destination site product catalog.
Destination product URL Product display page on the destination site.
Destination product status Product status on the destination site, either active or inactive.
Destination category Name of category on the destination site.
Destination category ID Category identification number on the destination site.
# Approved native reviews at destination (without ReviewSource) Number of approved native reviews at destination without ReviewSource.
# Syndicated reviews at destination (without ReviewSource) Number of syndicated reviews at destination without ReviewSource.
# ReviewSource reviews syndicated to destination Number of ReviewSource reviews syndication to destination.
ReviewSource average rating Average rating of ReviewSource reviews.
# Total syndicated reviews (with ReviewSource) Total number of syndicated reviews with ReviewSource.
# Total displayable reviews (without ReviewSource) Total number of approved displayable reviews without ReviewSource.
# Total displayable reviews (with ReviewSource) Total number of approved displayable reviews with ReviewSource.
% Change in displayable review volume due to ReviewSource Percentage change in displayable review volume due to ReviewSource.
% Change in displayable average rating due to ReviewSource Percentage change in displayable average rating due to ReviewSource.
Absolute change in displayable review volume due to ReviewSource Numerical change in displayable review volume due to ReviewSource.
Absolute change in displayable average rating due to ReviewSource Numerical change in displayable average rating due to ReviewSource.

Use this template to measure the impact of your sampling campaigns.

The following table describes the metrics available in this report template.

Metric Description
# Requested Number of sampling units requested.
# Shipped Number of sampling units shipped.
# Submitted reviews Number of reviews submitted by sampling recipients.
# Approved reviews Number of submitted reviews that were approved in moderation.
Approved average rating Average rating of approved reviews.
% Would recommend Percentage of reviews that answered "Yes" to the question "Would you recommend this product to a friend?", divided by total number of "Yes" and "No" responses.
# Total reviews with media Number of submitted reviews that contained media.
Description Written representation of the product.
Image URL Address of a webpage where the image is hosted.
Vendor name Name of suppliers or manufacturers who provide products to sample, ship products to members, or your in-house shipping team.
% Submitted return Rate at which the sampling campaign returned review submissions.
% Approved return Rate at which the sampling campaign returned approved review submissions.
# 1, 2, 3, 4, or 5-Star reviews Number of reviews submitted with a product rating of 1, 2, 3, 4, or 5 stars.
% 4-5 Star reviews Percentage of submitted reviews with a product rating between 4 and 5 stars.

The Conversion Impact Report e-Commerce reveals key information about the impact of Bazaarvoice content on your online business. This report describes the differences in purchasing behavior between visitors who interacted with Bazaarvoice content and those who did not, based on unique monthly visitors and a 3-day conversion attribution window. When a visitor completes a tracked order, the report attributes that order and its revenue to the highest engagement visit within three days of their initial visit to the product page.

This report is processed monthly and data is typically available on the sixth day of the following month. You cannot filter the report to a date range less than a full month, but you may combine metric performance data from multiple months into a single report.

The following table defines metrics included in the e-Commerce Conversion Impact Report.

Metric Description
Average Order Value (AOV)

Revenue divided by Orders.

Conversion Rate Orders divided by Visitors.
Goals Total non-transactional goals completed by Visitors, as tracked by the BV Pixel conversion event.
Lift Percent difference between Engaged and Did Not Engage.
Orders Total orders placed by Visitors, as tracked by the BV Pixel transaction event.
Revenue

Total revenue from Orders. This value is calculated by multiplying the price and quantity of each purchased item, as captured by the BV Pixel transaction event.

Note: Revenue for non-USD currencies is converted to USD on a nightly basis, using each day’s closing foreign exchange conversion rate. If no currency value is provided in the BV Pixel transaction event, the currency defaults to USD and no currency conversion occurs.
Revenue per Visitor Revenue divided by Visitors.
Visitors

Unique visitors calculated across pages where a Bazaarvoice display is installed and tracked with the BV loader.

The following table defines segments included in the e-Commerce Conversion Impact Report.

Segment Description
Actively Engaged Visitors who actively engaged with Bazaarvoice content by sorting, filtering, paginating, selecting, hovering, or highlighting within the Bazaarvoice container.
Did Not Engage Visitors who loaded a page with Bazaarvoice content but did not engage.
Engaged Visitors who selected, sorted, filtered, paginated, hovered, or scrolled to view Bazaarvoice content on screen.
No Content Available Visitors who loaded a page with a Bazaarvoice container that didn't contain UGC. For example, loading a product page that has no reviews.
Passively Engaged Visitors who viewed Bazaarvoice content on screen but did not actively engage with any functionality. This is tracked by the InView event.

Attribution window

When a visitor completes a tracked order, the CIR attributes that order and its revenue to the segment of highest engagement for the shopper within three days of their initial visit to the product page. These three days are known as the attribution window.

For example, a customer might look at reviews for a product one day but not purchase the product until the following day. This purchase falls within the window of time when Bazaarvoice attributes the purchase to the reviews that were read by the customer.

Report availability

New e-Commerce reports for the previous month typically are available the sixth day of the current month. This report availability schedule depends on a three-day attribution window that begins the first day of the current month, followed by two or three additional days for report data to be calculated and published to the dashboard.

For example, for May's monthly report the following dates apply:

  • June 1-3: Attribution window
  • June 4-5: Data processing
  • June 6: Report available
Notes:
  • Report processing begins June 4 at 12:00 AM Pacific Time, so the report typically would be available June 6 at 11:59 PM.
  • The report contains data from July 1, 2016 to present, assuming you passed the required BV Pixel event data during that time period.

Example monthly report

The following calendar illustrates the period of time captured in a monthly report.

 1  2  3  4  5  6  7
 8  9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31  1  2  3  4
 5  6

Key: Visitors and transactions |  Transactions only |  Data processing |  Report available

Visitor segmentation

The e-Commerce CIR assigns visitors, orders, and revenue to the segment of highest engagement for which the visitor met the criteria during the selected reporting window, for each product category and sub-category. As defined in the Definitions section, these segments are:

  • Actively Engaged
  • Passively Engaged
  • Did Not Engage
  • No Content Available

You can filter the reports by product category to better understand how products in each category compare with one another.

Example 1

A visitor named Skye browses multiple tracked pages in the same reporting window, but engages at a different level on each. The report will count her as only one visitor and assign her to the segment of highest engagement. If Skye passively engaged with Bazaarvoice content on March 15 and then actively engaged on March 19 (on a product in the same category), the monthly report for March would count her as one visitor in the Active segment.

Example 2

Date Action Analysis
Day 1: March 18, 12:08 PM Jane visits your website and browses the product page for "SUPER Speed Running Shoes." These shoes have Ratings & Reviews content. She scrolls down to read the content but does not actively select it (for example, she does not sort or filter the Ratings & Reviews). Jane decides to wait before making her purchase because she wants to do more research, so she does not place an order. Jane is considered a Passive visitor in the Shoes category because she did not actively interact with Bazaarvoice content.
Day 1: March 18, 2:23 PM Later that day, Jane decides to browse a different product: "Formula Fresh Laundry Detergent." This product also has Ratings & Reviews content. She notes the Rating Summary at the top of the page indicates the product has 721 reviews with a 4.5 average star rating. This information gives her the confidence to place an order without scrolling down to read or select Ratings & Reviews. Jane is considered a visitor in the Did Not Engage segment in the Laundry category because there was content on the page, but she did not engage with it passively or actively.
Day 1: March 18, 6:39 PM Later that evening, Jane decides to browse a third product, which is also in the Laundry category: "Amazing Scent Fabric Softener." This product does not yet have Ratings & Reviews content, but she decides to place an order for this product anyway, given the product requires a fairly low level of consideration. This action alone would put Jane in the No Content segment in the Laundry category.
Day 4: March 21, 9:32 PM Three days later, Jane comes back to research the "SUPER Speed Running Shoes" again. She scrolls down to the Ratings & Reviews content and, unlike her previous visit to the page, actively filters for only the 4-star reviews. She now decides she has enough information to make her purchase decision and places an order for the shoes. Jane is now considered an Active visitor in the Shoes category.

Example 3

Date Action Analysis
Day 7: March 24 7:28 AM Michael visits your website and browses the "XTREME Speed Running Shoes." These shoes have Ratings & Reviews content. He scrolls down to read the Ratings & Reviews but does not actively make a selection or place an order. Michael is considered a Passive visitor in the Shoes category.
Day 12: March 29, 10:43 PM Michael visits the "XTREME Speed Running Shoes" page again. This time, he sorts the reviews by Lowest Rated to Highest Rated and then places the order. Michael is now considered an Active visitor in the Shoes category.

Results and interpretation

Given the following:

  • Report accessed on: April 14
  • Date selected: March

If you filter for the Shoes category:

  • Two visitors and two orders are added to the Active segment.
  • Zero visitors and zero orders are added to Passive, Did Not Engage, and No Content.

This is because the CIR gives credit to the action (segment) of highest engagement during that timeframe. Even though Michael passively engaged on March 24, he actively engaged on March 29 before making his purchase.

The Conversion Impact Report non-Commerce (CIR) reveals key information about how engaged visitors are with Bazaarvoice content on your online business. This report tracks non-transactional conversion goals, based on a non-rolling, calendar-based, monthly attribution window. When a visitor completes a tracked goal, the report attributes the goal completion to the visitor's highest engagement visit occurring the same month as the goal completion.

This report is processed monthly and data is typically available on the second day of the following month. You cannot filter the report to a date range less than a full month, but you may combine metric performance data from multiple months into a single report.

The following table defines metrics included in the Conversion Impact Report non-Commerce.

Metric Description
Conversion Rate Goals divided by Visitors.
Goals Total non-transactional goals completed by Visitors, as tracked by the BV Pixel conversion event.
Visitors

Unique visitors calculated across pages where a Bazaarvoice display is installed and tracked with the BV loader.

The following table defines segments included in the non-e-Commerce Conversion Impact Report.

Segment Description
Actively Engaged Visitors who actively interacted with Bazaarvoice content by sorting, filtering, paginating, selecting, hovering, or highlighting within the Bazaarvoice container.
Did Not Engage Visitors who loaded a page with Bazaarvoice content but did not engage.
Engaged Visitors who selected, sorted, filtered, paginated, hovered, or scrolled enough to view Bazaarvoice content on screen.
No Content Available Visitors who loaded a page with a Bazaarvoice container but no UGC. For example, a product page that has no reviews.
Passively Engaged Visitors who viewed Bazaarvoice content on screen but did not actively interact with any functionality. This is tracked by the InView event.

Attribution window

The non-e-Commerce CIR uses a calendar-based, non-rolling monthly attribution window. When a visitor completes a tracked goal (a non-transactional conversion), the CIR attributes that goal completion to the segment of highest engagement for the shopper occurring in the same month as the goal completion.

Report availability

Reports are generated monthly. Reports for the previous month typically are available the third day of the current month.

For example, for May's monthly report the following dates apply:

  • June 1-2: Data processing
  • June 3: Report available
Notes:
  • Report processing begins June 1 at 12:00 AM Pacific Time, so the report typically would be available June 3 at 11:59 PM.
  • The report contains data from July 1, 2018 to present, assuming you passed the required BV Pixel event data during that time period.

Example monthly report

The following calendar illustrates the period of time captured in a monthly report.

 1  2  3  4  5  6  7
 8  9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31  1  2  3

Key: Visitors and transactions |  Transactions only |  Data processing |  Report available

Use this template to gauge the effectiveness of your responses to reviews and questions across retail destination sites.

The following table describes the metrics available in this report template.

Metric Description
# Approved reviews Number of approved reviews for your brand's products across retail sites in the Bazaarvoice Network.
# Approved 3-star (or) below reviews Number of approved reviews with a product rating of 3 stars or below.
# Approved reviews with responses Number of approved reviews that have responses on a retail site.
% Approved reviews with responses Percentage of approved reviews for your brand's products that have responses on any retail site.
Average days to first response Average number of days from review published to response posted.
% Reviews responded to first by brand Percentage of reviews with responses for which your brand contributed the first response.
% 3-star (or below) reviews without a response Percentage of reviews with a product rating of 3 stars or below that has not yet received a response.
# Approved questions Number of approved questions about your brand's products across retail sites in the Bazaarvoice Network.
# Questions with an answer Number of approved questions that have been answered on a retail site.
% Questions with an answer Percentage of approved questions about your brand's products that have been answered on any retail site.
Average days to first answer Average number of days from question published to answer posted.
% Questions answered first by brand Percentage of questions with answers of which your brand contributed the first answer.
% Questions marked "Can't Answer" Percentage of approved questions that were marked "Can't Answer."
% Questions answered by brand Percentage of approved questions that your brand answered.
Average days to brand answer Average number of days from question published to brand answer posted.

The Connections brand engagement template helps retailers understand how brands engage with R&R and Q&A content sent through Connections.

The following table describes the metrics available in this report template.

Metric Description
# Approved reviews Number of approved reviews on your retail site.
# Approved 3-star (or) below reviews Number of approved reviews with a product rating of 3 stars or below.
# Approved reviews with responses Number of approved reviews that have responses on your retail site.
% Approved reviews with responses Percentage of approved reviews that have responses on your retail site.
Average days to first response Average number of days from review published to response posted.
Average days to brand response Average number of days from review published to brand response posted.
% Reviews responded to by brand Percentage of reviews with a brand response.
% Reviews responded to first by brand Percentage of reviews with responses for which a brand contributed the first response.
% 3-star (or below) reviews without a response Percentage of reviews with a product rating of 3 stars or below that has not yet received a response.
# Approved questions Number of approved questions on your retail site.
# Questions with an answer Number of approved questions that have been answered.
% Questions with an answer Percentage of approved questions that have been answered on your retail site.
Average days to first answer Average number of days from question published to answer posted.
% Questions answered first by brand Percentage of questions with answers for which a brand contributed the first answer.
% Questions marked "Can't Answer" Percentage of approved questions that were marked "Can't Answer."
% Questions answered by brand Percentage of approved questions that a brand answered.
Average days to brand answer Average number of days from question published to brand answer posted.

The following filters are available in this template:

  • Date range
    • Content publish date
    • Response publish date
  • Products
    • Product
    • Product status
    • Product attributes
    • Brand
    • Category
    • Vendor ID

Dimensions available in this template include:

  • Product attributes
    • Product
    • Product ID
    • Product page URL
  • Catalog
    • Brand
    • Brand ID
    • Vendor ID
  • Custom product attributes
    • UPC
    • EAN

Data exports

These export templates provide native content data in raw, unaggregated format. Each row is an individual review, question, or answer. Select one of these templates to perform custom analysis of your Ratings & Reviews or Questions & Answers programs, and to share interesting data with others in your organization.

Select to export your product catalog. Configure the report to show data about all products, active products, or inactive products.

Use the report to identify areas of your catalog that are missing data. Then, pass the file to people in your organization who can fill in those gaps. You can also use the report to see category or brand IDs that Bazaarvoice may have generated for you.

Replaces the Connections Question Response report. Use this template to download raw network questions and answers data into a spreadsheet (.xlsx or .csv).

Replaces the Connections Review Response report. Use this template to download raw network ratings, reviews, and responses data into a spreadsheet (.xlsx or .csv).

Download raw, syndicated content tagged for mentions of adverse effects, legally sensitive information, or general legal interest.

Metrics

The following table describes the metrics available in this data export.

Metric Metrics Definitions
Instance Site receiving and displaying adverse and legally sensitive syndicated content.
Syndication Publication Date Date review was published on your site after syndication.
Product Name Name of product in your product catalog.
UPC Universal Product Code, a 6- or 12-digit bar code used for standard retail packaging in the United States.
Moderation Code Moderation codes are applied in the moderation process and detail the type of content mentioned in a product review. Options in this export are limited to Adverse Effects (AE), Legally Sensitive (LI), and General Legal Interest (NLI).
Review Rating Rating of the product review.
Review Title Title of the review.
Review Text Contents of the review i.e. "This product is great quality and I am happy with my purchase".
Reviewer Display Name Name of original reviewer on the source site.
Network Source Name of the source site sharing the syndicated content with your site.
Source Submission Date Date the review was submitted on the source site.
Brand Name Name of brand.
Brand ID Brand identifier as configured in your site's product catalog.
Category Name Name of category.
Category ID Category identifier as configured in your site's product catalog.

Filters

The following table describes the filters available in this data export.

Group Filter Description
Date Date Include data from the selected date range.
Instance Instance Include data from the selected site receiving and displaying adverse and legally sensitive syndicated content. You can include data from multiple instances.
Moderation Moderation Code Include data from content tagged with the selected moderation code. You can include data from multiple codes.
Products Product Status Include data from active and/or inactive products. Active data is selected by default.
Content Locale Include data from content collected from the selected locale. You can include data from multiple locales.

Follow these steps to create and customize a report from your selected template.

Step 1: What data do you want to see?

Select the data you want to include in your report. Use the arrow controls to move data from Available Metrics to Selected Metrics.

If you are editing a report, previously selected and saved metrics appear in Selected Metrics.

Tips:
  • Press Shift and select multiple metrics. Then use the arrow controls to move them as a set.
  • Scroll available report data or use the Search field to locate data to add to your report.
  • Drag data fields in Selected Metrics up or down to re-order their display in report output.

Step 2: How do you want it grouped?

This step applies only to product and performance reports.

Select Available Dimensions to determine how to group data in your report. Move one or more selections to Selected Dimensions.

Step 3: Narrow the size and focus

Use filters to quickly access common customizations:

  • Select or specify a date range for included report data
  • Select common report data to include in the report
  • Limit the report to specific product, brand, or category IDs
  • Limit the report to one or more product attributes
  • Limit the report by product status, moderation status, or moderation codes

Sort data

Use Sort by to further customize the report. Select up to three data fields on which to sort report output and a sorting direction (Low to High or High to Low).

Set row limits

Enter a value to limit the number of rows included in the report. Limiting the number of rows may improve report focus and reduce file size. The maximum (default) number of rows is 1,000,000.

Step 4: Set delivery options

Specify the report name, format, schedule, and email recipients.

Name the report

Enter a unique name for the report.

Tip: As your list of reports grows, naming your reports consistently will help you sort and locate them.

Select the report format

Select XLSX (Microsoft Excel 2007+) or CSV (plain text, double-quoted, comma-separated values).

If you select XLSX, optionally include report details in the report header. Details include the report name, date range, and other selected filters.

Schedule the report (optional)

Select daily, weekly, or monthly to run the report on a predetermined date.

Select recipients (optional)

By default, you will receive an emailed copy of your report each time it runs.

To send the report to another qualified recipient, enter a valid email address and select Add. Repeat this step for each intended recipient. Bazaarvoice sends qualified recipients an email notification that includes a link to download the report when available.

Note: Qualified email recipients include only email addresses associated with active Bazaarvoice Portal (SSO) accounts.

Run the report

When you have finished making selections, select Run report or Schedule report.

A message indicates that the report was successfully submitted, and the new report appears in the list. Generating… appears under the Action Menu to indicate the report is running.

Manage reports

Depending on your assigned capabilities, you can perform the following report management tasks:

Edit a report

Edit a report to change its name, included data, schedule, or delivery details.

  1. From Reports, select a report from the Report name column.
  2. Make changes as desired, and then select Save changes.

    Note: Changing a report name does not duplicate the report. Use the Duplicate feature to clone a report.

Download a report

After it generates successfully, a report is available for download. Make a selection from the Action Menu:

  • If a single report is available, select Download latest.
  • If two or more reports are available:

    • Select Download previous.
    • In Report history, select the report you want to download.

The report downloads to your default downloads directory.

Duplicate a report

To duplicate (clone) a report:

  1. From Reports, select Duplicate from the Action Menu in a report row.
  2. (Optional) Make changes as needed.
  3. Select Run Report or Schedule report.

    A message indicates that the report was successfully submitted, and the duplicated report appears. The Action Menu shows that the report is generating.

Delete a report

To delete a report:

  1. From Reports, select Delete from the Action Menu in a report row.
  2. In the dialog box that appears, select Delete to confirm.

Common questions

View the following questions and answers to better understand reporting features, details, and limitations.

Depending on your assigned roles, you may not be able to perform some tasks. For example, you may not be able to edit or delete reports that you didn’t create, or share reports with certain email recipients. Read more about capabilities.

Available templates differ depending on which Bazaarvoice solutions you have implemented.

No. Because users must accept the Terms of Use (displayed when enabling the PII Access permission), we cannot auto-assign PII Access to any users on your behalf. Users with the Account Administrator role and PII Access permission must grant PII Access permission to other users.

You may be excluded from reports containing personally identifiable data (PII). Find out why.

It depends on how much data is included in the report. Reports with large data sets may take up to 24 hours to run.

Reports expire 14 days after they are generated.

Typically it takes 48 hours before raw data and metrics are available in reports. For example, if a review is moderated, the data may not be available in our reporting systems for 24 hours. It can take another 24 hours before aggregated metrics can be built on that data.

Good use cases for this report include:

  • Performing custom analysis with Excel PivotTables, to conduct on-demand exploration and analysis of native Ratings & Reviews data.
  • Viewing native reviews collected during a specific time period, a specified product category, or another dimension.
  • Filtering for specific content codes. For example, your legal department might want to review data associated with content codes tagged “LI” for legal issues.
  • Discovering themes across reviews that reveal trends or quality issues.

Similar to the R&R Export template, the Q&A Exports template is appropriate for custom exploration and analysis.

Note: Data available from this template excludes Connections Premium content.

Begin typing in the Search box under Available metrics.

Select an item (Shift+select for multiple items), and then use the arrow controls to move it to My report.

The quality of data available from your product catalog directly impacts generated reports. For more information, read Why is the product catalog important?

Portal reports typically provide improved features compared to legacy Workbench reports. The following table lists Workbench reports and the Portal reports nearest in functionality:

Workbench Analyst Report Portal Report
All Reviews Report R&R Export
All Reviews by X Report R&R Key Metrics
All Questions & Answers Report Q&A Export
All Questions & Answers by X Report Q&A Key Metrics

Troubleshooting

The following information may help if you encounter errors when using reports.

You may receive this error when opening Microsoft Excel Windows 10 Pro or Windows 7. Follow these instructions to resolve the issue.

You may receive this error if your computer does not have sufficient memory or processing speed to open a large Excel file. Try running the report with a smaller data set. If that's not an option, try running it from a computer with more RAM or a faster processor.