Ratings-only schema version 14.7 example

Example schema version 14.7

The following is an example of a ratings-only export feed based on schema version 14.7. For more information about the elements in this schema, refer to the tables in ReviewStatistics, QAStatistics, and CommentStatistics.
Important: Bazaarvoice does not guarantee the casing of the <ExternalId> element in the Content Exports feed. Therefore, clients consuming this data should implement a case-insensitive ingestion process to ensure consistency.
Copy Code
XML
<?xml version="1.0" encoding="UTF-8"?>
<Feed xmlns="http://www.bazaarvoice.com/xs/PRR/SyndicationFeed/14.7" name="client_name" extractDate="2023-10-05T00:00:00.000Z">
   <Product removed="false" id="Product11">
      <ImageUrl>http://display.ugc.bazaarvoice.com/common/test/images/white_evening_primrose.jpg</ImageUrl>
      <Name>Oenothera speciosa</Name>
      <ExternalId>Product11</ExternalId>
      <Description>Pink evening primrose features fragrant, bowl-shaped, four-petaled, pink flowers (to 2-3" diameter) with yellow anthers that bloom from the upper leaf axils in late spring.</Description>
      <Brand>
         <ExternalId>sampleBrand</ExternalId>
         <Name>Flowers</Name>
         <Attributes>
            <Attribute id="NAME">
               <Value>Flowers</Value>
            </Attribute>
         </Attributes>
      </Brand>
      <Source>testcustomer-bulk-client-1</Source>
      <ProductPageUrl>http://en.wikipedia.org/wiki/Oenothera_speciosa</ProductPageUrl>
      <NativeReviewStatistics>
         <AverageOverallRating>4.8</AverageOverallRating>
         <OverallRatingRange>5</OverallRatingRange>
         <RatingsOnlyReviewCount>3</RatingsOnlyReviewCount>
         <RecommendedCount>5</RecommendedCount>
         <TotalReviewCount>5</TotalReviewCount>
         <AverageRatingValues>
            <AverageRatingValue id="Quality">
               <AverageRating>4.0</AverageRating>
               <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Quality">
                  <ExternalId>Quality</ExternalId>
                  <Label>Quality of Product</Label>
                  <Label1>How would you rate the quality of this product?</Label1>
                  <RatingRange>5</RatingRange>
               </RatingDimension>
            </AverageRatingValue>
            <AverageRatingValue id="Value">
               <AverageRating>5.0</AverageRating>
               <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Value">
                  <ExternalId>Value</ExternalId>
                  <Label>Value of Product</Label>
                  <Label1>How would you rate the value of this product?</Label1>
                  <RatingRange>5</RatingRange>
               </RatingDimension>
            </AverageRatingValue>
         </AverageRatingValues>
         <LocaleDistribution>
            <LocaleDistributionItem>
               <DisplayLocale>en_US</DisplayLocale>
               <ReviewStatistics>
                  <AverageOverallRating>4.8</AverageOverallRating>
                  <OverallRatingRange>5</OverallRatingRange>
                  <RatingsOnlyReviewCount>3</RatingsOnlyReviewCount>
                  <RecommendedCount>5</RecommendedCount>
                  <TotalReviewCount>5</TotalReviewCount>
                  <AverageRatingValues>
                     <AverageRatingValue id="Quality">
                        <AverageRating>4.0</AverageRating>
                        <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Quality">
                           <ExternalId>Quality</ExternalId>
                           <Label>Quality of Product</Label>
                           <Label1>How would you rate the quality of this product?</Label1>
                           <RatingRange>5</RatingRange>
                        </RatingDimension>
                     </AverageRatingValue>
                     <AverageRatingValue id="Value">
                        <AverageRating>5.0</AverageRating>
                        <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Value">
                           <ExternalId>Value</ExternalId>
                           <Label>Value of Product</Label>
                           <Label1>How would you rate the value of this product?</Label1>
                           <RatingRange>5</RatingRange>
                        </RatingDimension>
                     </AverageRatingValue>
                  </AverageRatingValues>
                  <RatingDistribution>
                     <RatingDistributionItem>
                        <RatingValue>4</RatingValue>
                        <Count>1</Count>
                     </RatingDistributionItem>
                     <RatingDistributionItem>
                        <RatingValue>5</RatingValue>
                        <Count>4</Count>
                     </RatingDistributionItem>
                  </RatingDistribution>
               </ReviewStatistics>
            </LocaleDistributionItem>
         </LocaleDistribution>
         <RatingDistribution>
            <RatingDistributionItem>
               <RatingValue>4</RatingValue>
               <Count>1</Count>
            </RatingDistributionItem>
            <RatingDistributionItem>
               <RatingValue>5</RatingValue>
               <Count>4</Count>
            </RatingDistributionItem>
         </RatingDistribution>
      </NativeReviewStatistics>
      <NumAnswers>11</NumAnswers>
      <NumNativeAnswers>11</NumNativeAnswers>
      <NumNativeQuestions>5</NumNativeQuestions>
      <NumQuestions>5</NumQuestions>
      <NumReviews>7</NumReviews>
      <ReviewStatistics>
         <AverageOverallRating>4.8571</AverageOverallRating>
         <OverallRatingRange>5</OverallRatingRange>
         <RatingsOnlyReviewCount>3</RatingsOnlyReviewCount>
         <RecommendedCount>7</RecommendedCount>
         <TotalReviewCount>7</TotalReviewCount>
         <AverageRatingValues>
            <AverageRatingValue id="Quality">
               <AverageRating>4.0</AverageRating>
               <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Quality">
                  <ExternalId>Quality</ExternalId>
                  <Label>Quality of Product</Label>
                  <Label1>How would you rate the quality of this product?</Label1>
                  <RatingRange>5</RatingRange>
               </RatingDimension>
            </AverageRatingValue>
            <AverageRatingValue id="Value">
               <AverageRating>5.0</AverageRating>
               <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Value">
                  <ExternalId>Value</ExternalId>
                  <Label>Value of Product</Label>
                  <Label1>How would you rate the value of this product?</Label1>
                  <RatingRange>5</RatingRange>
               </RatingDimension>
            </AverageRatingValue>
         </AverageRatingValues>
         <LocaleDistribution>
            <LocaleDistributionItem>
               <DisplayLocale>en_US</DisplayLocale>
               <ReviewStatistics>
                  <AverageOverallRating>4.8571</AverageOverallRating>
                  <OverallRatingRange>5</OverallRatingRange>
                  <RatingsOnlyReviewCount>3</RatingsOnlyReviewCount>
                  <RecommendedCount>7</RecommendedCount>
                  <TotalReviewCount>7</TotalReviewCount>
                  <AverageRatingValues>
                     <AverageRatingValue id="Quality">
                        <AverageRating>4.0</AverageRating>
                        <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Quality">
                           <ExternalId>Quality</ExternalId>
                           <Label>Quality of Product</Label>
                           <Label1>How would you rate the quality of this product?</Label1>
                           <RatingRange>5</RatingRange>
                        </RatingDimension>
                     </AverageRatingValue>
                     <AverageRatingValue id="Value">
                        <AverageRating>5.0</AverageRating>
                        <RatingDimension displayType="NORMAL" selectedValueInDisplayEnabled="false" id="Value">
                           <ExternalId>Value</ExternalId>
                           <Label>Value of Product</Label>
                           <Label1>How would you rate the value of this product?</Label1>
                           <RatingRange>5</RatingRange>
                        </RatingDimension>
                     </AverageRatingValue>
                  </AverageRatingValues>
                  <RatingDistribution>
                     <RatingDistributionItem>
                        <RatingValue>4</RatingValue>
                        <Count>1</Count>
                     </RatingDistributionItem>
                     <RatingDistributionItem>
                        <RatingValue>5</RatingValue>
                        <Count>6</Count>
                     </RatingDistributionItem>
                  </RatingDistribution>
               </ReviewStatistics>
            </LocaleDistributionItem>
         </LocaleDistribution>
         <RatingDistribution>
            <RatingDistributionItem>
               <RatingValue>4</RatingValue>
               <Count>1</Count>
            </RatingDistributionItem>
            <RatingDistributionItem>
               <RatingValue>5</RatingValue>
               <Count>6</Count>
            </RatingDistributionItem>
         </RatingDistribution>
      </ReviewStatistics>
      <CategoryItems>
         <CategoryItem id="sampleCategory">
            <ExternalId>sampleCategory</ExternalId>
            <CategoryName>Flowers Category</CategoryName>
            <CategoryId>707703608</CategoryId>
         </CategoryItem>
      </CategoryItems>
   </Product>
</Feed>