Reviews
Returns all product or content reviews collected in the account, including author and rating details.
Select
The add-in uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the add-in.
- Id supports the operators: =, IN
- Verified supports the operator: =
- ReviewType supports the operator: =
- Rating supports the operators: =, IN, >=, <=
- Content supports the operator: CONTAINS
For example, the following queries are processed server-side:
SELECT * FROM Reviews
WHERE Id IN ('review-id-1', 'review-id-2', 'review-id-3')
SELECT * FROM Reviews
WHERE Rating >= 3
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the review record in Klaviyo. | |
| String | The email address of the individual who authored the review. | ||
| Verified | Bool | Indicates whether the review is verified, meaning Klaviyo has confirmation that the customer purchased the reviewed product. | |
| ReviewType | String | Specifies the type of review. Supported values include question, rating, review, and store. | |
| Created | Datetime | The date and time when the review was created, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| Updated | Datetime | The date and time when the review was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | |
| Images | String | A list of URLs pointing to images submitted with the review. If no images were included, this field is an empty list. | |
| Rating | Int | The numeric rating given in the review, on a scale from 1 to 5. This field is null if the review type is question. | |
| Author | String | The name of the author who submitted the review. | |
| Content | String | The main body text or written content of the review. | |
| Title | String | The title or headline of the review, summarizing the reviewer's feedback. | |
| SmartQuote | String | A short highlighted quote extracted from the review that summarizes its key content. | |
| StatusValue | String | The current moderation or publication status of the review. | |
| StatusRejectionReason | String | The reason the review was rejected, if applicable. Possible values include predefined moderation categories. | |
| StatusRejectionReasonExplanation | String | Additional explanation provided when the rejection reason is classified as other. | |
| ProductExternalId | String | The external identifier of the product associated with the review, as stored in an external system. | |
| ProductImageUrl | String | The URL of the product image associated with the reviewed product. | |
| ProductName | String | The display name of the product being reviewed. | |
| ProductUrl | String | The URL directing to the product's page where the review was submitted. | |
| PublicReplyAuthor | String | The author of the public reply to the review, typically a store representative or moderator. | |
| PublicReplyContent | String | The content of the public reply associated with the review. | |
| PublicReplyUpdated | Datetime | The date and time when the public reply was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). |