/
/
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.
On this page
Connector
Connect Rillet, pick your AI tool and paste the prompt.
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.
**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.
Find
It lists active Rillet contracts ending in that window and names the customers.
Check
It counts each customer's Contivio calls in the last 90 days, matched by customer id.
Report
You get a table by end date, with contracts ending within 30 days and no calls flagged.
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.
rillet-get-contracts
rillet-get-customers
contivio-get-call
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.
The outcome
No renewal arrives without a contact check
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.

.webp)
