Historical Reviews Feed
If you have pre-existing review data and plan to migrate the user generated content over to Emplifi Ratings & Reviews, we will need to have the information below. This is an optional feed.
If you are migrating content from Bazaarvoice or PowerReviews, see Migrating Reviews from Bazaarvoice or PowerReviews.
If you are syndicating reviews to Bazaarvoice, be aware that Emplifi Ratings & Reviews cannot syndicate imported reviews to Bazaarvoice.
Feed formats
Emplifi Ratings & Reviews can accept the feed in these formats:
Tab-delimited text file (preferred)
Microsoft Excel (
.xlsx)CSV
XML
Supported data fields
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 |
RATING | Yes | The rating on a scale of 1-5. |
USER NAME | Yes | A display name. |
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. |
Examples
For your reference, the following are samples of a reviews export XML file and the XSD file that defines the format.
XML Sample reviews feed
tt_sample_reviews_feed.xml
CODE
<?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>XSD Sample reviews feed
reviewsfeed.xsd
CODE
<?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>