Report

Cross-Connector

Rank renewal risk using Freshdesk tickets and Salesforce contracts

For leadership who want a ranked view of renewals using support load, contract dates and open deals, just by asking their AI assistant.

Freshdesk renewal risk with Salesforce contracts

List the customers renewing in the next 90 days and rank them by renewal risk. Check the 10 soonest.

10 companies renew in the next 90 days, and 3 look at risk. - Contoso Ltd: 9 tickets, 2 escalated; Salesforce contract ends 30 Nov, no open renewal opportunity - Fabrikam: 5 tickets, health score unknown; Freshdesk renews 15 Dec, Salesforce contract ends 31 Dec - Northwind Traders: not in Salesforce Checked 10 of 14 renewing companies. Want the next 4?

Freshdesk

Sample figures. Your results come from your own account.

freshdesk-get-companies

freshdesk-get-tickets

salesforce-get-account

salesforce-get-contract

salesforce-get-opportunity

On this page

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Freshdesk

Run it on your own Freshdesk data.

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

The problem

Renewal risk judged from memory

Knowing which renewals are in danger needs support pain from Freshdesk, the contract end date and any open renewal deal from Salesforce, and the health score, lined up per customer. Without that, a renewal with no deal slips past.

Without PopdockAI

List renewing companies in Freshdesk
Count escalated and urgent tickets for each
Look up contracts and renewal deals in Salesforce
Miss the renewal with no open opportunity

With PopdockAI

Renewing companies are listed soonest first
Escalated and urgent tickets from the last 60 days are counted
Contract end dates and open renewal deals are read from Salesforce
Date mismatches and missing deals are flagged, and nothing changes

The prompt

Use this prompt

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

Prompt

**Objective:** List customers renewing in the next `{renewal-days}` days (default 90) and rank them by renewal risk using support and sales evidence.

**Step 1: Renewals in Freshdesk**

Call `freshdesk-get-companies` with renewal-date.from set to today and renewal-date.to set to today plus the window. Keep name, renewal-date, account-tier and health-score. Stop if none.

**Step 2: Support pain per company**

For up to `{max-companies}` companies (default 10, soonest renewal first), call `freshdesk-get-tickets` with company-id and created-at.from set to 60 days ago. Count tickets, escalated tickets and urgent or high priority tickets.

**Step 3: Sales view in Salesforce**

For each of those companies call `salesforce-get-account` with name set to the company name. If found, call `salesforce-get-contract` with account-id and `salesforce-get-opportunity` with account-id and closed set to false. Note contract end-date and any open renewal opportunity with its stage and amount. If the account is not found, mark it "not in Salesforce".

**Step 4: Report**

A ranked table: company, renewal-date, health-score, tickets, escalated, Salesforce contract end-date, open renewal opportunity. Flag mismatches between the Freshdesk renewal-date and the Salesforce contract end-date, and renewals with no open opportunity.

**Rules & Guidelines:**

* reshdesk-* tools are on the freshdesk server and salesforce-* tools are on the salesforce server; both servers must be connected.
* This prompt is read-only. Never call any freshdesk add, update, delete or reply tool (such as reshdesk-add-ticket-note, reshdesk-update-ticket, reshdesk-reply-to-ticket) or any salesforce add or update tool (such as salesforce-add-case, salesforce-add-contact, salesforce-update-account).

**Validation:**

* A missing health-score is "unknown", not zero.
* State how many companies were checked against the cap.

Who it's for

One answer, three teams that use it

Revenue leaders

Rank renewals by real risk

Support and sales evidence in one ranked table gives you a defensible view for the forecast call.

Rank the 15 soonest renewals in the next 120 days by risk using Freshdesk tickets and Salesforce contracts.

Account executives

Find renewals with no open deal

Renewals with no open opportunity are flagged, so you can open the deal before the contract ends.

Which customers renewing this quarter have no open renewal opportunity in Salesforce?

Customer success managers

Fix dates that do not agree

Mismatches between the Freshdesk renewal date and the Salesforce contract end date are called out for correction.

Do the Freshdesk renewal dates match Salesforce contract end dates for customers renewing in the next 60 days?

How it works

What PopdockAI does when you ask

You set a window and how many companies to check, and your AI assistant ranks renewals by risk. It stops on missing or ambiguous matches and shows a missing health score as unknown.

Ask

You set the renewal window and how many companies to check.

Your AI tool

Support

It lists renewing Freshdesk companies and counts tickets, escalations and urgent items.

freshdesk-get-companies

freshdesk-get-tickets

Sales

It finds each company in Salesforce with its contract end date and open opportunity.

salesforce-get-account

salesforce-get-contract

salesforce-get-opportunity

Rank

You get a ranked table flagging date mismatches and renewals with no open deal.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

freshdesk-get-companies

Returns companies from Freshdesk, with filters on the fields that matter. Read-only.

get-data

freshdesk-get-tickets

Returns tickets from Freshdesk, with filters on the fields that matter. Read-only.

get-data

salesforce-get-account

Returns Salesforce accounts with their type, industry, owner, billing address, phone and annual revenue. Filter by name, account number, type, industry, owner, billing city or state, annual revenue and created date.

get-data

salesforce-get-contract

Returns Salesforce contracts with their account, status, term, start and end dates, price book and signatories. Filter by contract number, account, owner, status and start and end date.

get-data

salesforce-get-opportunity

Returns Salesforce opportunities with their account, stage, amount, probability, close date, next step, owner and whether they are closed or won. Filter by name, account, stage, owner, amount, close date and closed and won flags.

Read only.Nothing in Freshdesk 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.

The outcome

A ranked renewal risk list built on evidence

Related use cases

More ways to put this data to work

Freshdesk and Salesforce account support and sales view

Ask your AI about a company and it shows Freshdesk ticket load beside the Salesforce account, open opportunities and open cases, with a note on risk.

Learn More

Reconcile Freshdesk tickets with Salesforce cases

Ask your AI to pair open Freshdesk tickets with open Salesforce cases for a company and flag gaps and priority mismatches. Read-only.

Learn More

Freshdesk and Salesforce contact sync gap report

Ask your AI to compare a company's contacts and it matches Freshdesk and Salesforce by email, listing who is in only one system or in both.

Learn More

Freshdesk requester billing context from Salesforce

Name a Freshdesk ticket and your AI finds the requester in Salesforce and reports open invoices, overdue items and credit memos. Read-only, with matches checked.

Learn More

Summarize a Freshdesk customer account

Ask your AI to summarize a Freshdesk company: contacts, tickets, time spent, satisfaction and renewal risk signals in one read-only account view.

Learn More

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.