Schema Information for Reviews.io

Need help with something?

Talk to data expert

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 Documentationhttps://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