Use the historical reviews feed to import (migrate) pre-existing review data into Emplifi Ratings & Reviews.
Do not include syndicated reviews in this feed. For syndicated reviews, see Syndication .
If you are migrating content from Bazaarvoice or PowerReviews, see Migrating Reviews from Bazaarvoice or PowerReviews .
Emplifi Ratings & Reviews can accept the feed in these formats:
Header
Required
Description
SKU
Yes
The product SKU.
ID
Yes
A unique identifier for the review.
TITLE
Yes
Review title (optional, but preferred).
TEXT
Yes
Review text.
SUBMISSION TIME
Yes
The date the review was submitted in dd/MM/yyyy HH:mm:ss z format. For example: 23/12/2012 13:48:56 -0500.
RATING
Yes
The rating on a scale of 1-5.
USER NAME
Yes
A display name.
INCENTIVIZED
No
Use the incentivized column to indicate if the review was incentivized. This field accepts boolean values:
true or false
yes or no
1 or 0
MEDIA URL
No
Required if including visual content. URL for the visual content. If you have multiple visual content items to include, you can add additional columns as needed, such as MEDIA URL1, MEDIA URL2, etc.
CAPTION
No
Caption associated with the visual content.
MEDIA ID
No
Unique identifier for the visual content.
RESPONSE TEXT
No
Required if including review responses. Review response text. If you have multiple review responses, you can add additional columns as needed, such as RESPONSE TEXT1, RESPONSE TEXT2, etc.
RESPONSE USER NAME
No
The display name of the user who submitted the review response.
RESPONSE SUBMITTED DATE
No
Date the response was submitted.
For your reference, the following are samples of a reviews export XML file and the XSD file that defines the format.
tt_sample_reviews_feed.xml
<?xml version="1.0" encoding="UTF-8"?>
<reviewsFeed xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" site="Test Site v4.3" dateProduced="2016-03-24T13:29:44">
<itemReviewDimensionDefinitions>
<itemReviewDimensionDefinition>
<externalId>1</externalId>
<name>Rating Dimension - Required</name>
<label>Rating Dimension - Required</label>
<type>Ratings</type>
<required>true</required>
<categories>
<sku>3</sku>
<sku>19</sku>
<sku>1</sku>
<sku>9</sku>
</categories>
<itemReviewDimensionValueDefinitions>
<itemReviewDimensionValueDefinition>
<externalId>1</externalId>
<label xsi:nil="true"/>
<value>1</value>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>2</externalId>
<label xsi:nil="true"/>
<value>2</value>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>3</externalId>
<label xsi:nil="true"/>
<value>3</value>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>4</externalId>
<label xsi:nil="true"/>
<value>4</value>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>5</externalId>
<label xsi:nil="true"/>
<value>5</value>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValueDefinition>
</itemReviewDimensionValueDefinitions>
</itemReviewDimensionDefinition>
<itemReviewDimensionDefinition>
<externalId>3</externalId>
<name>Range</name>
<label>Range</label>
<type>Range</type>
<required>false</required>
<categories/>
<itemReviewDimensionValueDefinitions>
<itemReviewDimensionValueDefinition>
<externalId>11</externalId>
<label>One</label>
<value xsi:nil="true"/>
<sortOrder>0</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>12</externalId>
<label>Two</label>
<value xsi:nil="true"/>
<sortOrder>1</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>13</externalId>
<label>Three</label>
<value xsi:nil="true"/>
<sortOrder>2</sortOrder>
</itemReviewDimensionValueDefinition>
</itemReviewDimensionValueDefinitions>
</itemReviewDimensionDefinition>
<itemReviewDimensionDefinition>
<externalId>4</externalId>
<name>Single Select</name>
<label>Single Select Required</label>
<type>Single Select</type>
<required>true</required>
<categories/>
<itemReviewDimensionValueDefinitions>
<itemReviewDimensionValueDefinition>
<externalId>14</externalId>
<label>Attr 1</label>
<value xsi:nil="true"/>
<sortOrder>0</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>15</externalId>
<label>Attr 2</label>
<value xsi:nil="true"/>
<sortOrder>1</sortOrder>
</itemReviewDimensionValueDefinition>
</itemReviewDimensionValueDefinitions>
</itemReviewDimensionDefinition>
<itemReviewDimensionDefinition>
<externalId>5</externalId>
<name>Multi Select</name>
<label>Multi Select - Not Required</label>
<type>Multi Select</type>
<required>false</required>
<categories>
<sku>4</sku>
<sku>19</sku>
<sku>1</sku>
<sku>9</sku>
</categories>
<itemReviewDimensionValueDefinitions>
<itemReviewDimensionValueDefinition>
<externalId>16</externalId>
<label>Attribute 1</label>
<value xsi:nil="true"/>
<sortOrder>0</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>17</externalId>
<label>Attribute 2</label>
<value xsi:nil="true"/>
<sortOrder>1</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>18</externalId>
<label>Attribute 3</label>
<value xsi:nil="true"/>
<sortOrder>2</sortOrder>
</itemReviewDimensionValueDefinition>
<itemReviewDimensionValueDefinition>
<externalId>19</externalId>
<label>Attribute 4</label>
<value xsi:nil="true"/>
<sortOrder>3</sortOrder>
</itemReviewDimensionValueDefinition>
</itemReviewDimensionValueDefinitions>
</itemReviewDimensionDefinition>
</itemReviewDimensionDefinitions>
<profileAttributeDefinitions>
<profileAttributeDefinition>
<externalId>1</externalId>
<name>Profile Attribute</name>
<label>Select</label>
<type>Single Select</type>
<required>true</required>
<profileAttributeValueDefinitions>
<profileAttributeValueDefinition>
<externalId>1</externalId>
<label>One</label>
<value xsi:nil="true"/>
<sortOrder>0</sortOrder>
</profileAttributeValueDefinition>
<profileAttributeValueDefinition>
<externalId>2</externalId>
<label>Two</label>
<value xsi:nil="true"/>
<sortOrder>1</sortOrder>
</profileAttributeValueDefinition>
<profileAttributeValueDefinition>
<externalId>3</externalId>
<label>Three</label>
<value xsi:nil="true"/>
<sortOrder>2</sortOrder>
</profileAttributeValueDefinition>
</profileAttributeValueDefinitions>
</profileAttributeDefinition>
<profileAttributeDefinition>
<externalId>2</externalId>
<name>Free Form</name>
<label>Free Form</label>
<type>Freeform</type>
<required>true</required>
<profileAttributeValueDefinitions>
<profileAttributeValueDefinition>
<externalId>4</externalId>
<label>Free Form</label>
<value xsi:nil="true"/>
<sortOrder>0</sortOrder>
</profileAttributeValueDefinition>
</profileAttributeValueDefinitions>
</profileAttributeDefinition>
</profileAttributeDefinitions>
<reviews>
<review>
<sku>700285064826</sku>
<externalId>1</externalId>
<title>Review Title</title>
<text>Review Body. Review Body. Review Body. Review Body. Review Body. Review Body. Review Body. Review Body.</text>
<submissionTime>2016-03-24T08:09:50</submissionTime>
<rating>4</rating>
<hidden>true</hidden>
<user>
<externalId>23</externalId>
<firstName>John</firstName>
<lastName>RauchenbergerS</lastName>
<displayName>oyvey</displayName>
<emailAddress/>
</user>
<itemReviewDimensionValues>
<itemReviewDimensionValue>
<externalId/>
<label>Rating Dimension - Required</label>
<name>Rating Dimension - Required</name>
<value>3</value>
<valueLabel/>
<type>Ratings</type>
<sortOrder xsi:nil="true"/>
</itemReviewDimensionValue>
<itemReviewDimensionValue>
<externalId/>
<label>Range</label>
<name>Range</name>
<value/>
<valueLabel/>
<type>Range</type>
<sortOrder>1</sortOrder>
</itemReviewDimensionValue>
<itemReviewDimensionValue>
<externalId/>
<label>Single Select Required</label>
<name>Single Select</name>
<value/>
<valueLabel/>
<type>Single Select</type>
<sortOrder>0</sortOrder>
</itemReviewDimensionValue>
<itemReviewDimensionValue>
<externalId/>
<label>Multi Select - Not Required</label>
<name>Multi Select</name>
<value/>
<valueLabel/>
<type>Multi Select</type>
<sortOrder>1</sortOrder>
</itemReviewDimensionValue>
</itemReviewDimensionValues>
<profileAttributeValues>
<profileAttributeValue>
<label>Select</label>
<name>Profile Attribute</name>
<freeformText/>
<valueLabel>One</valueLabel>
<value/>
<type>Single Select</type>
<sortOrder xsi:nil="true"/>
</profileAttributeValue>
<profileAttributeValue>
<label>Free Form</label>
<name>Free Form</name>
<freeformText>freeform input</freeformText>
<valueLabel>Free Form</valueLabel>
<value/>
<type>Freeform</type>
<sortOrder xsi:nil="true"/>
</profileAttributeValue>
</profileAttributeValues>
</review>
</reviews>
</reviewsFeed>
reviewsfeed.xsd
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.turnto.com/reviewsfeed" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="reviewsFeed">
<xs:complexType>
<xs:sequence>
<xs:element name="itemReviewDimensionDefinition">
<xs:complexType>
<xs:sequence>
<xs:element name="itemReviewDimensionDefinition" maxOccurs="unbounded" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="externalId"/>
<xs:element type="xs:string" name="name"/>
<xs:element type="xs:string" name="label"/>
<xs:element name="categories">
<xs:annotation>
<xs:documentation>optional</xs:documentation>
</xs:annotation>
<xs:complexType>
<xs:sequence>
<xs:element name="sku" type="xs:string" maxOccurs="unbounded" minOccurs="0"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element type="xs:string" name="hidden"/>
<xs:element type="xs:string" name="required"/>
<xs:element name="itemReviewDimensionValueDefinitions">
<xs:complexType>
<xs:sequence>
<xs:element name="itemReviewDimensionValueDefinition">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="externalId"/>
<xs:element type="xs:string" name="label"/>
<xs:element type="xs:string" name="name"/>
<xs:element type="xs:string" name="value"/>
<xs:element type="xs:string" name="valueLabel"/>
<xs:element type="xs:string" name="type"/>
<xs:element type="xs:string" name="sortOrder"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="customProfileDimensionValues">
<xs:complexType>
<xs:sequence>
<xs:element name="customProfileDimensionValue">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="label" />
<xs:element type="xs:string" name="name" />
<xs:element type="xs:string" name="freeformText" />
<xs:element type="xs:string" name="valueLabel"/>
<xs:element type="xs:string" name="value"/>
<xs:element type="xs:string" name="sortOrder"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="reviews">
<xs:complexType>
<xs:sequence>
<xs:element name="review" maxOccurs="unbounded" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="sku"/>
<xs:element type="xs:string" name="externalId"/>
<xs:element type="xs:string" name="title"/>
<xs:element type="xs:string" name="text"/>
<xs:element type="xs:string" name="submissionTime">
<xs:annotation>
<xs:documentation>dd/MM/yyyy</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element type="xs:string" name="rating"/>
<xs:element type="xs:string" name="hidden">
<xs:annotation>
<xs:documentation>true|false</xs:documentation>
</xs:annotation>
</xs:element>
<xs:element name="user">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="externalId"/>
<xs:element type="xs:string" name="firstName"/>
<xs:element type="xs:string" name="lastName"/>
<xs:element type="xs:string" name="displayName"/>
<xs:element type="xs:string" name="emailAddress"/>
<xs:element type="xs:string" name="city"/>
<xs:element type="xs:string" name="state"/>
<xs:element type="xs:string" name="country"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="itemReviewDimensionValues" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="itemReviewDimensionValue" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="externalId"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="itemReviewProfileDimensionValues" maxOccurs="1" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="itemReviewProfileDimensionValue" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element type="xs:string" name="externalId"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute type="xs:string" name="site"/>
<xs:attribute type="xs:string" name="dateProduced"/>
</xs:complexType>
</xs:element>
</xs:schema>
