Connectors

/

Microsoft Dynamics 365 Sales

/

Dynamics 365 Sales rep activity report
Report

Start one-to-ones from facts, not memory

For sales managers who want a rep's calls, emails, meetings and deal movement from Dynamics 365 Sales summarized, by asking their AI assistant.

Try PopdockAI free
Get a live demo
Dynamics 365 Sales rep activity report
What did Sam Patel do in Dynamics 365 Sales over the last 7 days?
Sam Patel logged 34 activities in the last 7 days and won 2 deals. - Activity: 14 calls, 12 emails, 5 meetings, 3 tasks - Deals: 2 won worth 48,000, 1 lost - Most attention: Contoso, with 9 activities - Closing soon with no activity: Fabrikam renewal, closing in 12 days - Overdue tasks: 3 Want the details for any of these?
Microsoft Dynamics 365 Sales
Sample figures. Your results come from your own account.
microsoft-dynamics-365-sales-get-systemusers
microsoft-dynamics-365-sales-get-phonecalls
microsoft-dynamics-365-sales-get-emails
microsoft-dynamics-365-sales-get-appointments
microsoft-dynamics-365-sales-get-tasks
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-leads

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Microsoft Dynamics 365 Sales

Microsoft Dynamics 365 Sales
Run it on your own Microsoft Dynamics 365 Sales data.

Connect Microsoft Dynamics 365 Sales, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Pulling a rep's week together takes longer than the one to one

Summarising a rep's week means counting calls, emails, meetings and tasks, then checking which deals moved and which closing deals got no attention. Pulling that from several views, one rep at a time, takes longer than the conversation.

Without PopdockAI

  • Count calls, emails, meetings and tasks per view
  • Check deals won, lost and new leads
  • Find closing deals with no activity
  • Go into the one to one from memory

With PopdockAI

  • The rep is confirmed, stopping if not found or disabled
  • Activities, deals won and lost and new leads are counted
  • Closing deals with no recent activity and overdue tasks are listed
  • Facts only, no grading, 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:** Write an activity report for `{rep-name}` covering the last `{lookback-days}` days (default 7).

**Step 1: Identify the rep**

Call `dynamics-365-sales-get-systemusers` with `full-name.contains` = `{rep-name}`. If more than one matches, list them and stop. Use the exact full name as the `owner` value below.

**Step 2: Activity**

With `owner` = the full name and the lookback window, call:

* `dynamics-365-sales-get-phonecalls` (`due.from`): calls made and received, by `direction`, and how many left voicemail
* `dynamics-365-sales-get-emails` (`date-sent.from`): emails sent and received, by `direction`, with open counts
* `dynamics-365-sales-get-appointments` (`start-time.from`): meetings held, and meetings scheduled in the next 7 days
* `dynamics-365-sales-get-tasks` (`due-date.from`): tasks completed and tasks still open past due

**Step 3: Deal movement**

Call `dynamics-365-sales-get-opportunities` with `owner` = the full name. Report opportunities won or lost in the window (by `actual-close-date`), and open opportunities whose `est-close-date` falls in the next 30 days. Call `dynamics-365-sales-get-leads` with `owner` and `created-on.from` for new leads.

**Step 4: Report**

1. Headline numbers: calls, emails, meetings, tasks completed, deals won (count and `actual-revenue`), deals lost, new leads.
2. Which customers got the most attention (by regarding record).
3. Open deals closing in the next 30 days with no activity in the window.
4. Overdue tasks.

**Rules & Guidelines:**

* This prompt is read-only. Do NOT call any create or update tool: `dynamics-365-sales-create-account`, `dynamics-365-sales-create-contact`, `dynamics-365-sales-create-lead`, `dynamics-365-sales-create-opportunity`, `dynamics-365-sales-create-case`, `dynamics-365-sales-create-task`, `dynamics-365-sales-create-note`, `dynamics-365-sales-create-phone-call`, `dynamics-365-sales-update-account`, `dynamics-365-sales-update-contact`, `dynamics-365-sales-update-lead`, `dynamics-365-sales-update-opportunity`, `dynamics-365-sales-update-case`.
* Report facts only; do not grade the salesperson.

**Validation:**

* If the rep is not found, or is disabled, say so and stop.
* If `{lookback-days}` is blank or invalid, use 7.

Who it's for

One answer, three teams that use it

Sales managers

Prepare one to ones in seconds

Activity counts and deal movement give you the facts before the meeting.

What did Priya Shah do in Dynamics 365 Sales over the last 14 days?

Account executives

Review your own week

See which closing deals you have not touched and which tasks are overdue.

Summarise my Dynamics 365 Sales activity this week and list closing deals I have neglected.

Sales enablement

Spot where reps spend their time

Top customers by attention show where each rep is focusing.

Which customers got the most attention from Tom Reyes in Dynamics 365 Sales this month?

How it works

What PopdockAI does when you ask

You name the rep and a lookback period and your AI assistant summarises their recorded activity in Dynamics 365 Sales. It reports facts without grading the person.

01

Ask

You name the rep and a lookback period.

Your AI tool

02

Identify

It confirms the user in Dynamics 365 Sales and stops if they are not found.

microsoft-dynamics-365-sales-get-systemusers

03

Count

It counts activities, deals won and lost, and new leads.

microsoft-dynamics-365-sales-get-phonecalls
microsoft-dynamics-365-sales-get-emails
microsoft-dynamics-365-sales-get-appointments
microsoft-dynamics-365-sales-get-tasks
microsoft-dynamics-365-sales-get-opportunities
microsoft-dynamics-365-sales-get-leads

04

Report

You get top customers, neglected closing deals and overdue tasks, with no grading.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for Microsoft Dynamics 365 Sales and one secure connection to your AI tool. No code, no exports.

get-data

microsoft-dynamics-365-sales-get-systemusers

Returns Dynamics 365 Sales users. Filter by business unit, full name, job title, access mode, user name, primary email and disabled status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-phonecalls

Returns Dynamics 365 Sales phone calls. Filter by activity status, phone number, owner, regarding record, due date, subject and direction, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-emails

Returns Dynamics 365 Sales email messages. Filter by date sent, status reason, recipient, sender, direction, subject and regarding record, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-appointments

Returns Dynamics 365 Sales appointments. Filter by location, regarding record, owner, subject, start time and status, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-tasks

Returns Dynamics 365 Sales tasks. Filter by priority, regarding record, activity status, subject, due date and owner, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-opportunities

Returns Dynamics 365 Sales opportunities. Filter by owner, status, sales stage, probability, estimated close date, topic, potential customer and estimated revenue, and cap how many records come back.
get-data

microsoft-dynamics-365-sales-get-leads

Returns Dynamics 365 Sales leads. Filter by created date, name, status, rating, owner, company name, email and lead source, and cap how many records come back.
Read only.Nothing in Microsoft Dynamics 365 Sales 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

One to ones that start from facts

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