Connectors

/

Rillet

/

Find Rillet churn risk from Contivio calls
Report
Cross-Connector

See what churn risk customers told the contact center

For finance and customer leaders who want to compare Rillet ARR declines with Contivio call activity, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Find Rillet churn risk from Contivio calls
Which customers' ARR fell in Rillet between July and September, and did they call us in that period?
5 customers lost ARR between 2026-07 and 2026-09, and 2 of them had no calls. - Northwind Traders: 120,000 to 84,000, drop 36,000, 9 calls, mostly abandoned - Contoso: 60,000 to 42,000, drop 18,000, no recorded calls - Fabrikam: 45,000 to 39,000, drop 6,000, 2 calls, mostly answered - This shows contact activity only, not why ARR fell Want the full table of all 5 customers?
Rillet
Sample figures. Your results come from your own account.
rillet-get-arr-waterfall
contivio-get-call

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Rillet

Rillet
Run it on your own Rillet data.

Connect Rillet, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

ARR drops are reviewed without the call context

Finance sees which customers lost ARR but not what those customers said to the contact center. Comparing two months of ARR and then searching calls for each customer takes hours, so it rarely happens.

Without PopdockAI

  • Pull ARR for both months from Rillet
  • Match customers and work out each drop
  • Search the call system for each decliner
  • Tally results and queues by hand

With PopdockAI

  • ARR is compared for the two months
  • Decliners are matched to calls by customer id
  • Calls are counted by result and queue
  • No cause is claimed and nothing is changed

The prompt

Use this prompt

Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.

Prompt
**Objective:** Find customers whose ARR dropped between months `{from-month}` and `{to-month}` (YYYY-MM) in Rillet and check Contivio for calls from them in that period.

**Step 1: Read ARR for both months**

Call `rillet-get-arr-waterfall` with `year-month` set to `{from-month}`, then again with `year-month` set to `{to-month}`. Match rows by `customer-id` and compute the change in `arr`. Keep customers where `arr` fell, largest drop first, up to 10.

**Step 2: Check calls**

For each kept customer, call `contivio-get-call` with `customer-id` set to it and `start-time.from` set to the first day of `{from-month}`, and keep only calls that start on or before the last day of `{to-month}`. Count calls, and group by `result` and `queue`.

**Step 3: Report**

A table: customer name (`customer-name`), ARR before, ARR after, drop, calls in the period, most common `result`. Say plainly which decliners had no calls and which had many; do not claim a cause.
**Rules & Guidelines:**

* `rillet-*` tools are on the rillet server; `contivio-*` tools are on the contivio server. Both servers must be connected.
* Read-only. Do not call any rillet add, update, apply, unapply, record or setup tool, and do not change anything in either system.
* Rillet customer-id is passed to `contivio-get-call` as its `customer-id` filter. Contivio calls carry no customer name, so match by customer-id only, never by guessing from names or phone numbers.
* Use ISO dates (YYYY-MM-DD) for date filters.

**Validation:**

* If either server returns nothing or an error, say which one and stop; do not fill in numbers.
* If no calls come back for a customer-id, report that customer as having no recorded calls and continue; do not assume the id format differs.
* Report only values present in the returned fields.

Who it's for

One answer, three teams that use it

Finance leaders

Add call context to ARR reviews

See which customers who lost ARR also called the contact center, and which went silent, before the review meeting.

Which customers' ARR fell in Rillet between 2026-06 and 2026-09, and how many Contivio calls did each make?

Customer success leaders

Prioritise at risk accounts

Spot decliners with many calls or none at all, to decide where to reach out first.

Show the biggest ARR drops from August to September and whether those customers called us.

Revenue operations

Check churn signals across systems

Combine finance and contact center data in one view without building a report.

For customers whose ARR fell last quarter in Rillet, compare their call volumes and most common call results in Contivio.

How it works

What PopdockAI does when you ask

You name two months, and your AI assistant compares Rillet ARR and then checks Contivio calls for the customers whose ARR fell. It only reads and reports what the data shows.

Ask

You give a from month and a to month.

Your AI tool

Compare

It reads Rillet ARR for both months and keeps up to ten customers whose ARR fell, largest drop first.

rillet-get-arr-waterfall
contivio-get-call

Check

It reads each customer's Contivio calls for the period and counts them by result and queue.

No items found.

Report

You get ARR before and after, the drop, calls and the most common result, with no cause claimed.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Rillet and one secure connection to your AI tool. No code, no exports.

get-data

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month from Rillet.
get-data

contivio-get-call

Returns Contivio call records with durations, results, direction, queue, agent and AI call summaries, filterable by date, agent, queue and customer.
Read only.Nothing in Rillet Changes

This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.

How Popdock AI secures your data

The outcome

Context for every ARR decline, without guessing

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

One prompt template with infinite possibilities.

‍

Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.

Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

Try PopdockAI Free
See Documentation