Webhook Config

https://www.realtalkstudio.com/embed/coaching-underperformance-xhkxkh?studioId=6527d7dc-0b56-4f0d-b8bf-afab894dae7a&extCustId=crm-user-12345

https://your-api.com/webhook/endpoint

{
  "data": {
    "studioSlug": "acme-sales",
    "studioId": "b3f1c2d4-5e6f-7a8b-9c0d-1e2f3a4b5c6d",
    "roleplaySlug": "cold-call-intro",
    "roleplayId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
    "score": 82,
    "skillsFeedback": [
      { "skill": "Discovery questions", "rating": "Strong" },
      { "skill": "Objection handling", "rating": "Developing" },
      { "skill": "Closing", "rating": "Needs work" }
    ],
    "rationale": "The rep opened confidently and asked good discovery questions, but missed two buying signals and rushed the close.",
    "completedAt": "2026-06-09T12:30:45.000Z",
    "startedAt": "2026-06-09T12:22:10.000Z",
    "endedAt": "2026-06-09T12:30:45.000Z",
    "isTooShort": false,
    "avatarRating": 4,
    "avatarFeedback": "Maintained good eye contact and an even tone throughout.",
    "durationSeconds": 515,
    "extCustId": "crm-user-12345",
    "personaId": "f9e8d7c6-b5a4-3210-fedc-ba9876543210",
    "personaName": "Skeptical CFO",
    "personaType": "buyer",
    "transcript": [
      { "speaker": "user", "text": "Hi, thanks for taking the time today.", "timestamp": 0, "isComplete": true },
      { "speaker": "avatar", "text": "Of course. What did you want to discuss?", "timestamp": 4200, "isComplete": true },
      { "speaker": "user", "text": "I wanted to talk through last quarter's numbers.", "timestamp": 9100, "isComplete": true }
    ]
  }
}

create table completions (
  id            bigint generated always as identity primary key,
  ext_cust_id   text,                       -- your anonymous user key (links to your users table)
  studio_slug   text not null,
  roleplay_slug text not null,
  roleplay_id   uuid,
  score         integer,
  skills_feedback jsonb,                     -- array of { skill, rating }
  transcript    jsonb,                        -- ordered array of { speaker, text, timestamp, ... }
  rationale     text,
  avatar_rating integer,
  avatar_feedback text,
  duration_seconds integer,
  is_too_short  boolean default false,
  persona_name  text,
  persona_type  text,
  started_at    timestamptz,
  ended_at      timestamptz,
  completed_at  timestamptz,
  received_at   timestamptz not null default now()
);

create index on completions (ext_cust_id);
create index on completions (roleplay_slug);
create index on completions (completed_at);

import express from "express";

const app = express();
app.use(express.json());

app.post("/webhook/realtalk", async (req, res) => {
  const { data } = req.body ?? {};

  // Validate before doing any work
  if (!data || typeof data.score !== "number") {
    return res.status(400).json({ error: "Invalid payload" });
  }

  // Acknowledge fast — persist, then return 2xx
  await db.query(
    `insert into completions (
       ext_cust_id, studio_slug, roleplay_slug, roleplay_id, score,
       skills_feedback, transcript, rationale, avatar_rating, avatar_feedback,
       duration_seconds, is_too_short, persona_name, persona_type,
       started_at, ended_at, completed_at
     ) values (
       $1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17
     )`,
    [
      data.extCustId ?? null,
      data.studioSlug,
      data.roleplaySlug,
      data.roleplayId ?? null,
      data.score,
      JSON.stringify(data.skillsFeedback ?? []),
      JSON.stringify(data.transcript ?? []),
      data.rationale ?? null,
      data.avatarRating ?? null,
      data.avatarFeedback ?? null,
      data.durationSeconds ?? null,
      data.isTooShort ?? false,
      data.personaName ?? null,
      data.personaType ?? null,
      data.startedAt ?? null,
      data.endedAt ?? null,
      data.completedAt ?? null,
    ]
  );

  return res.status(200).json({ received: true });
});

select roleplay_slug,
       count(*)            as attempts,
       round(avg(score))   as avg_score
from completions
where is_too_short = false
group by roleplay_slug
order by avg_score desc;

select u.name,
       c.roleplay_slug,
       c.score,
       c.completed_at
from completions c
join users u on u.id = c.ext_cust_id   -- ext_cust_id is your own key
order by u.name, c.completed_at;

select sf->>'skill'  as skill,
       sf->>'rating' as rating,
       count(*)      as occurrences
from completions,
     jsonb_array_elements(skills_feedback) as sf
group by skill, rating
order by skill, rating;