Schema Information for Reviews.io
Schema Information for Reviews.io
In this article, we will look at the schema information of the supported APIs and tables for Reviews.io.
Find the links to other articles related to Reviews.io Below:
Tables/APIs Supported
The tables and APIs associated with the Reviews.io connector are as follows.
Product Invitations
Purpose: Product invitations data in Reviews.io helps track review requests, analyze response rates, improve product feedback, engage customers post-purchase, and boost product credibility through authentic reviews.
Source API Documentation: https://developer.reviews.io/reference/8a271887dfaa1745743d09259387ab25
Replication Type: Two Step
| Field Name | Data Type |
| id | NUMERIC |
| order_id | STRING |
| customer_name | STRING |
| customer_email | STRING |
| email_sent | STRING |
| status | STRING |
| date_send | DATETIME |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
| product | RECORD |
Review Statistics
Purpose: Reviews statistics data provides insights into customer feedback trends, overall satisfaction, product performance, and helps build trust by showcasing ratings and reviews summaries.
Source API Documentation:
https://developer.reviews.io/reference/4ed25ac3b91ef153711c3484103dea68
Replication Type: Two Step
| Field Name | Data Type |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
| product_review_stats | RECORD |
| company_review_stats | RECORD |
| third_party_review_stats | RECORD |
Reviews & Questions
Purpose: Reviews & Questions data captures customer feedback and inquiries, helping businesses understand customer opinions, address concerns, improve products, and build trust with potential buyers.
Source API Documentation: https://developer.reviews.io/reference/899f58c2c4431ec1000ec59a38b2916b
Replication Type: Two Steps
| Field Name | Data Type |
| id | STRING |
| type | STRING |
| type_label | STRING |
| source | STRING |
| rating | NUMERIC |
| title | STRING |
| comments | STRING |
| nps | NUMERIC |
| date_created | DATETIME |
| time_ago | STRING |
| order_id | STRING |
| sku | STRING |
| product_name | STRING |
| helpful_count | NUMERIC |
| tags | STRING |
| product_review_id | NUMERIC |
| verified | NUMERIC |
| store_review_id | NUMERIC |
| photos | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
| author | RECORD |
| photos_raw | RECORD |
Product Ratings
Purpose: Product Ratings data reflects customer satisfaction scores, helping showcase product quality, build trust, and guide purchase decisions.
Source API Documentation:
https://developer.reviews.io/reference/5d09bb17e6720187be9bc35432a5deeb
Replication Type: Two Step
| Name | Data Type |
| sku | STRING |
| average_rating | STRING |
| num_ratings | NUMERIC |
| name | STRING |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
