LAUNCH DEMO: Gorgias + SourceMedium Integration | Unlock Actionable Insights From Support Data

[00:01] hello everyone this is Fei the founder of SourceMedium today I am excited to of SourceMedium today I am excited to announce our official gorgeous announce our official gorgeous integration this is a totally integration this is a totally Preparatory integration that we have Preparatory integration that we have where we’ve created the ability to where we’ve created the ability to ingest all of your gorgeous data

[00:17] ingest all of your gorgeous data normalize and make that usable by the normalize and make that usable by the end users whether that is data analysts end users whether that is data analysts or data scientist or a visualization or data scientist or a visualization template and primarily what will be template and primarily what will be walking through today is our out of

[00:33] walking through today is our out of the-box Open Source visualization the-box Open Source visualization template on looker Studio as you can see template on looker Studio as you can see here we have many different here we have many different templates that works directly out of the templates that works directly out of the box with our data sets so we won’t have

[00:46] box with our data sets so we won’t have time to go through everything so I’m time to go through everything so I’m just going to go through the gorgeous just going to go through the gorgeous dashboard here and as we integrate with dashboard here and as we integrate with additional customer success vendors in additional customer success vendors in the future you will be able to continue

[00:58] the future you will be able to continue to leverage this same visualization and to leverage this same visualization and data model thanks to our unified data model thanks to our unified data model approach when it comes to data model approach when it comes to data aggregation so at the very top here we aggregation so at the very top here we have some quick help text here as

[01:12] have some quick help text here as well as some quick well as some quick definitions and as we add more definitions and as we add more Integrations you will see more of the Integrations you will see more of the logos here and then right at the very logos here and then right at the very top is some of our Global filters most

[01:25] top is some of our Global filters most importantly the date filter which importantly the date filter which filters by either the ti a Clos day or filters by either the ti a Clos day or the open dat depending on the metric the open dat depending on the metric that we’re looking at and then any that we’re looking at and then any filter that you apply here will apply to

[01:38] filter that you apply here will apply to the entire dashboard we already have a the entire dashboard we already have a lot of different ways of filtering the lot of different ways of filtering the data whether that is tickets that are data whether that is tickets that are coming from a particular Channel or coming from a particular Channel or tickets that have a particular priority

[01:52] tickets that have a particular priority or cesa scores or by a agent team or a or cesa scores or by a agent team or a particular agent as well as whether or particular agent as well as whether or not that ticket is being marked as spam not that ticket is being marked as spam I won’t go through every single

[02:04] I won’t go through every single scorecard here but some of the really scorecard here but some of the really cool ones that I like on average how cool ones that I like on average how many hours is it taking for us to many hours is it taking for us to resolve our tickets what percentage of resolve our tickets what percentage of those tickets are being resolved with

[02:14] those tickets are being resolved with just one touch on average how many just one touch on average how many tickets are we seeing on per customer tickets are we seeing on per customer basis what is our average seat score basis what is our average seat score what is our average csat response rate what is our average csat response rate so that gives you a lot of very

[02:28] so that gives you a lot of very useful high level overview in terms of useful high level overview in terms of how the Cs program is doing relative to how the Cs program is doing relative to the previous period and then you can get the previous period and then you can get to some of the Deep dive here underneath

[02:39] to some of the Deep dive here underneath the scorecards starting first with the scorecards starting first with the amount of tickets that we’re seeing amount of tickets that we’re seeing being created by channel so then of being created by channel so then of course if there is any spikes from any course if there is any spikes from any particular Channel you can very quickly

[02:51] particular Channel you can very quickly see that as it is the case with all of see that as it is the case with all of our time series visualizations you can our time series visualizations you can also drill this up to a weekly also drill this up to a weekly granularity a monthly granularity etc granularity a monthly granularity etc so we’re defaulting to the Daily

[03:04] etc so we’re defaulting to the Daily granularity here and then to the right granularity here and then to the right of it we’re seeing the overall of it we’re seeing the overall distribution of ticket counts by Channel distribution of ticket counts by Channel and then we can further see how that and then we can further see how that sort of breaks down when it comes to

[03:16] sort of breaks down when it comes to multi-touch versus OneTouch ticket multi-touch versus OneTouch ticket resolutions we also get to see our resolutions we also get to see our average resolution time over time average resolution time over time relative to a previous period so if relative to a previous period so if there is any particular spikes we

