Rekla.Me is a social media marketing app that allows companies to engage their customers in the marketing process by rewarding them for sharing their purchases on Instagram. The app is supported by various organizations including The European Social Fund, The European Union, and EXIST.
A big part of their model is to transparently showcase to the brands, the performance of each of their campaigns. The commission payouts for the customers were also based on the post-performance, hence it was crucial to have visibility into the numbers.
They needed performance reports before launch.
Which is why we were brought in.
At the end of the project,
Rekla.me could keep track of their business progress and make fast-paced data-driven decisions to achieve organizational goals. They were equipped with insights from day 1.
Rekla.me could position itself as a trusted partner among brands, hone customer relationships, and sell more.
Phase I: Understanding the Business and defining KPIs
The most critical—and most frequently ignored—stage of our unique methodology is the research & understanding that we carry out before getting into action.
This includes understanding the following -
What are the near-term goals of the organization?
What data points are needed to track this goal?
How can this goal be divided into KPIs which can be impacted?
What measurable data points are available and tracked?
What insights will the organization like to get that they aren't able to right now?
For Rekla.me, once the KPIs the business cares about was defined, it was time to design the dummy database through which the development team incorporated the tracking and backend updates.
Phase II: Database Design
A major chunk of any reporting project is to do the data pipelining. The essential steps involved here are -
Identifying different sources of data
Consolidating them into one platform
Modeling the data to be presented in reports
However, with Rekla.me, we had to go the other way. Creating a single source of data with fresh tables and datasets. These were to contain dummy data. We used Excel Sheets to design the database. The development team took the design and created the entire database structure in the backend (Postgre SQL).
Phase III: Dynamic Reporting
Once the foundation was ready, it was time lay out those dashboards.
Two major reports were created:
Internal accounting and company health report: It included information such as how many campaigns were running, how many brands were affiliated with them, what were average engagement rates, how big were brand payouts, how many users were participating in the campaigns, what was the average cost of engagement across the app, etc. This enabled Rekla.me to keep track of their business progress and make fast-paced data-driven decisions to achieve organizational goals. They were equipped with insights from day 1.
Brand Report: This report allowed brands to check campaign information, know the payout, understand the interested audience group, expected revenue generated each week, etc. This helped Rekla.me position itself as a trusted partner among brands, hone customer relationships, and sell more.
Phase IV: Offboarding
The reports created were going to replace the need to hire an internal data team for a substantial period of time. This required a thoughtful hand-off and ad-hoc support during the months to come.
Rekla.me was equipped with knowledge transfer (KT) documents and explainer videos to become self-sufficient when it comes to tracking their business progress.
"I was impressed by their deep knowledge of data analysis and fast implementation.”
- Tobias Haas, CEO & CoFounder, Rekla.Me