We asked 27 marketers to share how they use Google Sheets. The result: 19 unique use cases you can adopt, plus several tools that make Google Sheets more extensible.
Marketing | Feb 20
Kevin Kononenko on September 27, 2018 (last modified on September 28, 2018) • 6 minute read
“Nothing is consistent when it comes to online marketing. That was one of our pains – when it came to the end of the month, we were like, ‘oh shit, we could have improved this while it is still running.’
Throughout the past year, we’ve managed to change the way we work internally. Now we work in three days sprints. We work much faster and we need a tool that gives us reports way faster for us to improve on every sprint.”
-Ismail Aly, CEO of IDS Agency
Izzy: Life was hard before using Databox. Our monthly reporting with the client was really painful. It used to take us two days to prepare the reports with lots of screenshots and CSV exports. We had to work in Excel to create charts. And the reporting meeting was focused on reading the numbers.
We were not really getting anything actionable out of the meeting. After Databox, that changed because we started creating dashboards that automatically update. It’s real-time data so we don’t have to spend time actually crunching these numbers. We can just build a dashboard for that.
We start talking about goals before the prospect becomes a client. It starts in the sales process.
It’s all based around their goals. And we try to tie those goals into business metrics, like revenue or number of employees or market share. We start with a metric that’s tied to their core business objective and we start to reverse engineer the funnel from that.
In order to achieve this revenue goal, how many customers do you need by the end of the year?
And out of those customers, how many of them can you close today without doing anything?
So we try to find the gap and then we look at the conversion rate from the qualified opportunity to a customer. So we have a target or a goal for qualified opportunities. We work in reverse all the way to leads and traffic and conversion rates.
It’s a new concept. There are different reactions to it. Some prospects get suspicious because they think it is too many questions. Some of them have actually never thought of it this way. With some new businesses, it’s hard to have those numbers and metrics because there are no previous data to build on. We usually book like a four-hour workshop to go through this goal-setting exercise.
“I want to increase revenue. I just want to sell more.”
It’s not really specific, it’s just “I want more”. But then I ask:
“Okay, when you want to sell more, do you want to sell more to existing clients or new clients?”
“What’s your existing capacity for selling more?”
“How many clients do you lose per year?”
We share basic industry standards of conversion rates or top 10/25 percent performance benchmarks. If the standard conversion rate is around seven percent, then we shouldn’t be actually estimating our strategy around 70 percent conversion. We need to think of other ideas.
We set an annual goal and we work with a 12-month retainer. We break it down into quarterly, smaller goals during the strategy session with the client.
We reverse engineer from the revenue goal all the way to number of deals created every month, leads and traffic. And this is where Databox helps us.
We actually set Alerts and Goals for every client on a weekly basis. So every week we’re getting the alerts of our progress towards the goal. It’s not just the number of how many leads we generated, but also like 75 percent away or 50 percent away. This is where we start the internal discussion of what we need to optimize, what we need to drill down into and understand what’s not working well.
We have the account manager, the “inbounders” (the people in HubSpot building the assets), the journalists (or content marketers) and UI designers, if we need to build pages or templates.
We have several types of meetings. Every team has a daily standup meeting. We have a sprint planning meeting and we have a weekly strategy meeting where we discuss the different dashboards.
When it comes to the metrics and the strategies, that is discussed in the weekly meeting. The team looks at the six clients they’re managing and their performance. The account managers are responsible
The account manager uses Databox. He or she gets the alerts on Slack and the daily scorecards.
We want to know how far from the goal we are. So, traffic, MQLs, SQLs, the numbered of leads created etc.
We’re sharing an email update that goes out to the client on a weekly basis with the key metrics and distance from the goal for that week. They get the weekly scorecard automatically from Databox.
Then, there’s the monthly meeting with the client. Since the client is already getting their data throughout the month, the monthly meeting is more of a strategy meeting. It’s more about discussing the meaning of the data and rather than just reading the numbers on the screen.
We usually we add our recommendations for next steps. For example, if there’s like a Facebook campaign, and some of the assets are not performing well, those are the ad sets that we’re turning off. We’re changing the audiences or refining them. So we put a recommendation about what we’re doing next and compare the results this week and the week after.
It depends. Some of them really enjoy drilling down into data and with some of them, it’s like we know that email is never opened until the monthly meeting.
It’s one of our key differentiators in the market. We’re not emotionally attached to our strategies and what we do. If the data shows what we’re doing is not working, we will trash it and pivot. I think the clients like that because it shows transparency. We’re not trying to hide any information or manipulate the data in any way.
Our retention year-after-year is getting better. The clients appreciate our culture of transparency, and Databox is one of the reasons behind that. One of the key differentiators is the whole data-driven strategy. We’re not really selling fluff.
We actually use Databox dashboards in the sales process. So we open dashboards and we show the clients how we work.
Want to get a firsthand look at how agencies like IDS use Databox to automate their client reports, set client goals, and much more? Sign up for one of our live agency demos.
We host them live every day.
Marketing | Feb 20
Agencies | Jan 15
Agencies | Nov 5 2018