Book a meeting
with Felipe, our manager
He will answer all questions and arrange a meeting.
Prefer email?
hi@aspirity.com
Custom CRM
Database
Automated workflow
2024
Created database for USL players association
Team
Our solution revolutionized the clients work processes, empowering them with a customized database that handled complex data effortlessly.
Challenge
Soccer Players Association approached
us with a challenge. They were managing a players list in Google Sheets and had players' contracts stored as PDFs in a folder on Google Cloud.
However, they needed a more robust and efficient solution to handle their data, provide analytical insights, and automate various processes.
Our task was to build a functional database solution that would streamline their operations and enhance their decision-making capabilities.
However, they needed a more robust and efficient solution to handle their data, provide analytical insights, and automate various processes.
Our task was to build a functional database solution that would streamline their operations and enhance their decision-making capabilities.
Solution
—Player database enrichment
We matched the players' information from the Google Sheet with their corresponding profiles on TransferMarkt to gather additional player details and enrich our database.
— Expanded data structure
We expanded the database by incorporating additional layers, such as clubs and leagues, and established the necessary relationships and dependencies among the data. This enabled seamless navigation and retrieval of information.
— Contracts database
Building a comprehensive contracts database presented a challenge due to the intricate structures and terms involved.
— Advanced analytical features
We developed various analytical features that allowed users to analyze transfer history and explore data from multiple perspectives, such as players, clubs, and leagues.
Looking for a solution like this?
Key features
— Automated invoicing
Automated Invoicing: We implemented an automated invoice generation and sending system tailored to union members with different pricing structures. With just one click in the Airtable interface, PDF invoices were automatically generated and sent, streamlining the billing process.
— Light CRM functionality
We integrated automated SMS and WhatsApp messaging features within the Airtable interface. This functionality provided a convenient messaging history and automated correspondence options, acting as a lightweight CRM system.
— Analytical dashboard
The solution included robust analytical dashboards that offered a wide range of options for working with data, allowing users to extract valuable insights and make informed decisions.
— Convenient data representation
The database provided a user-friendly interface with all the powerful features of Airtable, enabling easy sorting and searching of data enhancing overall data management efficiency.
Key outcomes include:
Empowered association: real-time insights enabled informed decision-making and streamlined operations.
Efficient data architecture: our custom architecture facilitated easy manipulation of vast data.
Streamlined processes: automation features, such as invoicing and messaging, saved time and increased productivity.
Enhanced analytics: advanced features and interactive dashboards provided valuable insights.
Efficient data architecture: our custom architecture facilitated easy manipulation of vast data.
Streamlined processes: automation features, such as invoicing and messaging, saved time and increased productivity.
Enhanced analytics: advanced features and interactive dashboards provided valuable insights.
What task will we solve for you?
Book a meeting
with Felipe, our manager
He will answer all questions and arrange a meeting.
Prefer email?
hi@aspirity.com
