The most common tracking errors in influencer marketing and what really belongs in the sheet
In audits and onboarding we see a similar picture again and again: an Excel sheet is passed from person to person and contains a few names of influencers, costs and perhaps a “Conversions: yes/no” column. This is a nice list, but it is not yet a database. Most sheets lack basic data:
- Audience data broken down: “DACH, female, 25+” is not enough. You need concrete percentages per age group and gender, both as an estimated target group and as the target group actually reached.
- Verticals: “Lifestyle” doesn’t give you much information. Travel, DIY, food or pets, for example, are categories that you can learn from later.
- Estimated vs. Actual Views: Did you get what you paid for? Without this comparison, you cannot assess whether the influencer you booked has delivered.
- Deliverables and Status: What exactly did you book, did it go live and when?
- Focus product and briefing: Only if you know what was placed and how you briefed can you later evaluate what worked.
- Performance KPIs: There are some KPIs that you can track, from Net Revenue, CAC, NC CAC and new customer rate to AOV, ROAS and CVR to sessions, cost per session and engagement rate. Systematically find the ones that are relevant to you and track them from the start.
The goal is not a huge sheet that no one can maintain. Your task is to build a compact dashboard where everything important is visible at a glance. The best way to find all data points at a glance when working with your 13-inch MacBook is without having to scroll endlessly. With this foundation you can optimize any social media channel and develop influencer marketing into a successful channel.
You can also find all insights from our OMR keynote including Q&A as a complete video on YouTube.











