- Grain: one row per review (
sm_review_key). A review deleted in Judge.me keeps its last state, because Judge.me’s API does not report deletions. - Storefront status:
review_statusispublished,unpublished(not shown) orpending(waiting for your moderation; whether it shows meanwhile depends on your auto-publish rules, which Judge.me’s API does not report).is_review_publishedis true for published reviews, false for unpublished ones and NULL for pending ones, so filtering on it counts the reviews Judge.me reports as shown. The average review rating metric counts those reviews only. - Products:
product_idis the reviewed product’s Shopify id.sm_product_keyjoinsdim_product_variantsand is NULL when the product is no longer in your catalog, in which caseproduct_titleis Judge.me’s copy of the title. - Customers:
sm_customer_keyjoinsdim_customersandobt_customers. A reviewer is matched by Judge.me’s customer id, else by email, andreview_customer_match_methodsays which. Reviewer contact details are not in this table. - Purchase:
reviewer_latest_product_order_keyjoinsobt_orders.sm_order_key. It is the reviewer’s latest valid order containing the product, placed at or before the review: evidence of a purchase, not necessarily the order the review is about.has_prior_product_purchaseis NULL when the reviewer matches no customer. - Imported reviews: reviews imported into Judge.me from an earlier review app keep their original dates.
review_sourcesays where each review came from, in Judge.me’s own words.
sm_transformed_v2
obt_reviews
Every product review from your review app, with its rating, storefront status, product, customer and prior order.
Product reviews from your review app (Judge.me), one row per review: its star rating, title and text, whether it shows on your storefront, its photos and videos, the reviewed product from your catalog, the reviewer’s customer record, and the reviewer’s latest order of that product placed before the review.
Was this page helpful?

