With the Social Messaging add-on for Zendesk Support, you can add your company’s social messaging channels such as Facebook Messenger, Twitter, WhatsApp, LINE, and WeChat to Zendesk Support. For more information, see Installing and setting up the Social Messaging add-on.
While Explore doesn't currently report on social messaging channels, social messages do attach a tag to any ticket they create. In this Explore recipe, you'll learn how to use these tags to generate a quick report on the tickets coming in from each of your social messaging channels.
This recipe contains the following topics:
What you'll need
Skill level: Intermediate
Time required: 15 minutes
- Zendesk Explore Professional or Enterprise
- Editor or Admin permissions (see Adding users to Explore)
- Ticket data in Zendesk Support
- The Social Messaging add-on for Zendesk Support
- At least one ticket generated from social media
Creating the query
This query reports the first assignee for each ticket in your instance.
To create the query
- In Explore, click the query () icon.
- In the Queries library, click New query.
- On the Choose a dataset page, click Support > Tickets > Support: Tickets, then click New query. Query builder opens.
- In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Tickets, then click Apply.
- In the Columns panel, click Add.
- From the list of attributes, choose Ticket > Ticket tags, then click Apply. Explore displays the number of tickets for all ticket tags in your instance. Next, you'll filter this to only show the ticket tags associated with social messaging.
- In the Columns panel, click the Ticket tags attribute you just added.
- On the Ticket tags property page, choose one or more of the following social messaging tags that you want to include in your report:
Tip: Zendesk Support instances typically use a lot of tags. To make it easier to find the tags you need, use the search box at the top of the Ticket tags property page.
Important: Social messaging tags can be manually removed from tickets by agents. If you remove a social messaging tag from a ticket, it will no longer be included in views or Explore reports.
- line_support: Include tickets generated by LINE Messenger.
- whatsapp_support: Include tickets generated by WhatsApp.
- wechat_support: Include tickets generated by WeChat.
- messenger_support: Include tickets generated by Facebook Messenger.
- twitter_support: Includes tickets generated by Twitter mentions and direct messages.
For details about setting up all of these messaging channels, see Using social messaging channels.
In this example, all of the social messaging tags are chosen:
- When you are finished, click Apply. Explore displays a pie chart showing each channel and the number and percentage of each ticket associated with a social messaging channel.
- Click the query title (by default New query), give the query a descriptive name, then click Save.
In the next section, you'll learn about some extra steps you can take to improve the presentation of this report.
In this section, you'll learn a few ways to improve the presentation of this query to get it just how you want it.
- You can choose a number of different ways to present your results from the visualization type menu (). For example, a Column chart looks great. For more help, see Visualization types reference.
- You'll see in the examples that the column names are the names of the tags. You could use a renamed set to create a new attribute that contains more friendly names for each column. For help creating renamed sets, see Organizing values by groups and sets.
For information about reporting using these channels with Explore, see Understanding ticket channels in Explore.