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.
-
In the Stratifyd platform, we set up the Bazaarvoice data connector to filter and pull data.
-
Using the Bazaarvoice API, Stratifyd pulls data according to the date range and scheduling.
-
Stratifyd parses the data and caches it in MongoDB in the Epimetheus database.
-
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.
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.
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.