Zendesk Chat

Zendesk Chat – formerly known as Zopim Chat – is a communication widget between companies and their customers that allows interaction between both in real time.

The tool is highly customizable and makes it possible to create the most diverse automations (including the creation of chat bots), monitor visits to your website in real time and can also help a lot in measuring user engagement with your product.

Among the most important KPIs that you can analyze with access to the Zendesk Chat API are:

  • Response time;
  • Average waiting time;
  • Interaction satisfaction index;
  • Total duration of the chat;
  • Number of open X resolved chats;
  • Number of chats handled by agent.

Adding the data source

To create your pipeline with Zendesk data on the ;

Kondado plataform, follow the steps bellow:

1) Access your Zendesk account as administrator/owner, click on the gear (settings) on the left side and, in channels, go to “chat”, then “Chat Panel”

2) Once on the chat page, on the left panel, go to “Settings” and then “Account”

3) On the new screen, go to “API and SDKs” at the top, then select “Add API Client”

4) Fill in the information as below, then click Create API Client

  • Customer name: Kondado
  • Company: Kondado
  • Redirect URLs: https://kondado.com.br

After creating the API client, a popup similar to the image below will appear. Copy the Client Id and Client Secret.

5) In the URL below replace the following:

https://NAME_COMPANY.zendesk.com/chat/oauth_login?auth={"scopes"%3A+["read"%2C+"write"]%2C+"state"%3A+null%2C+"redirect_uri"%3A+"https %3A%2F%2Fkondado.com.br"%2C+"response_type"%3A+"token"%2C+"client_id"%3A+"CLIENT_ID"}

  • COMPANY_NAME: your zendesk domain (for example, in company.zendesk.com the company is your domain)
  • CLIENT_ID: the client_id obtained above

Access the URL after replacing the values in your browser

6) After accessing the URL, you will be redirected to an authorization page as below. Select “Allow” and you will be redirected to the Kondado website

7) Once on the Kondado website, copy the URL into a text editor, its format will be something like the one below:

https://kondado.com.br/#access_token=y9huojnmkhu9odwqujifJMASD98n1j23jhasdas2223&token_type=Bearer&scope=read+write
pasted image 0.png

Select the part between “access_token=" and “&” (not including these values), as in our example above, the value will be: y9huojnmkhu9odwqujifJMASD98n1j23jhasdas2223

8) On the Kondado platform, go to the add data sources and select “Zendesk Chat”

9) On the new data source page, give it a name, copy the token generated in step (7) and save

Pipelines

Relationship Chart

Chats

Main Object

Field Type

comment

text

triggered_response

boolean

rating

text

visitor__phone

text

visitor__notes

text

visitor__email

text

visitor__name

text

visitor__id

text

session__end_date

timestamp

session__ip

text

session__country_code

text

session__id

text

session__city

text

session__region

text

session__platform

text

session__user_agent

text

session__country_name

text

session__start_date

timestamp

session__browser

text

duration

float

agent_names

text

referrer_search_engine

text

id

text

end_timestamp

timestamp

referrer_search_terms

text

missed

boolean

started_by

text

agent_ids

text

type

text

department_id

text

triggered

boolean

tags

text

timestamp

timestamp

response_time__max

float

response_time__avg

float

response_time__first

float

count__visitor

float

count__total

float

count__agent

float

zendesk_ticket_id

text

conversions

text

department_name

text

unread

boolean

webpath

Field Type

chat_id

text

webpath__timestamp

timestamp

webpath__from

text

webpath__to

text

webpath__title

text

history

Field Type

history__name

text

history__timestamp

text

history__department_name

text

history__type

text

history__channel

text

history__department_id

text

chat_id

text

history__msg_id

text

history__sender_type

text

history__msg

text

history__options

text

history__trigger_id

text

history__agent_id

text

history__reason

text

Agents

Field Type

last_name

text

create_date

timestamp

login_count

float

id

text

first_name

text

display_name

text

roles__owner

boolean

roles__administrator

boolean

skills

text

enabled

boolean

departments

text

role_id

text

last_login

timestamp

email

text