Crawlsmith

Bazaarvoice & PowerReviews Reviews + Q&A Scraper

Reviews, Q&A and rating summaries from any shop on Bazaarvoice or PowerReviews: Target, Home Depot, Sephora, Costco, Lowe's, Boots, Argos, MediaMarkt, Ulta and thousands more. Paste a product URL; filter by stars, date, language, photos, verified buyers; only-new mode.

What it does

This scraper automatically collects structured, ready-to-use review data from any shop that uses Bazaarvoice or PowerReviews. No manual browsing, no copy-paste — paste product links and hit Start.

Three ways to tell it what to scrape:

  1. Product URL Mode — paste product page links from any supported shop. The shop, its review account and the product are recognised automatically.
  2. Direct Mode — name the shop's review account (e.g. targetcom) and a list of product IDs.
  3. Catalogue Search — type a keyword (e.g. airpods) and scrape the most-reviewed matching products of a shop.

Who uses it

Use Case How It Helps
Brand & product managers See what buyers say about your products at every retailer, side by side with competitors
Market researchers & analysts Build review datasets across shops and countries for sentiment, feature and trend analysis
Customer care & quality teams Get every new 1–2 star review the day it appears and react before it hurts sales
AI & data science teams Feed thousands of real, star-labelled product opinions into models and dashboards
E-commerce sellers Find the questions shoppers ask before buying and the problems they report after
Competitive intelligence Track rating distribution and review velocity of rival products over time

Input

38 options. Required ones are marked.

Option What it does
Product page URLs Product pages of any shop or brand site that shows Bazaarvoice or PowerReviews ratings, e.g. Target, Home Depot, Sephora, Costco, Lowe's, Macy's, Sam's Club, JCPenney, Boots, Argo…
Bazaarvoice account (instead of URLs) The shop's Bazaarvoice account name, e.g. "targetcom", "homedepot", "sephora", "boots", "argos", "mediamarkt".
Bazaarvoice site locale Locale of the account's site, e.g. en_US (default), en_GB, de_DE, fr_FR, en_CA.
Bazaarvoice site (zone) Deployment zone of the account.
Product IDs Bazaarvoice product IDs within the account above, e.g. Target "54293362", Sephora "P61003", Sam's Club "prod21231904".
Catalogue search Find products in the account's review catalogue by keyword (most-reviewed first) and scrape them, e.g. "airpods" in targetcom.
Max products from search How many products the catalogue search may return.
Bazaarvoice passkey (legacy sites only) Only for shops on the older Bazaarvoice display (the run tells you when it is needed).
Passkey environment Production for real shops.
PowerReviews merchant ID For PowerReviews shops without a product URL: the merchant ID from the page source ("merchant_id" / "prMerchantId"), e.g. 6406 for Ulta.
PowerReviews API key The public read key from the page source ("api_key" / "prApiKey", a UUID).
PowerReviews locale Locale of the PowerReviews site, e.g. en_US (default), en_CA, en_GB.
PowerReviews page IDs Product page IDs within the merchant, e.g. "pimprod2020260" (Ulta).
Reviews Output one record per review.

Plus 24 more options. Full input reference on Apify.

Output fields

71 fields, grouped the way the dataset views show them. Export to JSON, CSV, Excel or pull them through the API.

Overview

  • Record type
  • Shop
  • Product
  • Rating
  • Title
  • Review
  • Question
  • Submitted
  • Author
  • Verified buyer
  • Product URL

Reviews

  • Shop
  • Product
  • Rating
  • Title
  • Review
  • Submitted
  • Author
  • Verified buyer
  • Recommends
  • Helpful votes
  • Syndicated
  • Syndicated from
  • Photos
  • Change

Questions & answers

  • Shop
  • Product
  • Question
  • Submitted
  • Author
  • Answers
  • Brand answered
  • Answer list

Product summaries

  • Shop
  • Product
  • Brand
  • Product ID
  • Avg rating
  • Reviews
  • Star distribution
  • Recommend %
  • Questions
  • Product URL

Full details

  • recordType
  • platform
  • retailer
  • account
  • siteLocale
  • requestedProductId
  • sourceUrl
  • productId
  • productName
  • brand
  • productUrl
  • productImageUrl
  • categoryId
  • averageRating
  • totalReviews
  • ratingDistribution
  • recommendedCount
  • notRecommendedCount
  • recommendedPercent
  • totalPhotos
  • secondaryRatingsAverages
  • firstReviewAt
  • lastReviewAt
  • totalQuestions
  • totalAnswers
  • eans
  • upcs
  • modelNumbers
  • familyIds
  • nativeReviews
  • syndicatedReviews
  • reviewId
  • originalProductName
  • rating
  • ratingRange
  • title
  • text
  • pros
  • cons
  • isRecommended
  • submittedAt
  • updatedAt
  • authorNickname
  • authorLocation
  • contentLocale
  • isVerifiedPurchaser
  • isIncentivized
  • isStaffReviewer
  • badges
  • helpfulVotes
  • notHelpfulVotes
  • isSyndicated
  • syndicationSource
  • sourceClient
  • isFeatured
  • secondaryRatings
  • reviewerProfile
  • tags
  • photos
  • videos
  • brandResponses
  • comments
  • campaignId
  • questionId
  • questionSummary
  • questionDetails
  • answerCount
  • hasBrandAnswer
  • answers
  • changeType
  • scrapedAt

