Use case

Support metrics without
waiting on a report

Backlog by priority, first response time by channel, the issues behind most tickets: ask wuup in plain English and it queries your tickets collection read-only, then answers with a chart and the exact query, so you can trust the number you put in the weekly report.

Who it's for

Support leads and CX teams whose help desk data lives in MongoDB

Sources

  • MongoDB tickets
  • MongoDB customers
  • Support playbook PDF

The problem today

  • Help desk dashboards don't answer the question you have today.
  • Response-time maths over timestamps is fiddly and easy to get wrong.
  • Joining tickets to customer plans needs an engineer.

Six questions,
and what wuup does

Ask in plain English. Here is what happens behind each answer, including the query when there is one.

  1. 01

    What's the open backlog by priority?

    Counts open and pending tickets for each priority.

    db.tickets.aggregate([
      { $match: { status: { $in: ["open", "pending"] } } },
      { $group: { _id: "$priority", tickets: { $sum: 1 } } },
      { $sort: { tickets: -1 } }
    ])
  2. 02

    What's our average first response time by channel?

    Uses $dateDiff between createdAt and firstResponseAt and averages it per channel.

    db.tickets.aggregate([
      { $match: { firstResponseAt: { $ne: null } } },
      {
        $group: {
          _id: "$channel",
          avgMinutes: {
            $avg: {
              $dateDiff: { startDate: "$createdAt", endDate: "$firstResponseAt", unit: "minute" }
            }
          }
        }
      },
      { $sort: { avgMinutes: -1 } }
    ])
  3. 03

    Which tags show up most?

    Unwinds tags and counts them.

    db.tickets.aggregate([{ $unwind: "$tags" }, { $sortByCount: "$tags" }, { $limit: 10 }])
  4. 04

    Which urgent tickets have no assignee?

    A simple find on priority and a null assignee.

    db.tickets.find({
      priority: "urgent",
      assignee: null,
      status: { $nin: ["resolved", "closed"] }
    }, { _id: 0, ticketNumber: 1, subject: 1, createdAt: 1 })
      .sort({ createdAt: 1 })
      .limit(50)
  5. 05

    What's CSAT by assignee?

    Averages csat where it exists and counts rated tickets.

    db.tickets.aggregate([
      { $match: { csat: { $ne: null } } },
      {
        $group: { _id: "$assignee", csat: { $avg: "$csat" }, rated: { $sum: 1 } }
      },
      { $sort: { csat: -1 } }
    ])
  6. 06

    How many tickets come from each customer plan?

    Joins tickets to customers and groups by plan.

    db.tickets.aggregate([
      {
        $lookup: {
          from: "customers",
          localField: "customerId",
          foreignField: "_id",
          as: "customer"
        }
      },
      { $group: { _id: { $first: "$customer.plan" }, tickets: { $sum: 1 } } },
      { $sort: { tickets: -1 } }
    ])

From question
to answer

  1. 1

    Connect tickets and customers

    Read-only, scoped to the two collections.

  2. 2

    Ask about the backlog

    "Open urgent tickets older than a day, by assignee."

  3. 3

    Share the answer

    Copy the table or the query into your report.

Why it works
for this job

Time maths done right

Response and resolution times use $dateDiff on real timestamps, and tickets without a response are excluded, not counted as zero.

Tickets plus customers

Join to the customers collection to split metrics by plan or country.

Playbook in the same chat

Upload your support playbook PDF and ask whether a ticket was handled by the book, with citations.

What changes

  • Weekly support reports in minutes.
  • Numbers your team can verify from the query.
  • Questions answered across tickets, customers and policies.
How the connector works

Questions,
answered

Bring the data.
Ask the question.