Knowi has a native Judge.me integration that connects to your Shopify store’s review data using your Judge.me private API token and shop domain. Once connected, you can pull product reviews, ratings, and reviewer details into dashboards and join them with Shopify order data, all without manual exports.
Quick Summary (TL;DR)
- Knowi connects to Judge.me using two credentials: your private API token and your Shopify store’s myshopify.com domain.
- Both credentials are available in Judge.me admin under Settings > Integrations > View API tokens.
- Three collections are available: Reviews, Product Lookup, and Custom Endpoint.
- The Reviews collection returns id, rating, title, body, reviewer name and email, product ID, verified status, curated status, hidden status, created_at, and updated_at.
- Reviews can be filtered by product ID, star rating (1-5), or reviewer email address.
- Judge.me data can be joined natively with Shopify, PostgreSQL, Google Analytics, and 30-plus other sources in Knowi.
- Knowi handles page-based pagination automatically, fetching all pages until the full dataset is retrieved.
Table of Contents
What Is Judge.me?
Judge.me is a product review platform for Shopify stores. It collects, manages, and displays customer reviews on your storefront. Knowi’s integration lets you pull that review data directly into dashboards for analysis, and join it with your Shopify order or product data to understand review performance in context.
How to Connect Judge.me to Knowi
The Judge.me connector requires two credentials: your private API token and your Shopify store domain.
- In Judge.me, go to Settings > Integrations and click View API tokens.
- Copy your Private API Token (the server-side token, not the public token).
- Note your Shopify store domain in
myshopify.comformat (e.g.,mystore.myshopify.com). - In Knowi, go to Queries and select New Data Source.
- Select the Judge.me connector.
- Enter your Private API Token and Shop Domain.
- Save and start querying.
Tokens do not expire unless you manually rotate them. For full setup details, see the Judge.me connector documentation.
What Data Can You Pull from Judge.me?
| Collection | What It Returns | Filters and Parameters |
|---|---|---|
| Reviews | id, rating, title, body, reviewer.id, reviewer.name, reviewer.email, product_external_id, verified, curated, hidden, created_at, updated_at | Product ID (internal Judge.me ID), Rating (1-5 stars), Reviewer email. Knowi paginates automatically at 100 reviews per page. |
| Product Lookup | product.id (Judge.me ID), product.external_id (Shopify ID), product.handle, product.title, product.description, product.product_type | External (Shopify) Product ID (required). Use this to convert Shopify product IDs to Judge.me product IDs for filtering Reviews. |
| Custom Endpoint | Any Judge.me API v1 resource | Resource path (e.g., reviews, widgets/product_review, products/-1). Query parameters appended automatically with your credentials. |
Technical Details
Pagination
Judge.me uses page-number based pagination with 100 reviews per page. Knowi increments pages automatically until all records are retrieved. No manual configuration is needed.
Data Format and Cloud9QL
Judge.me returns reviews nested in a reviews array. Use Cloud9QL’s expand(reviews) function to flatten into tabular rows. Common transformations:
- Flatten:
select expand(reviews); - Select fields:
select id, rating, body, reviewer.name as reviewer_name; - Filter by rating:
select * where rating >= 4; - Aggregate by rating:
select rating, count(*) group by rating;
Important Notes
- Reviews created via API cannot be marked as verified.
- API responses exclude video URLs and review replies.
- Use the Product Lookup collection first to get Judge.me product IDs if you want to filter reviews by specific products. Judge.me uses its own internal product IDs, not Shopify product IDs, for filtering.
Joining Judge.me with Shopify in Knowi
Knowi supports cross-source joins natively. You can combine Judge.me review data with Shopify order and product data directly in a query using the product_external_id field from Reviews (which maps to the Shopify product ID) as the join key. This lets you analyze review performance alongside order volumes, revenue, and product data without moving data to a warehouse.
Supported cross-source joins include Shopify, PostgreSQL, Google Analytics, and 30-plus additional sources.
Frequently Asked Questions
What credentials do I need to connect Judge.me to Knowi?
Two credentials: your Private API Token and your Shopify store domain in myshopify.com format (e.g., mystore.myshopify.com). Find both in Judge.me admin under Settings > Integrations > View API tokens.
What Judge.me data can I pull into Knowi?
The Reviews collection returns id, rating, title, body, reviewer name and email, product_external_id, verified status, curated status, hidden status, created_at, and updated_at. The Product Lookup collection converts Shopify product IDs to Judge.me product IDs. Custom Endpoint accesses any other Judge.me API v1 resource.
How do I filter reviews by a specific product?
Judge.me filters reviews by its own internal product ID, not the Shopify product ID. Use the Product Lookup collection first: enter your Shopify product ID to get the corresponding Judge.me product ID, then use that ID to filter the Reviews collection.
Can I filter Judge.me reviews by star rating?
Yes. The Reviews collection accepts a Rating filter from 1 to 5. You can also filter further in Cloud9QL: select * where rating >= 4; returns only 4 and 5-star reviews.
Can I join Judge.me reviews with my Shopify product or order data in Knowi?
Yes. The Reviews collection returns product_external_id, which maps directly to the Shopify product ID. Use this as the join key to combine review data with Shopify orders, product catalog, or revenue data in a single Knowi query.
Are video reviews or review replies available through the Judge.me API?
No. The Judge.me API responses exclude video URLs and review replies. Only text reviews with their rating, title, body, and reviewer metadata are available through the connector.
Ready to connect your Judge.me reviews to Knowi? Read the Judge.me connector documentation to get started, or schedule a demo to see it in action with your review data.