Data connector details

  • Category: Product Reviews
  • Connector type: Standard

Description

Use the Tmall Reviews connector to retrieve and analyze customer feedback on items sold on https://www.tmall.com.

Data limitations

This data connector supports only products beginning with detail.tmall.com, and not any of the other countries or sites to which it may redirect, e.g. detail.tmall.hk or chaoshi.detail.tmall.com.

Tmall does not impose limitations on the amount of data that you can pull, but for products with a very large number 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.

  • Tmall Product URL: On the Tmall 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 versions of the product 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: To avoid returning too much data, 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.

CmsSource

  • Description: Data source of the review.
  • Category: meta
  • Example: 天猫

Country

  • Description: Country in which the product was sold.
  • Category: geo index
  • Example: China

crawler_time_stamp

  • Description: Date and time on which the review was crawled.
  • Category: meta
  • Example: 1580395263837

DataSource

  • Description: Data source of the review.
  • Category: meta
  • Example: Tmall

Date

  • Description: Date and time on which the review was written.
  • Category: date index
  • Example: 1562661456000

IsAliMallSeller

  • Description: Value indicating whether the reviewer is a seller.
    (True when the comment is a response.)
  • Category: meta
  • Example: FALSE

IsAnonymous

  • Description: Value indicating whether the reviewer elected to remain anonymous.
  • Category: meta
  • Example: TRUE

IsFromMall

  • Description: Value indicating whether the reviewer is from Tmall.
  • Category: meta
  • Example: TRUE

IsGoldUser

  • Description: Value indicating whether the reviewer is a gold member of Tmall.
  • Category: meta
  • Example: TRUE

IsUseful

  • Description: Value indicating whether the reviewer finds the product useful.
  • Category: KPI
  • Example: TRUE

ProductCategory

  • Description: Category identification number of the product reviewed.
  • Category: meta
  • Example: 50000671

ProductID

  • Description: Tmall ID of the product reviewed.
  • Category: meta
  • Example: 592561228762

ProductInfo

  • Description: Size, color, style, or other info about the reviewed product.
  • Category: meta
  • Example: 主要颜色:水彩黄色;尺码:S

ProductName

  • Description: Tmall product name of the product reviewed.
  • Category: meta
  • Example: 妖精的口袋v领短袖t恤女2019夏季新款宽松显瘦纯色百搭打底衫上衣

ProductPrice

  • Description: Price of the product reviewed.
  • Category: meta
  • Example: 89

ProductReviewCount

  • Description: Total number of reviews left for the product.
  • Category: meta
  • Example: 21

ProductSubtitle

  • Description: Product seller’s slogan.
  • Category: meta
  • Example: 全场正品 假一赔十 领卷购物更优惠

Review

  • Description: Free-form text of the review.
  • Category: text index
  • Example: 尺码:喜欢的颜色没码数了,不过质量好,价格实惠,就收下了其它颜色了。还是挺不错的、。

SellerID

  • Description: Tmall ID number of the seller.
  • Category: meta
  • Example: 2040944974

SellerName

  • Description: Name of the seller.
  • Category: meta
  • Example: elfsack致客专卖店

UserName

  • Description: Reviewer’s name.
  • Category: user index
  • Example: f***3

Data

  • Description: Adds all output fields to a list visualization.

Did this answer your question?