Logged everywhere, visible nowhere
Sales activity is the most detailed data a CRM holds, and the most awkward to analyze. Every call, task and appointment gets logged against a contact or a deal. That is perfect for reading one record's story, and useless for reading the team's. The questions that matter for coaching and planning, touches per deal, activity by rep by week, how long deals sit silent before they die, are all aggregate questions. Freshsales gives you record-level views.
Why this data is worth pulling out
- Coaching with evidence. "Make more calls" is a vibe. "Your closed-won deals average 11 touches and your open ones average 4" is coaching.
- Real capacity planning. Activity volume per rep per week is the ground truth under every hiring conversation.
- Deal health. An open deal with no activity in 30 days is not a deal, it is a memory. You can only find those in aggregate.
- Handovers and reviews. A departing rep's activity history is the map of every relationship they leave behind.
The extraction
Our Freshsales activity exporter pulls tasks, appointments and logged activity through the API into one CSV. One row per activity, with its type, date, owner, outcome and the record it belongs to. Filter by date range or owner if you only need last quarter or one rep's accounts. From that file, a pivot table answers every question above in minutes.
The usual promises apply, and they are built into how the tool works rather than just being promises: API key in memory only, read-only access, free preview before the full run.
A CRM that logs everything and totals nothing is a diary, not a database.
How to find the stale deals
The single most useful trick with this export: pull activities with their related deals, take the most recent activity date per deal, and filter open deals whose latest touch is older than 30 days. That list is your quiet pipeline rot. Most of those deals will not close, and the forecast counts them anyway. Finding them monthly is worth the whole exercise on its own.
A monthly ritual worth having
Export a rolling 90 days of activity on the first of each month and keep the files. Three months in, you have trend lines: activity per rep, touches per stage, meetings per closed deal. It is the cheapest sales analytics program there is, and it starts with one button.
Frequently asked questions
Can Freshsales export all sales activities at once?
Not cleanly from the UI, where activities live on individual records. The API exposes tasks, appointments and logged activities, so an API-based exporter can produce one CSV of all activity with owner, date, type and related record.
What activity metrics should sales managers track?
Touches per deal by outcome, activity volume per rep per week, time since last activity on open deals, and meetings per closed-won deal. All four fall out of a single activity export and a pivot table.
How do I find stale deals with no recent activity?
Export activities with their related deals, take the most recent activity date per deal, and filter open deals whose latest touch is older than 30 days. Those are the deals silently rotting in the pipeline.