Data connector details
-
Category: Product Reviews
-
Connector type: Standard
Description
Use the Rakuten Reviews connector to retrieve and analyze product reviews on Rakuten's Japanese web site.
Valid URLs begin with https://item.rakuten.co.jp.
Data Limitations
Rakuten does not impose limitations on the amount of data that you can pull, but for products with a lot of reviews, you may want to limit it yourself using the Comment Limit option or by narrowing the date range.
If you have issues with no data, try widening your date range on the second page of the wizard.
Input fields
When setting up the connector, provide the URL of the product or products for which you want to analyze customer reviews.
-
Rakuten Product URL (*required): On the Japanese Rakuten web site, navigate to the product and from the address bar, copy the URL, then paste it into this field.
-
Add new search: To analyze multiple product varieties or multiple products, click this as many times as needed to add more URLs.
-
Upload: Click to upload a file containing a list of product URLs. Takes a TXT file with one URL per line.
(CSV is also acceptable, but it must have one URL per line.) -
Comment Limit: It is a good practice to set a limit on the number of comments returned.

You can change your date range on the second page of the wizard, or optionally Schedule data crawls to update your data stream periodically.
Data dictionary
This connector returns the following fields that you can use in analysis.
Country
-
Description: Reviewer's country.
-
Category: geo index
-
Example: Japan
crawler_time_stamp
-
Description: Date and time on which the review was crawled.
-
Category: meta
-
Example: 1580311908325
DataSource
-
Description: Source of the data.
-
Category: meta
-
Example: Rakuten
Date
-
Description: Date and time that the review was published.
-
Category: date index
-
Example: 1577577600000
HelpfulCount
-
Description: Number of users who found the review helpful.
-
Category: meta
-
Example: 0
IsBuyer
-
Description: Value indicating whether the reviewer is a verified purchaser of the product.
-
Category: meta
-
Example: TRUE
ProductID
-
Description: Rakuten product ID for the reviewed item.
-
Category: meta
-
Example: 193359_10062685
ProductNumber
-
Description: Rakuten product number for the reviewed item
-
Category: meta
-
Example: 151064
ProductTitle
-
Description: Full text of the product title description.
-
Category: meta
-
Example: 【お一人様3個まで】bon moment レジかごバッグ 買い物カゴにピッタリはまるレジカゴバッグ 保冷 大容量 折りたたみ/ボンモマン
ProductURL
-
Description: URL of the product on Rakuten.
-
Category: meta
-
Example: https://item.rakuten.co.jp/angers/151064/
PurchaseQuantity
-
Description: Value indicating whether the reviewer was a repeat buyer of the product or a first-time buyer.
-
Category: meta
-
Example: はじめて
Rating
-
Description: Reviewer's star rating of the product.
-
Category: KPI
-
Example: 4
Review
-
Description: Free-form text of the review.
-
Category: text index
-
Example: 今まで使用した中でいちばんしっかりしています。折り畳み状態がもう少しコンパクトになれば大満足です。
ReviewTitle
-
Description: Free-form text title of the review.
-
Category: text index
-
Example: しっかりしています
ReviewURL
-
Description: URL of the review.
-
Category: meta
-
Example: https://review.rakuten.co.jp/item/1/193359_10062685/1ceb-i0tq7-aeg5c_1_810241292/
SellerReply
-
Description: Free-form text of any reply to the review by the seller.
-
Category: text index
SellerReplyDate
-
Description: Date and time of the seller's reply.
-
Category: date index
SellerReplyTitle
-
Description: Free-form text title of the seller's reply.
-
Category: text index
UserAge
-
Description: Age of the reviewer.
-
Category: meta
UserName
-
Description: Name of the reviewer.
-
Category: user index
UserSex
-
Description: Sex of the reviewer.
-
Category: meta
Data
-
Description: Adds all output fields to a list visualization.
Further questions?
We're here to help! Don't hesitate to contact us for further assistance via chat or submit a ticket!
Comments
0 comments
Please sign in to leave a comment.