Freshdesk logo

Sync Freshdesk data to Sourcetable

Freshdesk

Freshdesk is an online cloud-based customer service software providing helpdesk support with all smart automations. The platform makes it easy for users to measure a wide range of common customer support KPIs, including First Response Time, Average Handle Time (AHT) and Customer Satisfaction Score (CSAT).

Sync Freshdesk data to Sourcetable


Freshdesk logo
Sourcetable logo

Find out how to make the most of your Freshdesk messaging data with Sourcetable

Sourcetable Benefits

Query and cross-reference data

Freshdesk converts customer requests into tickets, allowing users to unify ticket resolution across channels, automate workflows, measure metrics, and keep on top of customer support. Syncing Freshdesk data to Sourcetable automatically links Freshdesk to all the other apps you use, giving your marketing and support teams the tools they need to create the best customer experience possible.

Accessibility

Syncing Freshdesk data to Sourcetable allows users to compare customer engagement metrics with other key performance indicators quickly and easily, without having to learn SQL or other database languages, making important KPIs available to all members of your team.

Auto-update your data

Sourcetable brings together key data from Freshdesk and other platforms quickly and intuitively, allowing users to automate processes and free up time to focus on other important aspects of their business.

Two circular arrows representing how your data refreshes when any of the sources changes

Visualizations

Sourcetable comes with a full suite of visualization tools for your reporting needs, allowing users to create visually striking dashboards, bar charts, line graphs, burn charts, mapping, scatter plots, and more to share with their teams, highlighting the metrics that matter.

A simple flow showing how a table converts to a chart easily

Find out how to get the most from Freshdesk with Sourcetable

A Magic Wand

Smart Templates

Use out-of-the-box, tried and tested templates to enable data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyse your Freshdesk customer engagement data instantly in cross-channel reports that pull data from other platforms and services.

A Magic Wand

Ease Of use

Compile all your customer engagement data into a spreadsheet so you can query it and find the business intelligence behind the numbers.

Who uses Freshdesk data in Sourcetable

๐Ÿ“ˆ Marketing and Advertising professionals

๐Ÿ‘ท๐Ÿฟ Sales and Sales Ops folk

๐Ÿš€ Founders

๐Ÿ‘ฉ๐Ÿผโ€๐Ÿ’ผ Customer Support Professionals

๐Ÿข Ecommerce businesses

Here's a sample of the Freshdesk data that will be available in your Sourcetable spreadsheets:

Show all (31)

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

Link icon

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

Link icon

COMPANY

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

Link icon

COMPANY_DOMAIN

Contains the assocation of company id and domain

Link icon

CONTACT

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

Link icon

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

Link icon

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

Link icon

CONVERSATION_BCC_EMAIL

It has conversation id and email

Link icon

CONVERSATION_CC_EMAIL

It has conversation id and email

Link icon

CONVERSATION_TO_EMAIL

It has conversation id and email

Link icon

DISCUSSION_CATEGORY

It has name and description

Link icon

DISCUSSION_COMMENT

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

Link icon

DISCUSSION_FORUM

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

Link icon

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

Link icon

EMAIL_CONFIG

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

Link icon

GROUP

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

Link icon

PRODUCT

It has name and description

Link icon

ROLE

Contains name, description and default

Link icon

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

Link icon

SATISFACTION_RATING_VALUE

It has survey question id, satisfaction rating id and value

Link icon

SURVEY

It has title and timestamp for created at and updated at

Link icon

SURVEY_QUESTION

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

Link icon

TICKET

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

Link icon

TICKET_CC_EMAIL

It has ticekt id and email

Link icon

TICKET_FWD_EMAIL

It has ticekt id and email

Link icon

TICKET_REPLY_CC_EMAIL

It has ticekt id and email

Link icon

TICKET_TAG

It has ticket id, index and tag

Link icon

TICKET_TO_EMAIL

It has ticekt id and email

Link icon

TIME_ENTRIES

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

Link icon

Sample companies

Online businesses integrating Freshdesk with Sourcetable can quickly access all relevant data on customer engagement, feedback, chats and automatic email sequences.

  • Software as a Service

    (SaaS) companies
  • Small to Medium

    sized businesses
  • B2B Platforms

  • B2C Marketplaces

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Connect, sync and query your Freshdesk data with data from 30+ other sources, to drive decisions and improve customer experience

A Magic Wand

Collaboration

Create and share intuitive views and workflow templates based on data from Freshdesk and other platforms, no knowledge of SQL required

A Magic Wand

Automation

Sourcetable allows businesses to pass information to and from other apps automatically, providing customers with the most personalized communication experience possible

Frequently Asked Questions

How do I sync my Freshdesk data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Freshdesk data.
How easy is it to visualize my Freshdesk data using Sourcetable?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key data from Freshdesk - and other customer support platforms such as Zendesk and Intercom - at a glance without SQL.
Which customer support platform works best with Sourcetable โ€“ Freshdesk or Zendesk?
Both platforms work equally well on Sourcetable, allowing users to combine data, better understand the relationships among available data, and gain new insights for making better decisions or identifying new opportunities.




Connect your Freshdesk Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.