Connectors

/

Rillet

/

Prepare Rillet renewals with Contivio call history
Report
Cross-Connector

Find expiring Rillet contracts with no recent contact

For account owners who want to know which renewals are coming up and which customers have not called lately, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Prepare Rillet renewals with Contivio call history
Which active Rillet contracts end in the next 60 days, and has each customer been on the phone with us in Contivio in the last 90 days?
6 contracts end in the next 60 days. 2 of them have had no calls in 90 days. - Contoso Ltd, ends 19 Nov, 48,000 USD: no recent contact, flagged - Fabrikam Inc, ends 24 Nov, 22,500 USD: 3 calls, last 28 Oct, resolved - Northwind Traders, ends 9 Dec, 61,200 USD: no recent contact, not flagged as it ends after 30 days Want the full table of all 6 contracts?
Rillet
Sample figures. Your results come from your own account.
rillet-get-contracts
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

Rillet

Rillet
Run it on your own Rillet data.

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

Try PopdockAI free

The problem

Renewals approach without anyone checking contact

Contract end dates sit in Rillet and call history sits in the contact center. Matching them by hand is slow, so a renewal can come due without anyone noticing the customer has gone quiet.

Without PopdockAI

  • Pull contracts ending soon from Rillet
  • Look up each customer in the call system
  • Count recent calls and note the last result
  • Miss contracts that are close with no contact

With PopdockAI

  • Active contracts ending soon are listed, highest value first if limited
  • Customer names are added from Rillet
  • Recent calls are counted by customer id only
  • Contracts ending within 30 days with no calls are flagged

The prompt

Use this prompt

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

Prompt
**Objective:** For contracts ending in the next `{days-ahead}` days (default 90) in Rillet, show how recently each customer has been in contact by phone in Contivio.

**Step 1: Find expiring contracts**

Call `rillet-get-contracts` with `end-date.from` set to today and `end-date.to` set to today plus `{days-ahead}` days. Read `contract-id`, `name`, `customer-id`, `end-date`, `total-value`, `currency`, `status`, and drop contracts whose `status` is not active. If more than `{max-contracts}` (default 10) come back, keep the highest `total-value`.

**Step 2: Name the customers**

Call `rillet-get-customers` and attach `name` by `customer-id`.

**Step 3: Check recent calls**

For each contract's customer, call `contivio-get-call` with `customer-id` set to it and `start-time.from` set to 90 days ago. Count calls and note the latest `start-time` and `result`.

**Step 4: Report**

A table ordered by `end-date`: customer, contract, end date, value, calls in the last 90 days, last call date and result. Flag contracts ending within 30 days with no calls in the last 90 days as having no recent contact.
**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

Account owners

See which renewals need a call this week

Contracts ending soon are shown with their latest call, so you can reach out before the end date rather than after it.

List Rillet contracts ending in the next 45 days with each customer's recent Contivio calls.

Customer success managers

Spot quiet customers ahead of renewal

Flags show customers with a close end date and no calls in 90 days, which is where renewal risk is highest.

Which active Rillet contracts end in 30 days or less and have had no Contivio calls in the last 90 days?

Finance

Link renewal value to customer contact

Contract value sits beside call counts, so you can see how much revenue is renewing with no recent contact.

Show the 10 highest value Rillet contracts ending in the next 90 days and how many calls Contivio has for each customer.

How it works

What PopdockAI does when you ask

You choose the window and your AI assistant reads Rillet and Contivio. It only reads data and stops if either system returns nothing rather than filling in numbers.

Ask

You say how many days ahead to look.

Your AI tool

Find

It lists active Rillet contracts ending in that window and names the customers.

rillet-get-contracts
rillet-get-customers
contivio-get-call

Check

It counts each customer's Contivio calls in the last 90 days, matched by customer id.

No items found.

Report

You get a table by end date, with contracts ending within 30 days and no calls flagged.

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-contracts

Returns customer contracts (term, status, total value, invoicing) 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 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

No renewal arrives without a contact check

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