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
Max Traylor on June 14, 2017 • 11 minute read
If you’re any good at driving traffic, leads and sales, you’ve had clients where the opportunity to increase budget naturally arises. They like the results and want more, better, faster. When the client asks, “How can we spend more to go faster?” you know what to do.
Likewise, you’ve probably also had clients – that no matter how much pitching you do – who will not spend another dime. They see agency services as an expense to be contained or worse, minimized. They just don’t trust that increasing spend will increase results.
But, most clients don’t live in either of these extremes. They’re not asking to spend more money and they’re not allergic to it either.
For these clients, the big question is: when and how should you apply your knowledge of what’s possible to justify investments in additional services?
My simple answer to those two questions:
Let’s get real specific on how I’ve helped 100s of agencies do this…
I divide marketing agency activity into two buckets: business process consulting and marketing services. Most agencies are seen as “marketing service providers”, but the most profitable ones are seen as partners in driving revenue growth for their clients as business process consultants.
You should strive to be seen as a business process consultant, first and foremost. Business process consulting provides long-term value for your client and long-term engagements for your agency. Here’s what a business process consultant does to differentiate themselves from every other run-of-the-mill marketing agency:
These activities build trust and establish your agency/account leader as a strategic partner and advisor.
On the other hand, marketing services always get commoditized. EVERY agency provides these services:
These activities are replaceable. Competition among service providers is constantly increasing.
Whatever you do, don’t let your firm be seen as a commoditized service provider who can easily be replaced.
Instead, get paid for your expertise like any good plumber does: Let’s say you pay a plumber $100 to repair your sink and they tap the pipe once to fix it. You’ve paid $1 for the tap and $99 for them to know where to tap.
I am probably NOT telling you anything you don’t already know. But I am surprised at how many agencies and entrepreneurs talk the consulting talk, but when it comes to what they sell, it’s commodities on a price grid – they walk the services walk.
Not sure where you fall on the expert versus commodity spectrum? Do this 2 minute self-assessment: Go look at your latest client proposal. Now scroll to the end where you have a cost associated with different activities and deliverables. Then, ask yourself: If your client were to look at what they are paying for, would they put you into the value bucket, or the commodity bucket?
Ok, now I’ve hopefully convinced you to position yourself in the non-commoditized, value-oriented bucket where you are expected to interpret results and make new prescriptions. It’s time to:
People tend to trust things that are objective. Data is objective. I trust gravity because I can observe it.
People also trust things that meet their expectations, since they can rely on them. Setting expectations that are borne out in the data is a great way to build a foundation of trust. Once you establish a pattern of delivering data, your interpretation of the data will also be trusted. The client learns to trust you because your Business Process Consulting is based on data.
Upselling requires you to interpret and analyze data, then make recommendations based on your conclusions.
But, marketers often get confused about the difference between reporting and analysis. Reporting simply means extracting the data and presenting it in a format that can be easily understood, whether that’s a PDF document, email, or a live-dashboard of data like Databox provides. Reporting can and should be automated, as Databox users know very well.
Analysis is a step beyond reporting.
It answers questions like:
The answers will lead you to changes in your scope of work and perhaps new services that justify a higher retainer.
If you’re a digital marketer, you’re probably swimming in data. And there’s no shortage of ways you can improve results.
In my experience, most clients have little interest in following the daily or weekly changes you make to their campaigns and creative assets.
And with many clients, you won’t have enough valuable data to make large upsell-worthy recommendations.
I recommend a quarterly cadence to making larger recommendations. The process I use with clients ALWAYS involves a plan before implementation, and analysis only after enough data has been gathered to be statistically significant. Quarterly recommendations fit well with this model.
The image below shows a model I recommend. I follow a 4 step process that answers the questions:
Step #4 is the all-important analysis piece, which happens at least quarterly.
(In case you were wondering, green boxes represent activity that fits into the “consulting” bucket, while yellow represents commoditized “marketing services”.)
Some larger agencies who usually serve larger companies do this on a monthly basis. It’s not a bad idea to pitch new ideas on a monthly basis if they don’t require a larger budget. You can save big, budget-changing things for quarterly consideration. When you show clients you’re using data to make recommendations, they get used to the idea that you’re bringing your expertise to the table and have more ways you can add value.
I remember the first time a client told me to simplify my recommendations. She wanted my 25 slide presentation to be cut down to just 3 slides! She needed to show her executive team the high-priority challenges and opportunities and gain buy-in for change.
I learned a lot from that client.
Now, I try to answer just a few simple questions each quarter that could potentially result in an upsell:
Answering these questions will create two opportunities to upsell:
2. Experiments with new distribution channels, like:
If you can’t tell yet, I’m a big believer in processes. I’ve built my business helping agencies and marketers define repeatable processes.
I’m also a big believer that agencies should develop their own processes as intellectual property.
But, sometimes, it doesn’t make sense to re-invent the wheel.
Below, I’m sharing my process and I’d welcome you to either use it or base yours off of it.
The key to my process is my Lead Quality report. It helps companies visualize their funnel and identify areas of improvement. Here’s a schematic showing it.
The image above was taken from a live analytics presentation I did for a private coaching group (link is provided at the end of this blog post).
On the left, I define what each lead “stage” means.
On the right I show where the majority of leads are getting stuck in the marketing process.
My analysis of this data for this client led me to conclude that not many leads are engaging with their product-based content. Instead, they get stuck reading educational blog articles and do not show further interest. As a result lead “quality” is poor, assuming you look at quality as a function of revenue value.
Because of this, there are a number of things I recommended this agency upsell to their client:
If you count up those recommendations, you’ll see it is only 230 words + 1 visual, but communicates the value of four potential new projects. That’s not bad for page 1 of a quarterly recommendations report.
Here’s a zoomed-in screen grab of a funnel showing the number of people who go from visitor to lead to marketing qualified lead to sales qualified lead to opportunity to customer. Databox’s funnel visualization also automatically calculations conversion rates, which are shown at the bottom of the image below.
I always recommend looking at lead engagement by marketing channel or traffic source as a second analysis.
Below is a snapshot of some example data and my analysis.
With this data, I found leads who:
… are more engaged than leads coming from email campaigns, paid search or social media.
Based on this data, these are the upsell opportunities the agency can offer this client:
If you want to do this type of analysis using HubSpot and Databox, here are some great 1-click templates:
You could also use Google Analytics to do this assuming you’ve setup conversion/goal tracking to capture when you generate a lead.
To reinforce the importance of analyzing lead quality and introduce the upsell opportunities, I use this simple 2×2 chart:
Visualizing your data and your recommendations are critical. Visualization helps generate buy-in. When a client stakeholder asks what they’re paying you for, it’s much easier to draw a circle on a visual representation of a funnel than to try to verbally explain how the campaign is having trouble converting a sales qualified lead to an opportunity. The thought alone makes me shudder.
There are multiple ways to grow an agency. But, once you’ve established yourself, the most impactful levers for agency growth are retention and upselling. In fact, I know many 10+ person firms who strive to acquire just 2-3 clients per year and put most of their energy towards servicing and upselling their existing clients.
To effectively grow your agency’s revenue and profitability through upselling, you must:
Want a deeper dive on these principles? Request access to my 6-part video series on upselling using data. The series includes an overview as well as 5 presentations dedicated to upselling specific marketing services:
Want some 1:1 help implementing these processes in your agency? Request some time.
Marketing | Feb 20
Agencies | Jan 15
Agencies | Nov 5 2018