cancel
Showing results for 
Search instead for 
Did you mean: 
CommunityMod_WM
Community Manager
Community Manager

Follow-Up Email (FUE) Order Analytics provides order- and product-level visibility into review solicitation activity. Use the Order Data tab in the existing FUE analytics experience to understand which products were eligible for a review request, whether an email was sent, and whether a review was received. 

At a glance: Each row represents one product for one Campaign ID. An order with multiple products or multiple campaigns will appear across multiple rows. 

 

Understand How the Report is Organized

  • Each product in an order appears on a separate row for each Campaign ID.
  • Order-level information, including Order ID and email address, is repeated when an order has multiple product or campaign rows.
  • Campaign- and product-specific details and statuses can differ across rows in the same order.
  • Rows with the same Order ID are grouped together to make multi-product orders easier to review.
  • First-send Campaign IDs use fue-m, while second-send Campaign IDs use fue-second-m. 

 

Report Columns 

Column

Description 

Order ID The unique identifier associated with the submitted order.
Email The email address associated with the order.
First Send Campaign ID The unique identifier associated with the first send email batch.
Second Send Campaign ID
The unique identifier associated with the second send email batch.
Order Date The date associated with the original order.
First Send Date The date the first follow-up email was sent.
Second Send Date The date the second follow-up email was sent.
UGC ID The identifier associated with submitted user-generated content, when available.
Page ID The catalog Page ID associated with the product.
Product Image URL The URL of the image associated with the product.
Product Name The name of the product included in the order.
Page ID Variant The product variant identifier associated with the Page ID, when applicable.
Status The current product-level solicitation or review status. See the status definitions below.
Review Received Date The date a review was collected for the order.
Blocked Indicates that the solicitation email was not sent because the recipient address was unsubscribed or on a blocked list.

 

Status Definitions

Status is determined at the product level. Products within the same order can therefore have different statuses. 

Status or Reason

What Does it Mean?

Rating Only A customer submitted a rating without a written review. If a second review request is enabled, the customer will still receive the second request to encourage a complete written review.
Incomplete product information The product is missing information required to send a review request, such as a Page ID, product name, or image URL.
Queued The product is eligible for a review request. Required product information is available, no review has been received, and a review request has not yet been sent.
Email sent A review request email was sent for the product, but a review has not yet been received.
Review written A review was received within the configured review expiration window.
Not Sent - Processing Issue The review request could not be sent because of a temporary processing issue.
Send Pending - Retrying The review request was not successfully processed during the initial send attempt. The system will automatically retry the request.
Not Sent - Products Ineligible The review request was not sent because none of the products in the order were eligible for review. Products may be missing from the product catalog or may contain information that prevents inclusion.
Not Sent - No Eligible Products The review request was not sent because no products remaining in the order were eligible for review.
Not sent - blocked recipient The review request was not sent because the recipient is on the blocked recipient list.
Other The record does not meet the criteria for any other defined status or reason.

 

Identifying Missing Product Information

The Order Data report can be used to determine whether review request emails were not sent because PowerReviews does not have the required product information for one or more products in an order.

To find these records:

  1. Open the Order Data tab and use the Status filter to select the relevant product statuses Incomplete product information and Not Sent - Products Ineligible.
  2. Review the Page ID, Product Name, Page ID Variant, and Product Image URL columns for the affected products to see which information is missing. Products may be missing from the product catalog or lack a Page ID, product name, or image URL.
  3. Use the Order ID, Campaign ID, or Product Name search options to narrow the results to specific orders or products.

Required action: If emails were not sent for this reason, you will need to update your product feed so that PowerReviews has complete product information (including Page ID, product name, and image URL) for the affected products. Once the product feed has been updated, future orders containing those products will be eligible for review requests.

 

Search and Filter the Report

Use the available search and filter criteria to locate relevant order and product records. Orders matching the selected criteria are returned in the report. 

Search Option

Expected Behavior

Email Find orders associated with an email address.
Order ID Find a specific order by its identifier.
Product Name Find orders containing a product whose name includes the entered value. For example, searching for “ick” returns a product named “pickles.”
Page ID Find products whose Page ID includes the entered value.
Page ID Variant Find products using the associated variant identifier.
Campaign ID Find records associated with a campaign.
Date Range Limit results to a selected date range.
Status Filter records by selecting a status from the dropdown.
UGC ID Find records using the identifier associated with submitted user-generated content.
Send Date Find or filter records by the date the follow-up email was sent.
Order Date Find or filter records by the date associated with the original order.
Review Received Date Find or filter records by the date a review was collected.

Export the report to save the selected results and review them offline.

Version history
Revision #:
5 of 5
Last update:
4 hours ago
Updated by:
 
Contributors