Example output

One record, shortened. Real runs return one row like this per result.

{
  "recordType": "review",
  "platform": "bazaarvoice",
  "retailer": "Sephora US",
  "account": "sephora",
  "siteLocale": "en_US",
  "requestedProductId": "P61003",
  "sourceUrl": "https://www.sephora.com/product/bareminerals-original-foundation-broad-spectrum-spf-15-P61003",
  "reviewId": "403724119",
  "productId": "1922541",
  "productName": "Original Loose Mineral Foundation SPF 15",
  "productUrl": "https://www.sephora.com/product/bareminerals-original-foundation-broad-spectrum-spf-15-P61003",
  "brand": "bareMinerals",
  "productImageUrl": "https://www.sephora.com/productimages/sku/s1922541-main-zoom.jpg",
  "originalProductName": "Original Loose Talc-Free Powder Mineral Foundation SPF 15 Fair Ivory 02",
  "rating": 4,
  "ratingRange": 5,
  "title": "Love it! Especially for indoor days!",
  "text": "I love this product with all my heart! It's so simple compared to the primer/concealer/foundation/setting spray routine…",
  "pros": null,
  "cons": null,
  "isRecommended": true,
  "submittedAt": "2026-09-22T05:03:54.000Z",
  "updatedAt": "2026-09-25T23:32:01.000Z",
  "authorNickname": "kashley333",
  "authorLocation": null,
  "contentLocale": "en_US",
  "isVerifiedPurchaser": true,
  "isIncentivized": false,
  "isStaffReviewer": false,
  "badges": [
    "verifiedPurchaser"
  ],
  "helpfulVotes": 0,
  "notHelpfulVotes": 0,
  "isSyndicated": false,
  "syndicationSource": null,
  "sourceClient": "sephora",
  "isFeatured": false,
  "secondaryRatings": {},
  "reviewerProfile": {
    "skinTone": "lightMedium",
    "skinType": "comboSk",
    "eyeColor": "brown"
  },
  "tags": {},
  "photos": [
    "https://photos-us.bazaarvoice.com/photo/2/cGhvdG86c2VwaG9yYQ/d00d5d2c-9d87-5044-8084-60833b8eaf70"
  ],
  "videos": [],
  "brandResponses": [],
  "comments": [],
  "campaignId": "iOS App",
  "scrapedAt": "2026-10-20T20:15:00.000Z"
}

How to run it

  1. 1. Open the scraper on Apify and sign in (free plan works).
  2. 2. Fill in the input: search terms, URLs or filters, and a result limit.
  3. 3. Run it, then download JSON, CSV or Excel, or pull the dataset through the API.
  4. 4. Schedule it to get fresh data daily or weekly.

FAQ

Which shops does it work with? +

Any shop or brand site whose review section is powered by Bazaarvoice or PowerReviews — thousands of sites, including Target, Home Depot, Sephora, Costco, Lowe's, Petco, Sam's Club, Macy's, JCPenney, Samsung US, Boots, Argos, Dunelm, Asda, LOOKFANTASTIC, MediaMarkt, CeraVe, Oral-B, Ulta and BuyDig. Paste a link — if a shop isn't recognised, the run tells you exactly what to add.

The shop's page doesn't open for robots — will it still work? +

Yes. For the big shops the product is recognised from the link alone, so a blocked page doesn't matter.

Do I get the reviews that were written on the brand's own site? +

Yes — they are included and flagged (isSyndicated, syndicationSource). Switch them off if you want only reviews written on the shop itself.

How does "only new since last run" work? +

The first run collects everything and remembers the newest review of each product. Every later run returns only what was posted since — perfect for a daily schedule with a Slack or Telegram alert.

Can I get all reviews of a product with tens of thousands of them? +

Yes — set Max reviews per product to 0. Products with 100 000+ reviews are supported.

Can I export the data? +

Yes — JSON, CSV, Excel, XML, HTML, RSS. You can also push data directly to Google Sheets, Zapier, Make, or any webhook/API endpoint.

How often should I run this? +

For fresh data, run daily or weekly. You can schedule automatic runs on Apify with just a few clicks.

Does it work with proxies? +

It doesn't need one for normal runs. If you ever get blocked, switch on Apify Proxy in the Proxy option.

Need something this scraper does not do?

Extra fields, a different filter, a recurring feed into your database or a one-off bulk export.

Ask for a custom version

Related scrapers