Freshdesk

Freshdesk is a cloud-based customer support platform.

Sync Freshdesk data to Sourcetable

Build reports once. Connect to Freshdesk and start modeling from live data.

Popular Use Cases

Freshdesk connector Sourcetable connector
Create reports using Freshdesk data
Freshdesk + Sourcetable
Freshdesk connector Sourcetable connector
See an active list of all Freshdesk tickets
Freshdesk + Sourcetable
Freshdesk connector Segment connector
Segment Fresdesk customer support tickets by lead source with Segment data
Freshdesk + Segment
Freshdesk connector Sourcetable connector
Analyze customer support performance to predict churn
Freshdesk + Sourcetable
Freshdesk connector MySQL connector
Combine MySQL user table and Freshdesk tickets for cohort analysis
Freshdesk + MySQL
Here's a sample of the Freshdesk data that will be available in your Sourcetable spreadsheets:
AGENT

Agent is a person that interacts with the customer to look into his concern or query. It has fields like available, occassional, signature, ticket scope, contact active, email, job type, mobile, name, phone, language etc

AGENT_GROUP

Contains association of agent id and group id

AGENT_ROLE

Contains association of agent id and role id

BUSINESS_HOUR

Contains name, description and timestamp information of created at and updated at

COMPANY

Contains the company infomation like name, note, description and timstamp information of created at and updated at

COMPANY_DOMAIN

Contains the assocation of company id and domain

CONTACT

Contains company id, name, phone, address, email, description, language, twitter id, job title and timezone

CONVERSATION

The interaction between the agent and a customer is known as conversation, it has fields like contact id, ticket id, body,body text, support email, source and from email

CONVERSATION_ATTACHMENT

If any attachment is attached during a conversation it is stored in the conversation attachment table, It has fields like conversation id, content type, size, name and attachment url

CONVERSATION_BCC_EMAIL

It has conversation id and email

CONVERSATION_CC_EMAIL

It has conversation id and email

CONVERSATION_TO_EMAIL

It has conversation id and email

DISCUSSION_CATEGORY

It has name and description

DISCUSSION_COMMENT

It has discussion topic id, contact id, body text, body, answer, published, spam and trash

DISCUSSION_FORUM

It has discussion category id, name, description, position, forum type, forum visibilty, topics count and post count

DISCUSSION_TOPIC

Contains discussion forum id, title, user id, locked, published, stamp type, replied by, post count, hits, user votes, merged topic id, sticky, replied at

EMAIL_CONFIG

Contains product id, group id, name, to email, reply email, primary role and active

GROUP

Contains escalate to, business hour id, name, description, unassigned for and auto ticket assign

PRODUCT

It has name and description

ROLE

Contains name, description and default

SATISFACTION_RATING

The rating which customer gives after having an interaction with the agent. It has fields like survey id, agent id, group id, ticket id, and feedback

SATISFACTION_RATING_VALUE

It has survey question id, satisfaction rating id and value

SURVEY

It has title and timestamp for created at and updated at

SURVEY_QUESTION

The question which is asked from customer regarding any topic, it has fields like survey id, accepted rating, and label

TICKET

Contains email config, group, agent, product, company, spam, priority, subject, type, source, status, description, description text, due by and is escalated

TICKET_CC_EMAIL

It has ticekt id and email

TICKET_FWD_EMAIL

It has ticekt id and email

TICKET_REPLY_CC_EMAIL

It has ticekt id and email

TICKET_TAG

It has ticket id, index and tag

TICKET_TO_EMAIL

It has ticekt id and email

TIME_ENTRIES

Contains agent, ticket, company, billable, note, timer running, executed at, and start time