Knowi enables visualization, analysis, and reporting automation from your Judge.me product reviews data.

Connect your Judge.me account to pull reviews, ratings, products, and shop metrics into Knowi for analytics and dashboards - no manual exports needed.

Overview

Connect to Judge.me using your private API token. Knowi handles authentication and data extraction automatically via the Judge.me REST API.

Connecting

1. Log in to Knowi and select "Queries" from the left sidebar.
2. Click on the "New Datasource +" button and select Judge.me from the list of datasources.

3. Configure the following details:

   a. Datasource Name: Enter a name for your datasource (e.g., "My Judge.me Reviews")

   b. Shop Domain: Enter your Shopify store domain that is linked to your Judge.me account (e.g., mystore.myshopify.com).

   c. API Token: Enter your Judge.me private API token. You can find this in your Judge.me dashboard under Settings > API.

4. Click "Test Connection" to verify the credentials.
5. Click "Save" to finish setting up the datasource.

Collections

After connecting, select a collection from the dropdown to query your Judge.me data.

Reviews

Retrieves product reviews including reviewer name, rating, body, title, and status.

Optional Filters:

• Rating - Filter by star rating (1-5).
• Status - Filter by published, unpublished, or unmoderated.

Default Cloud9QL:

select reviews;
select expand(reviews);
select id, title, body, rating, reviewer.name, reviewer.email, published_at, product_title order by published_at desc;

Products

Retrieves product-level review summary data including average rating and total review count per product.

Default Cloud9QL:

select products;
select expand(products);
select id, title, reviews_count, average_rating order by reviews_count desc;

Shop Metrics

Retrieves aggregate shop-level review statistics including total review count and overall average rating.

Default Cloud9QL:

select shop;
select reviews_count, average_rating;

Querying

After selecting a collection, click Preview to see the data. Use the Cloud9QL editor to transform and filter the results.

Common transformations:

• Flatten nested data: select expand(reviews);
• Filter by minimum rating: select * where rating >= 4;
• Aggregate by rating: select rating, count(*) group by rating order by rating desc;
• Filter by date: select * where published_at >= '2024-01-01';

Scheduling

Once your query is configured, you can schedule it to run automatically (e.g., hourly or daily) to keep your dashboards current with new review activity.

Notes

• Your Judge.me private API token can be found in the Judge.me merchant dashboard under Settings > General > API.
• The shop domain must match the Shopify store connected to your Judge.me account.
• Judge.me's API returns paginated results. Knowi handles pagination automatically.
• Only published reviews are returned by default. Use the Status filter to include unpublished or unmoderated reviews.