CRM and sales
Connect Freshdesk to DataxLand
The Freshdesk connector reads tickets, ticket conversations, satisfaction ratings, agents, groups, contacts and companies from your Freshdesk helpdesk. Si maps tickets into the support tickets of the standard model for ticket volume, resolution rate, first response time, resolution time, CSAT and tickets per agent per day; combined with marketplace or website orders, you also get tickets per 100 orders.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Freshdesk
- Track resolution time by group and by intake channel.
- Get an alert when daily ticket volume spikes unexpectedly.
- Compare tickets per 100 orders across months with big promotions.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| tickets | Tickets with status, priority, source, group, assignee, created and updated times; loaded incrementally. |
| conversations | Conversations within each ticket; select only when needed, as the content may contain personal data. |
| satisfaction_ratings | Customer satisfaction ratings. |
| agents | Support agents. |
| groups | Support groups. |
| contacts | Customer contacts; name, email and phone number are hashed on load. |
| companies | Customer companies. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | API Key, Domain |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Support tickets | Support tickets created in the period (by creation date), any status. | Count |
| Resolved tickets | Tickets resolved in the period (by resolution date); status resolved or closed with a resolution timestamp. | Count |
| Resolution rate | Tickets created in the period that are resolved divided by tickets created in the period.= cs_created_resolved / Support tickets | Ratio (%) |
| Average first response time (hours) | Average hours from when the customer created a ticket to the agent's first response, over tickets created in the period that have a response.= cs_first_response_hours_total / cs_responded_tickets | Number |
| Average resolution time (hours) | Average hours from creation to resolution for tickets resolved in the period.= cs_resolution_hours_total / Resolved tickets | Number |
| CSAT (satisfaction rate) | Share of surveys with a CSAT score of 4 or 5 on a 1-5 scale, among surveys with a valid CSAT score.= cs_csat_positive / Survey responses | Ratio (%) |
| Tickets per agent per day | Tickets created in the period divided by agent working days with tickets.= Support tickets / cs_agent_days | Number |
| Support tickets per 100 orders | Order-linked support tickets divided by valid orders, times 100. Shows how many tickets there are for every 100 orders.= Order-linked support tickets * 100 / Valid orders | Number |
Connect Freshdesk in 4 steps
- 1
Get the API key
In Freshdesk, open your profile and copy the API key from the profile settings.
- 2
Add the Freshdesk source
In the workspace choose Add source, find Freshdesk, enter the Domain (for example yourcompany.freshdesk.com) and API Key; the key is encrypted when saved.
- 3
Choose streams
Click Test connection, pick tickets, satisfaction_ratings, agents and groups.
- 4
Review and build
Si proposes a mapping to the customer support model; you approve, then build.
Limits and caveats
- Freshdesk limits requests per minute by plan; the form has a Rate Limit Plan field so the connector stays within your limit.
- Customers' personal data is hashed on load and masked before reaching Si.
- Requires the Starter plan or above. This is an Airbyte connector (ELv2) run inside DataxLand.
Frequently asked questions
Where does first response time come from?
From the ticket creation time and the agent's first response time in the ticket data; you confirm the columns at the review step.
Do I need Freshdesk admin rights?
The API key reads only the tickets your account can see; use an account that sees every group for complete numbers.
Does it change tickets in Freshdesk?
No. The connector is read-only.
Dashboard templates that use this source
Connect Freshdesk and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes