Product

Resources

Company

Product

Resources

Company

Blog

Why marketing teams keep going back to spreadsheets

Why marketing teams keep going back to spreadsheets

Companies and data teams invest significant resources into building a single source of truth. Business folks are supposed to monitor and explore data through well-governed BI dashboards. However, marketing teams keep going back to spreadsheets for deep dives and granular analysis. Why? Let’s unpack this puzzle.


One of the things data teams hate most is when business users don’t use the dashboards built for them. Instead, they look for a CSV export. In the meme above you can replace PowerBI with any data visualization tool you like—Looker, Tableau, etc—and user behavior is going to be the same.

Why? Depends on who you ask!


On the one hand, data teams often put this down to problems with business teams: a lack of data literacy, inadequate training, and inertia. Business teams, on the other hand, complain about dashboards being inflexible and slow, long response cycles from data teams, and requests for updates and changes stuck in JIRA ticket limbo.


This article shares my take on this problem, specifically for B2C companies. This is based on our work with some of the most sophisticated, data-driven marketing teams like Delivery Hero, HelloFresh, On Running and About You, and hundreds of conversations with marketers at large scale-ups and enterprises over 7+ years. This experience enabled me to identify patterns in B2C companies that rely on performance marketing for growth.


Companies can be segmented into 3 tiers based on their growth stage. Each tier has specific needs and requirements. The reporting and analytics stack should adapt to each tier.

Tier 1: Pre-PMF / Funded Startups from Seed to Series A (the spreadsheet sweetspot)

  • Growth Channels: 1-2 channels, Google and maybe Meta depending on your product offering

  • Monthly Budgets: < $100k

  • Reporting Complexity: Low

  • Typical Data Stack: Google Data Studio, Supermetrics and, of course, Google Sheets. Inexpensive, efficient, and accessible.

At this stage, the only thing that matters is getting to PMF.  Speed of decision-making is more important than 100% accurate data. All you need is a Daily KPI dashboard on Google Sheets, and something like Supermetrics to pull in cost data from your channels, along with revenue and order data from Google Analytics or Shopify. The marketing team is probably not fully staffed. In fact, the function itself is probably somebody’s fractional responsibility. You don’t need a Data Team or a Data Warehouse at this stage.


Getting to PMF requires spending more time on Google Ads, running experiments on Tiktok/Meta, testing creatives, and figuring out if the CAC is directionally feasible.


Investing in a data warehouse at this stage is more trouble than it is worth. Honestly, your startup has bigger fish to fry. You don’t have to take our word for it but hear it straight from someone who has done it countless times before.

What your reports should look like:


Tier 2: Post-Product Market Fit (too complex for spreadsheets)

  • Growth Channels: 2-3 channels, Google, Meta and maybe TikTok, Snap.

  • Monthly Budgets: $100k and growing

  • Reporting Complexity: Medium

  • Typical Data Stack at Tier 2: Data Warehouse (Snowflake, BigQuery, AWS) + ETL (Fivetran, Funnel.io, etc) + BI tool (Looker, Tableau, Power BI)


At this stage, you are starting to see growing diversity in the channel mix and the establishment of dedicated teams for different marketing channels.


This complexity will soon multiply once you start investing in attribution, CRM, mobile app marketing and so on. This is usually the point at which spreadsheets start to break, and you no longer have a single source of truth. This is also the point at which different teams start reporting revenue, and conversions differently. In short, things are getting much more complex and much more data-intensive.


At this stage in the company’s lifecycle, meetings start with teams arguing over the definition and accuracy of metrics. This is usually the end of the road for something like Supermetrics, and the point at which companies invest in two things: i) a Data Warehouse and ii) a Data Team.


This represents the biggest change that takes place when companies transition from Tier 1 to Tier 2: They go from having no data warehouse and no data team to a more or less centralized data warehouse, and a business-critical data team.


Why these two investments? A centralized data warehouse ensures that every function across the enterprise is looking at the same numbers. And a data team consolidates all the reporting into one dashboard/report platform built on this single source of data.


A combination of a great data team and a strong growth team can drive the two most important pillars of growth for a company at this stage: customer acquisition and retention. You really want those two teams to work closely together.


Once you set up this data and reporting infrastructure, most teams are happy. It’s an incredibly rewarding project for the data team to invest in, and everyone in the company is finally happy to move away from manual reporting numbers, to logging into your BI platform every day to stay on top of things. You can breathe a sigh of relief and go back to meetings without the bickering.


Tier 3: Hyper-growth Companies (hello spreadsheets - we meet again!)

  • Growth Channels: 3+ channels: Google, Meta, TikTok, Twitter, Affiliate, etc

  • Monthly Budgets: $1M and growing

  • Reporting Complexity: High

  • Typical Data Stack at Tier 3: A combination between Tier 1 and 2 (but with added chaos)


