Online Advertisement Efficiency
Client Overview
Our client, a rapidly growing startup in Spain, relied heavily on online advertising to drive user growth. However, they faced a significant challenge: they lacked a reliable system to accurately measure the effectiveness of their advertisements beyond basic metrics like clicks and sales.
To address this, we partnered with the client to design and implement a comprehensive tracking system that mapped every step of the customer journey. This solution provided the client with detailed insights into the performance of their advertisements, enabling the marketing team to allocate budgets more effectively and achieve optimal spending for each ad campaign.
Once the data was verified for accuracy and sufficient insights were gathered, we developed an automated system that dynamically adjusted ad budgets based on predefined input parameters. This innovation not only improved the efficiency of their advertising strategy but also maximized their return on investment.
Our Process
We meticulously began by capturing data at every stage, from the app download to the final order completion. This wasn’t a simple task—it required precision to ensure every data point was tracked seamlessly. The next challenge was linking this data accurately to visualize the funnel, providing clarity on user behavior at each step.
Once the funnel was mapped, we tackled the integration with ad platforms, enabling us to monitor exactly which ads were active and the daily spend per ad. This level of detail was crucial for creating a clear picture of ad performance.
With all the data in place, we engineered a sophisticated algorithm to identify the most profitable ads and flag underperforming ones. This breakthrough allowed us to automate budget adjustments dynamically, empowering the marketing team to optimize ad spend with just a few input parameters.
Technical Highlights
The technologies we used to deliver the solution
Yii2
MariaDB
Redis
Apache
Codeception / PHP Unit
Facebook Ads
Solutions
The custom solution we developed for the client, after understanding their unique needs and challenges.
We used Adjust to track the app downloads and received callbacks to track installations based on IDFAs. This also included the UTM codes added by the marketing team.
Key Findings
The structure of a database is critical—it forms the foundation for efficient data processing and usability. Without proper design, data becomes cumbersome to manage and loses its value.
The second key insight is that even a small, well-implemented feature, like a properly structured database or an optimized app, can drive enormous scalability. It enables businesses to handle growth seamlessly, unlocking opportunities they couldn’t achieve before while streamlining operations for greater efficiency.
Impact
This transformation resulted in a remarkable 4x increase in conversion rates, all while operating at just a quarter of the original cost. The outcome? A Customer Acquisition Cost (CAC) that was 16 times more efficient, delivering unparalleled value to the client’s growth strategy.
The impact of these advancements was profound. Not only did it fuel significant company growth, but it also earned them recognition as the Fastest Growing Startup in Spain. Additionally, the company secured its place as the 5th fastest-growing startup across Europe, solidifying its reputation as a rising leader in the industry.