BeyondERP.Newsletter
Menu

Setup step on the Activity analysis by worker page · Sales and marketing

Analyze activities by worker

Compare how workers spread their activities over types and priorities.

Business process
Analyze sales
Menu item
output:smmActivityAnalyses
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that analyzes the activity types and priorities of the activities of selected workers.
What you do hereUse it to see how workers spread their activities over activity types and priorities, for example before a sales team review. It is part of the built-in CRM; many projects run activities in Dynamics 365 Sales with prospect to cash instead.
ExampleFor example, BEAT's sales manager runs the report for the five workers of team NORTH for one activity type. It shows that Jodie Strand logged 14 high-priority activities of that type in October while two colleagues logged none, which starts the coaching talk.
Activity analysis by worker page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAnalyze sales
Menu pathSales and marketing › Inquiries and reports › Sales and marketing reports › Activity analysis by worker
Set up firstActivity types Microsoft Learn
Used next byAll leads Microsoft Learn
Related pagesSales unit/team Microsoft Learn
In this processReview sales targets
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itBefore a sales team review, when a manager wants to see how workers spend their activity time.
How oftenOn demand, for example monthly.
What the output showsActivities per selected worker, broken down by activity type and priority.

Source: Microsoft Learn

Setup steps on this page

Analyze activities by worker

Compare how workers spread their activities over types and priorities.

Steps from Microsoft

  1. Go to Sales and marketing > Inquiries and reports > Sales and marketing reports > Activity analysis by worker.
  2. Set Type to the activity type you want to compare across the team.
  3. Use Template to include or leave out activities that come from activity templates, so planned template work doesn't hide the real work.
  4. Read each worker's activities per type and priority, and compare workers with similar territories before you discuss the numbers with the team.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
TypeThe activity type that is selected for analysis.Microsoft Learn
TemplateShows whether the activity is part of a template.Microsoft Learn

Common errors and fixes

MessageWhat to do
A worker who logs activities shows none.Type limits the report to one activity type; clear it or choose the type the worker uses. Microsoft Learn

Test checklist

  1. Create two activities of the same type for one worker.
  2. Run the report with Type set to that type.
  3. Check that the worker shows two activities of that type with their priorities.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Analyze activities by workerSet Type to one activity type and decide whether Template activities are included before you run it.Mixing activity types and template activities makes busy and idle workers look alike.Where does BEAT record sales activities?Judging a worker by the count alone. A worker who records activities under a colleague, or in Dynamics 365 Sales, shows fewer here.Test: Activity counts per worker

Feature management and licence

Licence or add-inOn the live system, Sales manager, Marketing manager, Collections manager, Customer service manager and Marketing coordinator use this page; 6 roles can run it in total. No Feature management feature is needed to open it.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: the report reads the data of the legal entity you run it in. To compare legal entities, run it in each one. Checked in Dynamics 365
Can it be undoneReversible: Running the inquiry or report changes no data.
If you change it laterThe report reads activities as they are at run time; activities created later appear only when you run it again. Prospect to cash synchronizes accounts, contacts, products, quotations, orders and invoices with Dynamics 365 Sales, not activities, so activities kept in Sales don't appear here. Microsoft Learn
Technical architect

6Technical

Menu itemoutput:smmActivityAnalyses Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itSales manager TradeSalesManagerMarketing manager CRMMarketingManagerCollections manager CollectionLetterCollectionsManagerCustomer service manager TradeCustomerServiceManagerMarketing coordinator CRMMarketingCoordinatorGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=output:smmActivityAnalyses
Data migrationLoad order: Activity analysis by worker has no data entity in Data management. It is a report: it reads activities and stores no data of its own. Migrate activities with their own entities if you need the history.Checked in Dynamics 365
Everyone

8Sources

To cite this step: SM-INQ-080, Analyze activities by worker. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SM-INQ-080