What is Cirqll activity reporting and why do you need it?
Most CRM reports look at outcomes: how many deals are open, what they are worth, how much was won. That is useful, but it always comes afterwards. When a quarter disappoints, the missing work was already left undone months earlier.
An activity report looks at what comes before: the appointments, the tasks and the follow-up. How many customer meetings are in the diary for the coming weeks? Which tasks are overdue? Which key customers have no next contact planned? Those are the signals you can still act on.
In Cirqll you already record those activities. The problem is usually not the data but the overview. You see your own tasks, but not in one picture how the team is doing, or which customers are falling through the cracks. That is what Power BI is for.
Which 5 KPIs belong in a Cirqll activity report?
Keep it small. Five numbers you look at every week say more than twenty charts nobody opens. For most Cirqll users these five are a good start:
- Appointments per employee per week. Both looking back (what happened) and looking ahead (what is planned). An empty diary for the next two weeks is an early warning.
- Open and overdue tasks. The number of tasks still open, and the share that is past its planned date. A pile of overdue tasks usually means there are promises to customers still outstanding.
- Customers without a next contact. Cirqll has a next contact field on each customer. Show the customers where it is empty, starting with those with the highest priority or with open deals.
- Days since last activity. For each customer, how long ago something last happened. Group them into bands, for example 0–30, 31–90 and more than 90 days, so you can see where customers are drifting away.
- Open deals without a planned action. Deals that are open while there is no open task or future appointment for that customer. These are the deals everyone assumes someone else is handling.
The last two are the most valuable, because they produce a work list straight away. If you also want to see how deals and quotes develop, combine this with a Cirqll sales dashboard.
Which Cirqll data do you need for it?
Everything comes from the Cirqll API. When we checked through the API on 29 October 2026, we saw the following data, among other things:
- Appointments: the user, the customer, a name, start and end date, the location and an archive date.
- Tasks: the user, the customer, a name and description, the planned date and an archive date.
- Customers: the owner, the priority, the next contact date with a note, and the date of the last activity. You can also request the number of appointments and tasks per customer.
- Deals: to link open deals to planned actions.
One thing to agree beforehand: what does "done" mean? In the API, tasks and appointments have an archive date. If your team archives a task as soon as it is finished, you can count on that. If that does not happen consistently, you mainly measure who archives neatly. What else you can do with the API is covered in Cirqll API: what you can do with it.
How do you build Cirqll activity reporting in Power BI?
If you already have a report on Cirqll, you build this on the same connection. How that connection works is explained in connecting Cirqll to Power BI. A setup in five steps:
- Load appointments, tasks, customers and deals and link them through the customer and the user. Add a date table so you can look by week and by month.
- Fix the definitions. What is "overdue" (planned date before today and not archived)? What is a "customer appointment" (only appointments linked to a customer, or internal ones too)? Write it down, so everyone means the same number.
- Build one overview page with the five KPIs as cards, each compared with last week.
- Build a work list per employee. A table with the customers without a next contact, the overdue tasks and the open deals without an action, filtered on the signed-in user or selectable per person.
- Refresh it daily and put the report on the agenda at a fixed moment each week.
If you also want to see how the number of open tasks develops over months, you need to store the figures periodically. Cirqll shows the current situation; for history you need storage of your own, as described in Cirqll data in your own database.
Example: a wholesaler that stops letting follow-up slip
A fictional example to make it concrete. A technical wholesaler with four account managers works with Cirqll and already has a sales dashboard. The pipeline looks healthy, but revenue from existing customers is falling. Nobody knows exactly why.
They build the activity report and see three things in the first week:
- A sizeable share of the customers with "high" priority has no next contact. After a quote or delivery, nothing new gets planned.
- One account manager has a pile of overdue tasks. Not out of unwillingness: he took over an extra region and never cleaned up the old tasks.
- Several open deals have no planned action at all. Two of them turn out to have been won by a competitor already.
The approach is down to earth. Every Monday the team spends ten minutes on the work list. Every high-priority customer gets a next contact. Outdated tasks are cleaned up in one go. And deals without an action get a task or are closed. After a few weeks the work list is short enough to actually discuss in the meeting.
What should you watch out for with activity reporting?
- Steer, do not judge. A report that counts appointments per person can feel like surveillance. Explain what it is for: making sure customers do not fall through the cracks. Use it to judge people and you will soon get appointments that only exist to hit the number.
- Quantity is not quality. Ten short calls are not better than one good conversation. Use the counts as a signal, not as a target.
- Recording must be easy. The report is only as good as what goes into Cirqll. If the team only creates appointments in Outlook, the report will not see them. First check how appointments end up in Cirqll.
- Keep the GDPR in mind. A report on activities per employee contains personal data about your own people. Decide who may see which page and stick to what you need.
- Let recurring work happen automatically. If you want a follow-up task to appear automatically when a deal is won, that is a job for Make.com rather than for a report. Examples are in Cirqll and Make.com: 5 automations.
Help with your Cirqll activity reporting
We usually build activity reporting as part of a Cirqll report in Power BI. See what we do in dashboarding, read more about our partnership with Cirqll and the Cirqll Power BI Connector on our Cirqll page, or see how workflow automation makes follow-up independent of anyone's memory. Which other systems we connect is shown under integrations.
