Connectors

/

Salesforce

/

Focus time by Salesforce account
Report
Cross-Connector

See focus time per Salesforce account

For leaders who want to compare TickTick focus time with Salesforce account revenue, just by asking their AI assistant.

Try PopdockAI free
Get a live demo
Focus time by Salesforce account
How much TickTick focus time went into each Salesforce account since the first of September? Only show accounts with at least 2 hours.
Contoso and Northwind Traders took the most focus time since 1 September. - Contoso: 14.5 hours, 22 sessions, annual revenue 1,200,000 - Northwind Traders: 9.0 hours, 11 sessions, annual revenue 450,000 - Fabrikam: 3.5 hours, 5 sessions, annual revenue 90,000 - Unmatched: 18.0 hours not linked to any account Matching is by name text, so treat it as a close guide. Want the same view for one account owner?
Salesforce
Sample figures. Your results come from your own account.
ticktick-get-focuses
salesforce-get-account
ticktick-get-tasks

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Salesforce

Salesforce
Run it on your own Salesforce data.

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

Try PopdockAI free

The problem

Nobody knows where focused time really goes by customer

Knowing how much focused time goes into each customer means reading TickTick timer history and matching task titles to Salesforce account names by hand. Nobody does it, so effort per account is guessed and time on small accounts or no account goes unseen.

Without PopdockAI

  • Export focus history from TickTick
  • Match task titles to account names by eye
  • Total hours per account in a spreadsheet
  • Guess the effort that matches no account

With PopdockAI

  • Focus sessions and Salesforce accounts are read together
  • Sessions are matched to accounts by name in the task title
  • Hours, sessions and annual revenue are shown per account
  • Unmatched hours are shown openly, 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:** Report how much TickTick focus time went into each Salesforce account since {start-date} (default 30 days ago), for accounts owned by {owner} if given, hiding any under {min-hours} hours (default 0).

**Step 1: Read focus sessions**

Call `ticktick-get-focuses` with start-time.from set to {start-date}. Keep each session's task id, task titles and duration. If none, stop.

**Step 2: Read the accounts**

Call `salesforce-get-account` with owner.contains set to {owner} when given. Keep each account name and annual revenue.

**Step 3: Match**

For each focus session, check whether its task title contains an account name from step 2. Where a title needs more context, call `ticktick-get-tasks` with the task id. Add the duration to that account. A session that matches more than one account goes to the longest matching name.

**Step 4: Report**

Table: account, focus hours, session count, annual revenue; sorted by hours. Then total unmatched hours as one line.

**Rules & Guidelines:**

* `ticktick-get-focuses` and `ticktick-get-tasks` are on the TickTick server; `salesforce-get-account` is on the Salesforce server.
* Do NOT call any add, update, complete, delete, assign or move tool on either server (for example `ticktick-add-task`, `ticktick-update-task`, `ticktick-complete-task`, `salesforce-update-task`, `salesforce-add-task`). This prompt only reads.

**Validation:**

* Matching is by name text; say so. Account names under 4 characters are skipped.
* If no account matches any session, report that and the unmatched total.

Who it's for

One answer, three teams that use it

Founders

See which customers take your time

Compare the focused hours you put into each account with what that account is worth.

How many TickTick focus hours did I spend on each Salesforce account this quarter?

Account managers

Balance effort across your book

Spot accounts that take a lot of focused time for little revenue, and ones you have neglected.

Show my focus time per Salesforce account since July 1 for accounts I own, at least 1 hour each.

Consultants

Back up time estimates with data

Use real focus sessions to see how much time each client account has taken.

Total my TickTick focus sessions for Contoso, Fabrikam and other Salesforce accounts since the start of the month.

How it works

What PopdockAI does when you ask

You give a start date and optional filters, and your AI assistant totals your TickTick focus time against Salesforce accounts. Matching is by name text, and it tells you so.

01

Ask

You give a start date, and optionally an account owner and a minimum number of hours.

Your AI tool

02

Read

It reads your TickTick focus sessions and the Salesforce accounts.

ticktick-get-focuses
salesforce-get-account

03

Match

It links sessions to accounts by name in the task title, using the longest name when several fit.

ticktick-get-tasks

04

Report

It shows hours, sessions and revenue per account, then the unmatched hours.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

ticktick-get-focuses

Returns TickTick focus sessions (Pomodoro and stopwatch) with start, end, duration and linked task. Filter by date range.
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

ticktick-get-tasks

Returns open TickTick tasks with their project, due date, priority, status, assignee and tags. Filter by project, due date range or status.
Read only.Nothing in Salesforce 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

Effort per account, set against revenue

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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