Adhaar Sharma on 2021-03-02
We here at Love Spreadsheets had a problem with our customer support.
When someone contacted Customer Support, a Data Analyst had to quickly run queries to get the Customer details.
This burdened both the Support specialist and the Data Analyst.
We got rid of this problem by using our tool, DB Spreadsheets, to create reports with filters that give the Support specialist all the information they need
In this article, we will walk through one of those reports that we created
The first report we set up is the Information About Any User report
This report, as you can probably guess, gets all the pertinent customer information
We created an Email filter that we used in our query
We then wrote a query that gets the relevant customer information incorporating the filter
select customer_email, sign_up_dt,
plan_info, last_login from customer_table
where customer_email = Email;
After the report was set up, our support Specialist could easily access it.
They would log-in to their dashboard, click on the Report, enter the user email and be able to see the user information
This decreased our response time from an average of 5 minutes to less than 30 seconds!!
Not to mention making our Data Analyst happy :)
If this is a problem you encounter and want more information, feel free to email us at info@dbspreadsheets.com