Connectors

/

Contivio

/

Check Contivio calls for overdue Rillet customers
Report
Cross-Connector

Check whether overdue Rillet customers have been called

For finance and collections teams who want call history next to overdue Rillet invoices, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Check Contivio calls for overdue Rillet customers
Which Rillet customers with overdue invoices have not been called in Contivio in the last 30 days? Check the top 10.
10 customers have overdue balances in Rillet, and 3 have no recorded call in the last 30 days. - Largest: Northwind Traders, 48,200 overdue across 4 invoices, oldest due 2 Sep, last call 28 Oct, Promised to pay - Contoso: 31,900 overdue, 2 calls, last call 15 Oct, Voicemail - Not contacted: Fabrikam Inc, Adventure Works, Tailspin Toys - Matching used customer id only, never names or phone numbers Want the full table of all 10?
Contivio
Sample figures. Your results come from your own account.
rillet-get-invoices
rillet-get-customers
contivio-get-call

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Contivio

Contivio
Run it on your own Contivio data.

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

Try PopdockAI free

The problem

Collections chase without knowing who has been called

Overdue invoices sit in Rillet and call history sits in Contivio. Without checking both, some customers get repeat calls while others are never contacted.

Without PopdockAI

  • Pull overdue invoices from Rillet and total them per customer
  • Look up each customer name
  • Search Contivio for calls to each one
  • Compare the lists and spot who was missed

With PopdockAI

  • Overdue invoices are totalled and ranked for you
  • Calls are matched by customer id, never by guessing
  • Calls in the window and the latest result are shown
  • Uncontacted customers are listed 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 with overdue invoices in Rillet and check Contivio for calls to or from each in the last `{lookback-days}` days (default 30), for up to `{max-customers}` customers (default 10).

**Step 1: Find overdue invoices**

Call `rillet-get-invoices` and keep rows where `overdue` is true and `amount-due` is above zero. Group by `customer-id` and total `amount-due`. Rank by total, largest first, and keep the top `{max-customers}`.

**Step 2: Name the customers**

Call `rillet-get-customers` and attach `name` to each kept `customer-id`.

**Step 3: Check call contact**

For each kept customer, call `contivio-get-call` with `customer-id` set to that id and `start-time.from` set to the start of the window. Count calls, and note the latest `start-time`, `direction` and `result`.

**Step 4: Report**

A table: customer, overdue total, oldest `due-date`, invoice count, calls in window, latest call date and result. Below it, list customers with overdue balances and no calls in the window as the ones nobody has contacted.
**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

Collections specialists

Prioritize who to call today

See the largest overdue balances with the last call next to each, so you start with customers nobody has spoken to.

Show my top 10 overdue Rillet customers and whether Contivio has calls in the last 14 days.

Finance managers

Check collection effort

Review whether calls are reaching the customers owing the most, before a cash review.

Of the Rillet customers with overdue invoices, who has no recorded Contivio call in 30 days?

Contact center supervisors

Avoid repeat calls

See which overdue customers were already phoned recently, so the team does not call the same people twice.

For the top 15 overdue Rillet customers, which already had a Contivio call this month?

How it works

What PopdockAI does when you ask

You set the size of the check. Your AI assistant reads Rillet and Contivio, matches on customer id, and reports. It only reads, and stops if either system returns nothing.

Ask

You set how many customers to check and how many days of calls to look at.

Your AI tool

Rank

It finds overdue Rillet invoices, totals them per customer and keeps the largest balances.

rillet-get-invoices
rillet-get-customers
contivio-get-call

Match

It checks Contivio for calls to each customer by customer id.

No items found.

Report

You get a table with calls and results, and a list of customers nobody has contacted.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) 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 Contivio 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

Chase the customers nobody has called

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