A story of data and tools
We all need some key data to pilot our company or a project but too many of them are spread over multiple tools and generated every time we interact with them.
We, at Meta AP created a dashboard to make our key data available to everyone who bring value to the company: employees, investors and advisors.
So we have created Polaris , the "North Star" for our company to display and track these KPIs.
We figured out two things :
Data needs to come from multiple tools, multiple SaaS platform (Stripe, Matomo, Google Spreadsheets) and our own data, the most valuable one.
Data needs to be processed: filtered, aggregated and transformed to make the information relevant and easy to understand for everyone.
A journey through an ocean of data
Our data is spread on three different tools:
Our own API, where we can track our users, their activity and some global metrics such as the number of requests made on dev environment and prod environment.
Matomo : privacy-kind tool to get statistics coming from our website, blog and platform.
Stripe : payment and invoicing
Pipedrive : to follow our sales process and track our prospects engagement
Google Ads : to combine the data of campaigns with effects on registered users and visits on our website
How we build Polaris with Meta-API
We would like to create a simple tool, in less than two days of work to display these data.
Our platform, Meta-API, is made to connect different APIs and process data the way we want, using Javascript code, to return only relevant and refined figures.
Here is a preview of the code we created
We created 4 different Spells like this one :
- Spell for Stripe's data
- Spell connected to our endpoint to retrieve global statistics
- Spell connected to a specific endpoint to follow our user's onboarding process
- Spell for Matomo's statistics
Regarding our upcoming tools and usages, we will just need to add more Spells or to improve the existing ones to extend their capabilities. All these endpoints are secured, monitored and can be used on API client we need.
Data is the power you need to take enlightened decisions for your company: improve it and share it to your teams, with your own tools and your own style. It's the only one that matters.
Salim
#api #tools #saas #apiintegration #automation #data #javascript