---
title: "Abandoned CALL_CONOSCITIVA purchases"
method: GET
path: "/api/analytics/abandoned-call-conoscitiva-purchases"
tags: ["analytics"]
---

# Abandoned CALL_CONOSCITIVA purchases

`GET /api/analytics/abandoned-call-conoscitiva-purchases`

Patients who started a CALL_CONOSCITIVA checkout but never completed any purchase (excludes anyone with a succeeded payment or any non-CALL_GRATUITA appointment). Includes their most recent CALL_GRATUITA status and datetime when present. The optional from_date/to_date period filters checkout attempts and is inclusive. Includes a global summary of attempts and latest CALL_GRATUITA statuses. Paginated.

## Query parameters

- `from_date` string, date, nullable — Checkout attempt period start (YYYY-MM-DD), inclusive.
- `to_date` string, date, nullable — Checkout attempt period end (YYYY-MM-DD), inclusive.
- `has_free_call` boolean, nullable — Filter patients by presence of any CALL_GRATUITA: true with, false without.
- `outcome` string, nullable — Filter by outcome: all (default), abandoned (never paid the conoscitiva), or recovered (paid it after abandoning).
- `per_page` integer — Page size.
- `page` integer — Page number (1-based).
- `sort_by` string — Sort field: last_attempt (default) or attempts_count.
- `sort_dir` string — Sort direction: asc or desc.

## Response `200`

Successful Response

- AbandonedCallConoscitivaPurchaseResponse — Patients who abandoned the CALL_CONOSCITIVA purchase without converting.
  - `items` AbandonedCallConoscitivaPurchaseRow[] — Rows ordered by most recent attempt descending
    - `user_id` string, uuid, required — User UUID
    - `patient_id` string, uuid, required — Patient UUID
    - `email` string, nullable — User email
    - `first_name` string, nullable — User first name
    - `last_name` string, nullable — User last name
    - `phone` string, nullable — User phone
    - `attempts_count` integer, required — Number of CALL_CONOSCITIVA checkout attempts (incl. the succeeded one)
    - `attempts` CheckoutAttempt[] — Checkout attempts with status, most recent first (includes the succeeded checkout)
      - `created_at` string, date-time, required — Checkout attempt timestamp
      - `status` string, required — Payment status: expired, cancelled, failed, pending, processing, refunded, succeeded
    - `last_attempt_at` string, date-time, required — Most recent abandoned checkout attempt
    - `outcome` string, required — abandoned (never paid the call conoscitiva) or recovered (paid it after abandoning)
    - `free_call_status` string, nullable — Status of the patient's most recent CALL_GRATUITA, if any
    - `free_call_datetime` string, date-time, nullable — Datetime of the patient's most recent CALL_GRATUITA, if any
    - `call_conoscitiva_status` string, nullable — Status of the patient's most recent CALL_CONOSCITIVA, if any (recovered)
    - `call_conoscitiva_datetime` string, date-time, nullable — Datetime of the patient's most recent CALL_CONOSCITIVA, if any (recovered)
  - `total` integer, required — Total number of patients
  - `per_page` integer, required — Page size
  - `page` integer, required — Page number
  - `summary` AbandonedCallConoscitivaPurchaseSummary, required — Global aggregates for the filtered cohort (patients who abandoned a CALL_CONOSCITIVA checkout).
    - `abandoned_count` integer, required — Patients who never paid the conoscitiva
    - `recovered_count` integer, required — Patients who paid the conoscitiva after abandoning at least once
    - `recovery_rate` number, nullable — recovered / (abandoned + recovered) as a percentage (0-100); null if cohort is empty
    - `total_attempts` integer, required — Total incomplete CALL_CONOSCITIVA checkout attempts in the filtered period
    - `patients_with_free_call` integer, required — Patients whose most recent CALL_GRATUITA has a status
    - `patients_without_free_call` integer, required — Patients without a CALL_GRATUITA
    - `free_calls_by_status` object — Patients grouped by the status of their most recent CALL_GRATUITA

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/corabea/apis/corabea-api.md) · [All operations](https://skmtc.dev/corabea/apis/corabea-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/corabea/corabea-api/revisions/13c1bce1bdc4/schema)