Reporting Overview Express en US
Enhanced Detailed Reports Overview (Express Version) Last Revised: September 27, 2013
Introduction This document is an overview of the reports found in the Enhanced Detailed Reports section of Reporting 2.0. Reports are grouped into categories according to the type of report. These reports are fully customizable and allow for personalized date ranges and subsets of data. All of the reports can be exported to a CSV, PDF or Excel (XLS) file.
“Level 1 Moderation” refers to the PowerReviews moderation process. “Moderation” is referencing the reviews’ status at Level 2
Moderation.
IMPORTANT All reports can be modified to include or exclude columns and can be filtered based on values such as date, review rating or product. There is a very informative tutorial video available on the Dashboard homepage that explains how to view and modify the reports. If you have any questions regarding the reports below, please visit our Support Portal from the Dashboard (Support ➤ Support Portal), where you can search Articles, search Answers, and ask questions.
Customer Reviews Reports This section describes the Customer Reviews-‐related reports.
PowerReviews Confidential
1
PowerReviews Confidential
Topline Folder n
Monthly Review Detail—Reviews by month and year. The average star rating for each month is also included. The report defaults to the last two years but can be customized to show any date range.
n
Daily Review Detail—Submitted review volume for each day. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last 30 days but can be customized to show any date range.
n
Category Reviews Detail—Monthly review volume by product subcategories reviewed. Also included is the average star rating for each product subcategory. The report defaults to the last three months but can be customized to show any date range.
n
Brand Reviews Detail—Monthly review volume by brands reviewed. Also included is the average star rating for each brand. The report defaults to the last three months but can be customized to show any date range.
n
Monthly Review Detail by Reviewer Type—Review volume by month and year. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last two years but can be customized to show any date range.
n
Weekly Review Detail—Review volume by week and year. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last three months, but can be customized to show any date range.
Alerts Folder n
Reviews by Alert Type—Count of reviews with different alert types by month. The three possible alerts are safety, product description errors, and customer service. The report defaults to the last 3 months but can be customized to show any date range.
n
Review Alert—Reviews tagged with an alert. The report defaults to the last 3 months but can be customized to show any date range.
n
Escalated Reviews by Reason Code—Escalated reviews and the review count by escalation reason. Furthermore, the report also details the percentage breakdown of each escalation reason. The report does not have a date range.
2 | Enhanced Detailed Reports Overview, Express
Last Revised: September 27, 2013
PowerReviews Confidential
Detailed Folder n
ALL REVIEWS—In-‐depth overview of each individual review. By default, each received review includes the following data: created date, review id, Level 1 moderation status (PowerReviews moderation), moderation status (your moderation at Level 2), page id, products name, review headline, review comments, review bottom line, review rating, review location, reviewer type and review nickname, merchant user email, email and merchant user id. The report defaults to the last 30 days but can be customized to show any date range.
n
APPROVED REVIEWS—Reviews approved by the PowerReviews moderation team. By default, each review includes the following data: created date, review id, page id, product name, review headline, review comments, review bottom line, review rating, review location reviewer type, review nickname, merchant user email, email and merchant user id. The report defaults to the last 30 days but can be customized to show any date range.
n
Category Tags—Usage of pre-‐populated tags on the Write a Review form. The tags are organized by the product root category (prod root), tag name, attribute order, submitted reviews and average rating of the review. The report defaults to the last 60 days but can be customized to show any date range.
Last Revised: September 27, 2013
Customer Reviews Reports | 3
Introduction This document is an overview of the reports found in the Enhanced Detailed Reports section of Reporting 2.0. Reports are grouped into categories according to the type of report. These reports are fully customizable and allow for personalized date ranges and subsets of data. All of the reports can be exported to a CSV, PDF or Excel (XLS) file.
“Level 1 Moderation” refers to the PowerReviews moderation process. “Moderation” is referencing the reviews’ status at Level 2
Moderation.
IMPORTANT All reports can be modified to include or exclude columns and can be filtered based on values such as date, review rating or product. There is a very informative tutorial video available on the Dashboard homepage that explains how to view and modify the reports. If you have any questions regarding the reports below, please visit our Support Portal from the Dashboard (Support ➤ Support Portal), where you can search Articles, search Answers, and ask questions.
Customer Reviews Reports This section describes the Customer Reviews-‐related reports.
PowerReviews Confidential
1
PowerReviews Confidential
Topline Folder n
Monthly Review Detail—Reviews by month and year. The average star rating for each month is also included. The report defaults to the last two years but can be customized to show any date range.
n
Daily Review Detail—Submitted review volume for each day. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last 30 days but can be customized to show any date range.
n
Category Reviews Detail—Monthly review volume by product subcategories reviewed. Also included is the average star rating for each product subcategory. The report defaults to the last three months but can be customized to show any date range.
n
Brand Reviews Detail—Monthly review volume by brands reviewed. Also included is the average star rating for each brand. The report defaults to the last three months but can be customized to show any date range.
n
Monthly Review Detail by Reviewer Type—Review volume by month and year. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last two years but can be customized to show any date range.
n
Weekly Review Detail—Review volume by week and year. The reviews are also broken down by reviewer type: Anonymous, Verified Buyer and Verified Reviewer. The report defaults to the last three months, but can be customized to show any date range.
Alerts Folder n
Reviews by Alert Type—Count of reviews with different alert types by month. The three possible alerts are safety, product description errors, and customer service. The report defaults to the last 3 months but can be customized to show any date range.
n
Review Alert—Reviews tagged with an alert. The report defaults to the last 3 months but can be customized to show any date range.
n
Escalated Reviews by Reason Code—Escalated reviews and the review count by escalation reason. Furthermore, the report also details the percentage breakdown of each escalation reason. The report does not have a date range.
2 | Enhanced Detailed Reports Overview, Express
Last Revised: September 27, 2013
PowerReviews Confidential
Detailed Folder n
ALL REVIEWS—In-‐depth overview of each individual review. By default, each received review includes the following data: created date, review id, Level 1 moderation status (PowerReviews moderation), moderation status (your moderation at Level 2), page id, products name, review headline, review comments, review bottom line, review rating, review location, reviewer type and review nickname, merchant user email, email and merchant user id. The report defaults to the last 30 days but can be customized to show any date range.
n
APPROVED REVIEWS—Reviews approved by the PowerReviews moderation team. By default, each review includes the following data: created date, review id, page id, product name, review headline, review comments, review bottom line, review rating, review location reviewer type, review nickname, merchant user email, email and merchant user id. The report defaults to the last 30 days but can be customized to show any date range.
n
Category Tags—Usage of pre-‐populated tags on the Write a Review form. The tags are organized by the product root category (prod root), tag name, attribute order, submitted reviews and average rating of the review. The report defaults to the last 60 days but can be customized to show any date range.
Last Revised: September 27, 2013
Customer Reviews Reports | 3
