Monday - edited 4 hours ago
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.
|
Column |
Description |
| Order ID | The unique identifier associated with the submitted order. |
| 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 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. |
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:
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.
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 |
| 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.