Download synthetic examples

These files use invented products, review IDs, and review text. They are provided to demonstrate the schema without publishing real reviewer data. The sample exports mirror schema 1.2; the analysis template is a separate working file for manual coding.

CSV schema sampleTwo synthetic rows with all 44 headers.Download CSV
JSON schema sampleTop-level metadata, arrays, and review objects.Download JSON
Analysis worksheetColumns for taxonomy, severity, evidence, and action routing.Download template

CSV and JSON structure

CSV is a flat table. Review fields and job-level metadata appear on every row so filtering a subset does not detach it from the export context. JSON keeps job metadata in meta, warnings in warnings, errors in errors, and review records in reviews.

JSON top level: schema_version, export_type,meta, warnings, errors, andreviews.

Review record fields

FieldMeaning
titleReview title when visible.
ratingParsed star rating.
author_namePublic reviewer display name when visible.
date_and_location_textOriginal date and location label from the page.
dateNormalized date when parsing succeeds.
bodyReview text.
image_linksArray in JSON; pipe-separated URLs in CSV.
amazon_domainSource Amazon domain.
asinProduct ASIN.
variationVariation text when visible.
exported_atTimestamp attached to the review record.
helpful_countParsed helpful-vote count when visible.
marketplaceMarketplace identifier selected by the extension.
review_idReview identifier when present in the page.
review_urlSource review URL when available.
source_page_numberObserved collection page number.
country_or_locationParsed location text when available.
verified_purchaseBoolean or unknown, depending on source visibility.

A missing value means the page did not expose the field or the parser could not determine it. Downstream systems should preserve that uncertainty instead of silently converting it to a negative statement.

Job metadata and filter fields

FieldMeaning
export_schema_versionCurrent schema version: 1.2.
export_job_idIdentifier for the user-initiated export job.
export_statusFinal job status.
completion_reasonWhy collection finished or stopped.
source_dataset_completenessFULL, LIMITED_BY_REQUEST, LIMITED_BY_EXTENSION, PARTIAL, or UNKNOWN.
request_modeProduct page, reviews page, or manual ASIN workflow.
source_urlStarting URL when available.
requested_reviews_countCount selected by the user.
available_reviews_countSource count when it can be determined.
target_reviews_countEffective collection target.
collected_reviews_countRows collected before export.
extension_review_limitCurrent product limit: 100.
requested_pagesPage scope implied by the request.
target_pagesEffective page target.
processed_pagesPages observed during collection.
sort_bySelected sort option.
reviewer_typeSelected reviewer filter when applicable.
star_filterSelected rating filter.
started_at / finished_atJob timing.
dataset_exported_atFile creation timestamp.
warnings / errorsArrays in JSON; flattened code and message columns in CSV.

Completion and warning semantics

Completion metadata distinguishes a requested subset from an interrupted result. Common successful reasons include collecting all available source reviews, reaching the requested count, collecting the current page, or reaching the extension limit. A partial job may also report login, CAPTCHA, page, pagination, parser, tab, cancellation, or unknown errors.

Warning codes can report missing fields, removed duplicate reviews, early pagination end, skipped images, or suspected selector drift. Consumers should expose these conditions rather than dropping them during import.

CSV encoding, escaping, and spreadsheet safety

  • The downloaded CSV uses UTF-8 with a byte-order mark for common spreadsheet compatibility.
  • Quotes, commas, tabs, carriage returns, and newlines are escaped.
  • Formula-sensitive text prefixes are neutralized before a spreadsheet opens the file.
  • Multiple image links are joined with a pipe character in CSV and remain an array in JSON.
  • The filename follows amazon_reviews_marketplace_asin_timestamp with the selected extension.

Schema consumers should check export_schema_version orschema_version before relying on fixed columns. Future product versions may add fields while retaining documented versioning.