Shopify is an eCommerce platform that provides tools for both online and physical sales. On Shopify, users can set up an online store with pre-made themes. They can also accept payments from a variety of sources and use the analytics to look at their business’s sales trends. This can help them understand where they need to better focus their sales and marketing efforts.
Freshdesk is a customer support ticketing system that includes a range of ticketing tools such as ticket prioritization, service level agreements, native internal communication between collaborating agents, automated suggestions for ticket solutions and in-depth customer support analytics.
Bring all your Shopify data to Amazon Redshift
Load your Shopify data to Google BigQuery
ETL all your Shopify data to Snowflake
Move your Shopify data to MySQL
Bring all your Freshdesk data to Amazon Redshift
Load your Freshdesk data to Google BigQuery
ETL all your Freshdesk data to Snowflake
Move your Freshdesk data to MySQL
Track checkouts that were added to a customer’s cart but not completed as sales. This field includes data about the customer, the product and the reason for cancellation. It can help determine which products are most commonly abandoned at checkout and why, allowing you to run better predictive analyses about your future products and customers.
Retrieve basic customer information - such as ID, email, mailing address, and name - as well as data about customer behavior, such as the last order a customer made, their total amount spent or how many orders they have made with your company. You can then use this data to focus your marketing efforts towards specific customers or demographics.
Retrieve important data about an order request, such as customer contact information, the product ordered or the status of the order itself. Then, use this field to track important sales data like what products are being ordered the most or sales trends based on region or product price.
Create any number of product groupings and view data ranging from the product name and product ID to how much the product weighs, when it was created and how much it costs. Then, use that data to track trends and understand what types of products have been successful and why.
Track any exchange of money that occurs on Shopify, including completed sales, refunds and voided orders. This data can also track the actual revenue generated from your orders via their order ID’s, which will provide you with a sales-focused view of how well your business is performing.
Capture data from any transaction where the money has been refunded to the customer or any transaction where an item has been returned after being ordered. You can then view details about how much was refunded, what products were returned and whether or not those products have been restocked. This information can ultimately help you understand which products are successful, which are not and why.
Create, view, and/or modify information associated with one of your support agents, including their contact information (name, email, phone number), their permission level and which customer support group they belong to. You can also see if the agent is currently available to take a ticket and how long they have been available for so that you can assign tickets to appropriately.
Retrieve and update information about replies and notes associated with tickets, including the full text of the reply and the IDs of the agents, customer and support ticket associated with the conversation. This will not only allow you to integrate the full content of a support interaction into your customer support analytics but also allow Freshdesk to provide deeper analytics with regards to support agent performance.
See an array of information about a support ticket, including the customer that submitted the ticket, the source they submitted it from, the assigned agent, the content of the support request and the priority that Freshdesk has assigned that ticket. This, along with data about the type of support issue that the ticket is addressing, will allow you to more effectively assign the right members of your support team to the right tickets.
View data about a contact that has created a Freshdesk support ticket. This includes both basic contact information - like their name, email address, and social media ID - and information that will help you to more effectively assign the right agents to meet that contact’s needs, such as their preferred language, their associated tags and what other tickets they have submitted.