With a team of highly skilled and experienced marketing experts, Funnellab creates digital strategies to streamline prospecting and recruiting. Their main goal is to optimize the sales process by helping companies pre-qualify their prospects.
They contacted Makeitfuture to find a solution for their data management and make it simpler. In this case study, we will introduce an automation process that helped Funnellab.
All-in-one solution for data management
Funnellab GmbH was facing a common problem that many companies experience—data fragmentation. The client was using various tools such as Sevdesk (invoice app), Google Ads (advertising campaigns), and Pipedrive (CRM for tracking deals and customer information) to manage their data, but they had difficulty in consolidating all this information into one place.
Integrating Apps and Automating Processes into Airtable
To solve this problem, our team implemented a solution that involved taking data from all these apps and putting it into Airtable, a cloud-based database management platform. This allowed Funnellab GmbH to have all their information in one place, eliminating the need to manually work with Google Sheets.
We utilized make to automate the process of adding data into Airtable from Sevdesk, Google Ads, and Pipedrive. This way, new organizations and deals could be added to Airtable automatically as soon as they were created in Pipedrive. Invoices from Sevdesk were also updated daily in Airtable, and the amount invested in active Google campaigns was added to Airtable once a month.
By using Airtable, Funnellab GmbH was able to streamline their data management processes and save time. All the math and calculations, such as ROAS, were done automatically in Airtable, eliminating the need for manual calculations. This solution allowed Funnellab GmbH to focus on their core business activities, leaving the tedious data management tasks to our team.
How does the Pipedrive to Sevdesk scenario work?
The scenario involves tracking and updating organizational information across different apps. It filters events based on if they have a Sevdesk ID or not, and only updates organizational events.
When there's at least one deal, it synchronizes all the information. If the company name doesn't exist in Sevdesk, it creates the company in both Sevdesk and Pipedrive. The company's information such as address, PipeDrive ID, and sync date are added and updated as needed.
When there's an update to the company information, such as name or address, the synchronization process is triggered and updates the information in Sevdesk.
The scenario runs anytime there's a new organizational event, including new deals, open deals, and modifications to the organization. This ensures that all contact company information is updated in Sevdesk.
Improved Efficiency and Data Accuracy with Airtable
In conclusion, Funnellab GmbH's problem of data fragmentation was successfully solved through the implementation of Airtable. Our team provided a solution that allowed the client to consolidate their data and automate many of their data management processes, freeing up time and resources for more important business activities.
Take the next step towards highlighting your processes with automation. Contact Makeitfuture today to learn more.
- Dictum porta duis vitae dolor donec mauris. Nunc facilisi vestibulum egestas purus molestie.
- Sed amet volutpat porttitor quam vel, elit nunc.
- Nunc nunc, sit at diam risus, dis. Facilisis viverra posuere id mauris, orci eu.
- Facilisis mauris amet dignissim elit. Ac in sapien, odio nulla.
- Id viverra viverra eleifend convallis leo. Urna rhoncus auctor tristique arcu faucibus etiam amet.
- Dignissim sollicitudin at congue amet, non rhoncus consectetur.
Auctor sed ut sit massa lorem sit et, sit. Mi arcu, morbi nibh dictum lobortis risus nisl phasellus. Eget eget fames mauris velit in rutrum. Et dictumst in nisi lectus. Sapien eu scelerisque condimentum sit lorem.
Convallis enim convallis vitae massa ultricies at feugiat mi curabitur.
Lectus justo, rhoncus, egestas est donec purus. Auctor porta volutpat egestas proin est dui aenean. Purus arcu mauris varius semper in lectus felis vitae hendrerit. Purus neque pulvinar dignissim a. In mattis cursus augue amet, lorem amet eros. Sociis pellentesque interdum nisl, egestas dolor. Porttitor id arcu sed orci eget egestas. Scelerisque montes, ac elementum aliquet leo.
Ut malesuada malesuada varius neque.
Proin non sed porttitor in nisi. Adipiscing sit enim vivamus morbi nisi. Senectus leo diam diam volutpat eleifend vitae feugiat id scelerisque. Amet dictum eu pellentesque sed viverra eget. Egestas sed eget tempus ipsum pretium, vel sit egestas risus. Auctor in egestas placerat ultrices suspendisse magna nunc. Sed tempus elit sed auctor eu id ipsum. Eu aliquam convallis accumsan ut justo id posuere ut. Nibh porttitor donec adipiscing porta pulvinar. Morbi imperdiet amet, vitae eu posuere urna duis. Nisl rutrum sed lacus, at non arcu aenean aliquet. Vitae interdum diam nibh ut elementum, mollis. Gravida eget cursus auctor congue elementum sit commodo. Lectus nibh sed vitae justo, aenean. Urna vel aliquam vivamus urna faucibus cras morbi.
Facilisis tempus aliquam amet ut. Purus placerat quam leo pellentesque elit elementum pretium. Consectetur ac rhoncus velit malesuada ut etiam diam velit. Pulvinar venenatis interdum nullam turpis lacus, viverra volutpat sodales facilisis. Vitae id sed nunc libero, cursus cursus.
Sollicitudin a pharetra, tellus cras viverra elit.
Pharetra, convallis nibh sagittis non. In lorem vitae eget id placerat cras porta. Tellus viverra rhoncus rhoncus ullamcorper turpis elit velit. Diam nisi iaculis sit vehicula in placerat. Blandit pretium mollis sem faucibus donec id risus id gravida. Nec risus, dui blandit quis. Eget dolor vel tortor in adipiscing leo cursus pulvinar at.