Skip to main content

1. Getting Started

Querynora is an AI-powered conversational analytics tool designed for SMB owners. It allows you to query your sales, orders, and customer databases using plain English, bypassing complex SQL queries or database report interfaces.

To begin, create a free account at the Signup Page. During signup, you will define your organization name and enter your email address. Once created, you will be redirected to the onboarding workspace to connect your primary data store.

2. Google Sheets Setup

If your orders are tracked inside a spreadsheet, you can connect your Google Sheet in less than two minutes:

  1. Open your spreadsheet in Google Sheets.
  2. Click the **Share** button at the top right.
  3. Under **General Access**, select **“Anyone with the link can view”**.
  4. Copy the spreadsheet URL from your browser address bar.
  5. Paste the URL into the Google Sheets URL field in Querynora and submit.

Required Headers Mapping

Ensure your sheet's first row contains clear headers. Querynora's importer automatically detects columns like `order_id`, `created_at` or `date`, `total_price` or `amount`, and `customer_name` or `email` to map transactions accurately.

3. Shopify Connection

Connecting a Shopify store allows for real-time automated metric syncing:

  • During onboarding, select **Shopify** as your connector source.
  • Enter your store's primary `.myshopify.com` domain.
  • Click **Connect Shopify** to be redirected to the secure Shopify App authorization screen.
  • Approve the installation. Shopify will exchange keys and automatically redirect you back to Querynora.

Once active, Querynora automatically imports historical order metrics and customer maps to seed your dashboard.

4. Formulating NLQ Questions

After connecting a data source, navigate to the **Ask** page to talk to your business database. Here are some examples of queries that our AI engine handles out-of-the-box:

“What was my total revenue last week?”

Calculates weekly sum and compares to previous week.

“Show me customers who bought more than twice.”

Groups transactions to isolate repeat buyers.

“What is my best-selling product this month?”

Aggregates items list and sorts by order volumes.

“How much revenue came from Shopify?”

Filters total metrics scoped to the Shopify connector.

5. Scenario Planning & A/B Split Tests

Querynora contains proactive planning utilities:

  • What-If Planner (Simulator): Test ideas (like changing prices or discount percentages) to see simulated projections on customer churn and margins before making real updates.
  • Split Test Tracker (Experiments): Compare two versions of pages or marketing settings side-by-side. Our built-in statistical z-test engine evaluates conversion data to compute whether results are statistically significant.