Reviews
Returns all product or content reviews collected in the account, including author and rating details.
Select
The provider uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the provider.
- 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). |