Reviews Report – PowerReviews Help Center

The Reviews Report is your primary report view or download all or a specific set of reviews. It provides information in a tabular format for all reviews collected in the date period specified, providing individual reviews level insights such as Headline, Comments, Created Date, and Site Status.

The Reviews Report is customizable in a number of different ways:

There are a large number of filters available. The first four filters are along the top of the page. Clicking the plus sign button will expose additional filters. At any point, you can select new filters and click Apply to update the table based on the specified criteria.
Click Edit Columns on the right-hand side, just below Apply, to select and order what columns are shown.
To sort the table data based on a column, click any of the column headers in the table.

Filters

Filter Name	Description
Category	Filter by categories from your product feed.
Brand	Filter by the brand name of the reviewed product.
Page ID	Filter by page id associated with reviewed product. To search for multiple page ids, enter comma-delimited list.
Campaign ID	Filter by the campaign ID associated with a review. To search for multiple order ids, enter comma-delimited list.
Disclosure Code	Filter by the disclosure code to find reviews generated from a Sampling or Sweepstakes campaign.
In Stock Flag	Filter by the in stock status of the reviewed product from the product feed.
Is PWR Publishable	Filter by the publication status set by PowerReviews moderation team.
Location	Filter by the location submitted with the review using a keyword search.
Observations	Filter by the Observation reason code set by your team.
Order ID	Filter by the Order ID associated with the reviewed product. To search for multiple order ids, enter comma-delimited list.
Product ID	Filter by the product id associated with reviewed product. To search for multiple product ids, enter comma-delimited list.
Product Name	Filter by the name of the product associated with a review using a keyword search.
UPC	Filter by UPC associated with the displayed product from the product feed.
Review Bottomline	Filter by the answer to the question, 'Would you recommend this to a friend?'
Review Email	Filter by the email address associated with a review. To search for multiple emails, enter comma-delimited list.
Reviewer Type	Filter by the type of reviewer that submitted the review. For example, Anonymous, Verified Buyer, Verified Reviewer.
Review Comments	Filter reviews by keywords found in review comments using a keyword search. To search multiple words, enter comma-delimited list.
Rating Only	Filter reviews by the Ratings Only review status, where Ratings Only reviews have unpopulated review comments.
Review Rating	Filter by the star rating (1-5 stars) associated with the review.
Site Status	Filter by the publication status set by your team.
UGC ID	Filter by a specific UGC id. To search for multiple UGC ids, enter comma-delimited list.

Column Headers

The following table contains the columns available in this report. To edit which columns appear in the report, click Edit Columns above the report. You can also reorder columns using the drag and drop functionality.

Column Header	Description
Created Date	The date a review was submitted.
Product name	The name of the product attached to the submitted review.
Brand Name	The brand name of the reviewed product.
Page ID	The unique ID for the product passed in the product feed.
Review Rating	The star rating given on the review.
Review Headline	The headline of the review.
Review Comments	The comments on the review.
Review Bottomline	The answer to the question, 'Would you recommend this to a friend?'
Review Location	The location entered by the reviewer.
Locale	The language and country associated with the review.
Reviewer Type	The type of reviewer that submitted the review.
Review Email	The email address submitted with the review.
Review Nickname	The nickname submitted by the reviewer.
Site Status	The moderation status set by your team for L2 Moderation.
Is PWR Publishable	The moderation status set by PowerReviews Moderation Team.
Page ID Variant	The unique ID of the product variant for the reviewed product.
UGC ID	The ID of the user-generated content.
Badges	The type of icon that appears on the Review Display.
Campaign ID	The campaign ID passed to the Write-a-Review form at the time the review was submitted.
Campaign Hierarchy	A list of full hierarchy of campaigns.
Created Day of Week	The name of the day from the created date of the review.
Created Month	The name of the month from the created date of the review.
Created Month of Year	The month number from the created date of the review.
Created Quarter	The quarter number from the created date of the review.
Created Week	The week number from the created date of the review.
Created Year	The year number from the created date of the review.
Disclosure Code	The code stating if a specific review was associated with Sweepstakes or Sampling campaigns.
Helpful	The number of helpful votes on the review.
In Stock Flag	The in stock status of the reviewed product from the product feed.
Last Publication Modified Date	The date the review moderation status was set in L2 Moderation.
Last Publication Modified Month	The month number from the L2 moderated date of the review.
Last Publication Modified Year	The year number from the L2 moderated date of the review.
Manufacturer Model Number	The manufacturer model or part number of the reviewed product from the product feed.
Merchant Group	The name of the merchant group associated with the submitted review.
Merchant	The name of the merchant associated with the submitted review.
Merchant Response	The response given to the reviewer from the merchant for the submitted review.
Merchant User ID	The ID of the reviewer as passed in by the merchant via the Follow-Up Email.
Not Helpful	The number of not helpful votes on the review.
Images Published	The number of published images attached to the review.
Videos Published	The number of published videos attached to the review.
Images Submitted	The number of images submitted with the review.
Videos Submitted	The number of videos submitted with the review.
Observations Names	The explanation for status set by PowerReviews Moderators in L1 Moderation.
Observations	The explanation for status set by PowerReviews Moderators in L1 Moderation.
Observed By	The moderator associated with the setting L2 Moderation status.
Order ID	The order ID associated with the reviewed product.
Price	The price of the reviewed product.
Prod Root Category	The root category of the reviewed product
Prod Sub Category 1	The subcategory level 1 of the reviewed product.
Prod Sub Category 2	The subcategory level 2 of the reviewed product.
Prod Sub Category 3	The subcategory level 3 of the reviewed product.
Prod Sub Category 4	The subcategory level 4 of the reviewed product.
Prod Sub Category 5	The subcategory level 5 of the reviewed product.
Prod Sub Category 6	The subcategory level 6 of the reviewed product.
Promo Code	The promo code associated with the review.
Rating Only	A true/false value to indicate if the data is rating only, where the review comments would be unpopulated).
Review ID	The unique ID of the submitted review.
Service Comments	The service comments entered by the merchant on the submitted review.
Source	The source of the reviewer who wrote the review.
Type	The type of review (for example: full, quick).
UPC	The UPC associated with the reviewed product from the product feed.
Verified Reviewer Flag	The true or false flag for whether or not the review was written by a verified reviewer (ie., email has been provided).