Data connector details

  • Category: Product Management
  • Connector type: Standard

Description

Use the Amazon Q&A connector to retrieve and analyze customer questions and answers on items sold on Amazon.

Data Limitations

This data connector supports all global Amazon web sites. There is no limit on this connector because there are generally not vast numbers of questions and answers for a product.

Input fields

When setting up the connector, provide the URL of the product or products for which you want to analyze customer reviews. 

  • Amazon Product URL (*required): On the Amazon 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.)

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.

AnswerAuthorName

  • Description: Returns the name of the answer author.
  • Category: user index
  • Example: Amazon Customer

AnswerDate

  • Description: Returns the date and time on which the answer was written.
  • Category: date index
  • Example: 1459382400000

AnswerText

  • Description: Returns the free-form text of the answer to the question.
  • Category: text index
  • Example: Unfortunately not, being a ginger, I would fear for your delicate skin against moon burn

crawler_time_stamp

  • Description: Returns the date and time on which the data was crawled.
  • Category: meta
  • Example: 1576011400750

DataSource

  • Description: Returns the data source of the question and answer.
  • Category: meta
  • Example: AmazonQA

HelpfulVotes

  • Description: Returns the number of people who found the answer helpful.
  • Category: meta
  • Example: 3

ProductID

  • Description: Returns the Amazon ID of the product the question is regarding.
  • Category: meta
  • Example: B007I4HI60

QuestionDate

  • Description: Returns the date and time on which the question was asked.
  • Category: date index
  • Example: 42460

QuestionID

  • Description: Returns the unique identifier of the question.
  • Category: meta
  • Example: Tx3TKHPU2H1R8T7

QuestionText

  • Description: Returns the free-form text of the question.
  • Category: text index
  • Example: Can a soulless ginger wear this shirt.

QuestionVotes

  • Description: Returns the number of votes marking the question as useful.
  • Category: meta
  • Example: 0

TotalVotes

  • Description: Returns the total number of votes for the answer, including those who voted that the answer was not helpful.
  • Category: meta
  • Example: 3

Data

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

Did this answer your question?