[03:30] there is any particular spikes we definitely want to be watching out for definitely want to be watching out for that but we’re actually seeing a that but we’re actually seeing a decrease which is a really good sign as decrease which is a really good sign as well as the average cesas score that well as the average cesas score that we’re

[03:39] we’re seeing down below here we see the seeing down below here we see the distribution of ticket counts by the distribution of ticket counts by the amount of hours in terms of hours to amount of hours in terms of hours to resolution so this is a bucketed view so resolution so this is a bucketed view so you’re seeing for example most of the

[03:53] you’re seeing for example most of the tickets are being resolved in the first tickets are being resolved in the first 7 hours since creation but because this 7 hours since creation but because this is look Studio you can actually also is look Studio you can actually also customize these buckets so if you wanted customize these buckets so if you wanted to look at 24-hour buckets or 3-hour

[04:07] to look at 24-hour buckets or 3-hour buckets you could basically will have buckets you could basically will have the ability to do all of that as well the ability to do all of that as well and then down here we have the dist the and then down here we have the dist the distribution of tickets that have

[04:16] distribution of tickets that have received a cesa score so good thing is received a cesa score so good thing is we’re seeing most of the tickets we’re seeing most of the tickets receiving a five but we do definitely receiving a five but we do definitely want to look into what these one tickets want to look into what these one tickets are all about so we’ll be able to

[04:30] are all about so we’ll be able to actually examine the underlying data in actually examine the underlying data in a couple different ways which I’ll show a couple different ways which I’ll show you in a little bit and then to the you in a little bit and then to the right here we also see the distribution

[04:38] right here we also see the distribution of tickets by the amount of messages of tickets by the amount of messages that they’re generating so in this case that they’re generating so in this case we’re seeing most of the tickets are we’re seeing most of the tickets are receiving about 3 to six messages receiving about 3 to six messages followed by 6 to9 so and then second and

[04:52] followed by 6 to9 so and then second and last here we have a overview of the last here we have a overview of the agent performance by either the team or agent performance by either the team or the actual individual agents so you can the actual individual agents so you can see a lot of really cool stats around

[05:04] see a lot of really cool stats around how many tickets are open closed average how many tickets are open closed average seat score and then if you wanted to get seat score and then if you wanted to get to the actual agent level performance to the actual agent level performance you can very easily toggle that here as

[05:16] you can very easily toggle that here as well and then last but not least is a well and then last but not least is a way for us to access the underlying data way for us to access the underlying data that is being shown so all you really that is being shown so all you really have to do here is right click and click

[05:28] have to do here is right click and click on export and then you will be able to on export and then you will be able to export it to either a CSV or Google export it to either a CSV or Google Sheets but you know all of these Sheets but you know all of these particular columns are actually totally

[05:38] particular columns are actually totally customizable so you’re not limited to customizable so you’re not limited to what’s default here and then you can what’s default here and then you can also do some quick filtering here in also do some quick filtering here in terms of open versus closed or terms of open versus closed or everything together this only sort of

[05:50] everything together this only sort of represents a tip of the iceberg in terms represents a tip of the iceberg in terms of what you can access through our data of what you can access through our data sets because you will have access to all sets because you will have access to all of the underlying data in our hosted bit

[06:02] of the underlying data in our hosted bit query instance and the table name here query instance and the table name here is going to be called OBT customer is going to be called OBT customer support tickets so as you can see this support tickets so as you can see this is going to be at the ticket level

[06:11] is going to be at the ticket level granularity and each ticket will be one granularity and each ticket will be one row of data but they will have a lot of row of data but they will have a lot of metadata associated with it so what we metadata associated with it so what we have done here is we’ve included the

[06:22] have done here is we’ve included the actual customer level identifier so you actual customer level identifier so you will be able to then join that further will be able to then join that further Upstream with the Shopify customer data Upstream with the Shopify customer data and for example be able to filter by and for example be able to filter by subscribers versus onetime purchasers

[06:36] subscribers versus onetime purchasers versus firsttime customers etc versus firsttime customers etc and then you can see that all of the and then you can see that all of the data will be here totally data will be here totally accessible so the amount of accessible so the amount of visualizations that you will be able to

[06:48] visualizations that you will be able to make will be a lot bigger than what’s make will be a lot bigger than what’s shown in this visualization but we shown in this visualization but we believe that this will be a great believe that this will be a great starting point for most brands when it starting point for most brands when it comes to visual izing their gorgeous

[07:01] comes to visual izing their gorgeous performance excited for what’s to come performance excited for what’s to come and thank you so much for your time