Business owners who use Loyverse POS and who want to analyze their financial data are most likely aware of Loyverse’s limited reporting capabilities. That’s why many turn to Google Data Studio (GDS), a free and accessible dashboarding application to help you generate the reports you need. However, if you want to avoid the tedious task of manually exporting, cleaning, and uploading your Loyverse data to get good results from GDS, the best option is to use a third-party data management platform to do the hard work for you.
Dataddo is exactly one such platform which can provide the tools required to move and transform your Loyverse data, even automating the process so you don’t need to continue fiddling with the pipeline after initial set-up. Curious about the method for creating a Loyverse to GDS pipeline in Dataddo? Save this article for a step-by-step guide to the inner workings of the Dataddo platform as we take you through the connection process.
Step 1: Add a source.
From within your Dataddo control panel, click Sources at the top of the page, then “New Source” at the top right corner.
Type “Loyverse” into the search bar and click the icon. This will bring you to the configuration page.
Step 2: Configure your data.
This is where you decide which data from Loyverse will go to GDS, and how. Select which dataset you want to work with - in this example, “Customers.” Click “Next” and enter your Loyverse account email.
On the next page, name your data source in the “Data Source Name” box, then select which attributes of the data set you want to use in Data Studio. In this case, I only want to see the customer name, email, postal code, first visit, and total spent. Click “Next.”
Step 3: Choose data pulling frequency.
The “Snapshotting” page determines how often Dataddo will pull data from your source and how it will be stored in the app. First, select the type of destination you will be sending your data to: “Dashboarding App” for Google Data Studio.
Choose the parameters for how often you want data to be synced, “Snapshotting Frequency” and what time range of data you want pulled at each sync (today’s data, yesterday’s data, last two day’s data, etc). You can also choose the exact time of day you want the sync to occur, and how Dataddo should handle past snapshots.
Click “See Preview” to ensure that the data looks the way you want it before hitting “Save and Create Flow” in the top right corner.
Step 4: Create API connection to Google Data Studio
Now that your Loyverse data is securely in Dataddo, you can create the data flow to GDS. After clicking "Save and Create Flow," you'll find yourself on this page:
Click “Add Destination” and scroll down to select “Google Data Studio” from the list. Then go to “Configuration” in the top right corner.
After naming your flow and clicking the yellow “Create Flow” button, you now need to make the connection to Dataddo within Google Data Studio. From the “configure dashboard” pop-up, click the link that says “Dataddo Google Data Studio connector” and follow the prompts within your Google Data Studio account.
Data Studio will ask you for Dataddo’s API keys, provided in the pop-up. Simply copy and paste where requested in your GDS account to build the connection.
Step 5: Get your data!
And just like that, you’ve built a pipeline within Dataddo! The Dataddo application will keep a live connection with GDS so that every time you log into your Data Studio, the figures you’re working with will be up-to-date.
Remember that our support team is with you every step of the way in case you run into any snags. Simply use the chat box feature to get in touch or send us an email to firstname.lastname@example.org.
Why choose Dataddo?
When it comes to modern-day data management, flexibility is more important than ever. Dataddo offers a variety of plug-and-play data connectors and the ability to create any connection you need that isn’t already provided on the platform. It’s pricing system is based only on the number of sources you use, and it can scale to any existing data architecture. If you want data management that actually works for you, start your 14 day free trial today!
Connect Loyverse to Google Data Studio
Just a few quick steps and you'll find all your Loyverse data in your favorite BI tool.
[featured image source: <a href="https://www.freepik.com/photos/sale">Sale photo created by teksomolika - www.freepik.com</a>]