Data connector details

  • Category: Survey/Chat
  • Connector type: API

Description

Use the Bazaarvoice connector to retrieve and analyze customer review data.

Data flow

To get Bazaarvoice data into the Stratifyd platform, the data goes through a series of steps.

  1. In the Stratifyd platform, we set up the Bazaarvoice data connector to filter and pull data.
  2. Using the Bazaarvoice API, Stratifyd pulls data according to the date range and scheduling.
  3. Stratifyd parses the data and caches it in MongoDB in the Epimetheus database.
  4. The Bazaarvoice data connector pulls the cached data from the Epimetheus database in MongoDB.If the data connector was set up to schedule recurring data crawls, the connector automatically checks Bazaarvoice for new data and pulls it periodically.

API limitations

Please note that the Bazaarvoice API imposes some limitations on the amount of data that you can pull. For the most up-to-date information, see API Rate Limit on the Bazaarvoice Developer site. Stratifyd uses the GET method of these two endpoints:

  • /data/reviews.json
  • /data/reviewcomments.json

If you have issues with pulling data, try narrowing your date range on the scheduling page of the wizard.

Input fields

When setting up the connector, you log into your Bazaarvoice account and filter your results by survey.

  • Bazaarvoice API Key: Copy and paste in a read-only access API key which you can find here: https://developer.bazaarvoice.com/apps/mykeys
  • Category: Select the review category to analyze. (This field populates after a valid API key is supplied.)

You can change your date range on the Schedule 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. It also detects and includes all of your custom survey fields.

AuthorId

  • Description: Identification number of the author.
  • Category: user index

bazaarvoice_key

  • Description: Bazaarvoice key.
  • Category: meta

CampaignId

  • Description: Identifier for the campaign.
  • Category: meta

ContentLocale

  • Description: ISO country and locale code of the language used, e.g. en_US.
  • Category: meta

DataSource

  • Description: Name of the data source, e.g. bazaarvoice.
  • Category: meta

Date

  • Description: Date and time of the review.
  • Category: date index

Helpfulness

  • Description: Value between 0 and 1 to rate helpfulness.
  • Category: KPI

Id

  • Description: Unique identifier for each record.
  • Category: meta

IsFeatured

  • Description: Value indicating whether the review is featured.
  • Category: meta

IsRatingsOnly

  • Description: Value indicating whether the review contains only ratings and no text.
  • Category: meta

IsRecommended

  • Description: Value indicating whether the review is recommended by peers.
  • Category: meta

IsSyndicated

  • Description: Value indicating whether the review is syndicated.
  • Category: meta

LastModeratedTime

  • Description: Date and time on which the review was last moderated.
  • Category: date index

LastModificationTime

  • Description: Date and time on which the review was last modified.
  • Category: date index

ModerationStatus

  • Description: Status set by the moderator, e.g. APPROVED.
  • Category: meta

ProductId

  • Description: Identifier for the product reviewed.
  • Category: meta

Rating

  • Description: Numerical rating of the product.
  • Category: KPI

RatingRange

  • Description: Range of the numerical rating, e.g. 5.
  • Category: meta

Review

  • Description: Free-form text of the review.
  • Category: text index

SecondaryRatings.CUSTOMVALUE*.DisplayType

  • Description: Display type information for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.Id

  • Description: Identifier for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.Label

  • Description: Label for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.MaxLabel

  • Description: Maximum value for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.MinLabel

  • Description: Minimum value for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.Value

  • Description: Numerical rating for any secondary ratings that you set up.
  • Category: KPI

SecondaryRatings.CUSTOMVALUE*.ValueLabel

  • Description: Numerical rating label for any secondary ratings that you set up.
  • Category: meta

SecondaryRatings.CUSTOMVALUE*.ValueRange

  • Description: Range of the numerical rating, e.g. 5.
  • Category: meta

SecondaryRatingsOrder

  • Description: CUSTOMVALUE from each of your secondary ratings in order.
  • Category: meta

SubmissionId

  • Description: Unique identifier for the submission.
  • Category: meta

SubmissionTime

  • Description: Date and time on which the review was submitted.
  • Category: date index

Title

  • Description: Free-form text title of the review.
  • Category: text index

TotalCommentCount

  • Description: Number of comments on the review.
  • Category: meta

TotalFeedbackCount

  • Description: Number of times the reviewer has submitted feedback.
  • Category: meta

TotalNegativeFeedbackCount

  • Description: Number of times the reviewer has submitted negative feedback.
  • Category: meta

TotalPositiveFeedbackCount

  • Description: Number of times the reviewer has submitted positive feedback.
  • Category: meta

UserLocation

  • Description: Reviewer's location.
  • Category: geo index

UserNickname

  • Description: Reviewer's nickname.
  • Category: user index

Data

  • Description: Returns all of the data including custom fields.

* The actual value of the custom secondary rating appears in the field name, and another set of these fields appears for each custom secondary rating.

Did this answer your question?