From Tier 2 to Tier 3 your business has grown exponentially. And then you notice something: your meetings are starting with arguments again. This is because the changing nature of your business has created new frustrations for both your Marketing and Data Teams. The root cause lies in the transition between Tiers 2 and 3: From a mostly centralized data team to an increasingly decentralized data team.


Let’s delve into the new frustrations that accompany this transition, one team at a time.

Your Marketing Team is frustrated because the metrics they leverage have become more complex. Not only is CAC increasing for all customers, but your CAC is also probably showing different trends by time of customer, time of product unit and type of market. This means that different parts of the marketing team are looking at different metrics. Meanwhile, there is much more public scrutiny and pressure on the marketing function which is now spending substantial sums of money.


We see companies at this stage routinely spend over a million dollars on each marketing channel. Most channels such as Google and Meta will be saturated (pumping more money wouldn’t yield extra installs/orders), and you will start seeing diminishing returns (higher CAC).


What is adding to the frustration for marketers is the reporting stack. They are hitting the limits of pre-built dashboards. Marketers need more sophistication than ever before: budget forecasts, CAC by geo, CAC by customer type, market penetration insights, weekly pacing, etc.


The arguments are back because your pre-built dashboards have become obsolete.



And this is why your Data Team is frustrated. As Marketing puts pressure on them for increasingly complex reports, Data Teams are slowly forced into doing low-quality, report-generation projects. Maintaining dashboards is not what Data Teams sign up for in the first place. Plus they probably have to now work with a reporting stack that is not stable or scalable.


Thus you end up with Data Teams that are fighting with Marketing on the one hand, and the reporting stack on the other.

This is when, and why, marketers return to spreadsheets. Why waste time sending JIRA tickets to your data teams, when you can use VLookup and Pivot Tables to roll up your data and create fast, functional reports? Sounds great - problem solved!


Well, it’s not that straightforward. All these manual workflows on spreadsheets also create problems, turning marketers into data janitors (read more here).


But wait, there’s another challenge - think of all the teams in the company and where they get their data from:


Your marketing team is working with spreadsheets. Your C-Suite is happy with the dashboards built by the data team and fed from the data warehouse. Meanwhile, other teams are scattered in between - some using spreadsheets and others still tapping into the data warehouse. What you end up with is a problem of centralized, aggregate data needs for the leadership, versus decentralized, granular data needs for the marketing teams and other operators.


I’ve seen this pattern over and over again. For instance, when we started working with Delivery Hero, only Search marketing reports were on Tableau whilst Paid social and App marketing reporting were done on spreadsheets. This is because connecting all these channels into Tableau isn’t a trivial job. And maintaining it (dimension/metric changes) is next to impossible task for the data team.


Where is the single source of truth that teams across the enterprise can collaborate on? This is one of the biggest issues for hyperscale companies. To solve it companies tend to throw data stack after data stack at the issue.

Specific big problems require dedicated solutions


Complex analytics use cases require dedicated solutions. This applies for instance to product analytics, where sophisticated product managers use dedicated analytics platforms like Mixpanel or Amplitude. At this scale of operations, given the large budgets and complexity, performance marketers need specialized tooling made for them.


Marketers shouldn't need to become data janitors.

Instead, marketers need to take back control of their data, getting all the flexibility of spreadsheets combined with the scale and reliability of the Modern Data Stack.



Curious how the most sophisticated data-driven marketing teams uncover granular insights at the speed of business? Schedule a demo.


See Clarisights in action

Are you a scale-up or enterprise ready to unlock the full potential of your marketing budget? Let us show you how Clarisights can help.

© All Rights Reserved, 2023

At Clarisights, we strive to deliver exceptional products and services to our valued clients. To protect our intellectual property and maintain the integrity of our offerings, we employ the phrase "All rights reserved" throughout our website. By respecting these rights, we ensure a secure and trustworthy environment for our clients, where they can confidently leverage our software solutions to drive their business forward.

© All Rights Reserved, 2023

At Clarisights, we strive to deliver exceptional products and services to our valued clients. To protect our intellectual property and maintain the integrity of our offerings, we employ the phrase "All rights reserved" throughout our website. By respecting these rights, we ensure a secure and trustworthy environment for our clients, where they can confidently leverage our software solutions to drive their business forward.

At Clarisights, we strive to deliver exceptional products and services to our valued clients. To protect our intellectual property and maintain the integrity of our offerings, we employ the phrase "All rights reserved" throughout our website. By respecting these rights, we ensure a secure and trustworthy environment for our clients, where they can confidently leverage our software solutions to drive their business forward.