<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1736999839848584&amp;ev=PageView&amp;noscript=1">
How to Create Smarter Digital Marketing Reports

How to Create Smarter Digital Marketing Reports

The ultimate guide to calculating digital marketing ROI

Can you do us a favor? Take a second and look at your to-do list.

If you’re like many in-house digital marketers, you’re probably busy crafting emails, posting updates on social media, writing content pieces, maybe even running a few Google ads.

You’re busy … but is any of your marketing working?

The thing is, we’re not the only ones asking that question – your boss is asking it too. And in a business era where everything is measured, your boss is not going to accept “We’re getting a lot of engagement!” as an answer. You need to show data. And you need to prove your marketing ROI.

That’s where marketing analytics comes in.

We’re going to teach you how to create digital marketing reports that will enable you to identify:

  • What’s going well and why it’s going well, so you can do more of it.
  • What’s not going well and why it’s not going well, so you can stop doing it.
  • What should be going well but isn’t, so you can troubleshoot and fix it.

First, we’ll cover why it’s so important to measure your marketing.

Then, we’ll dive deep into the three key fundamentals: knowing which digital marketing KPIs to measure, how to set digital marketing goals, and how to use your marketing data to make smarter marketing strategy decisions.

Lastly, we’ll show you an example of some real-life digital marketing reports we delivered for one of our own clients — and we'll talk through the decisions we made as a result of those reports.

Ready? Let’s get started!

Prefer to save this guide and read it later? Click here to download it!


Why Marketing Measurement and Reporting Are So Important

Introduction: Why Digital Marketing Reports Are So Important

Reporting gives you the data you need to steer your marketing strategy. If you're not properly analyzing your marketing to see what's working and what's not, you may as well simply throw noodles at the wall to see what sticks. You’re whistling Dixie. You’re rearranging deck chairs on the Titanic.

All right, enough analogies.

Essentially, your digital marketing reports should tell you and your marketing team what’s working and what’s not, in clear and measurable ways.

And that saves you a ton of time and effort:

  1. Instead of being pulled this way and that by the latest trends, (“Should we be on TikTok?”) you’ll have insights into which marketing strategies make sense for your company.
  2. If a strategy or content offer is falling flat, early data allows you to iterate and test, so you’re not sinking all your promotional dollars sending people to a landing page with a poor conversion rate, for example.
  3. Instead of being bogged down with ALL the data, you know which marketing KPIs matter, and you know what to do with them.

Beth Carter

"At Clariant Creative, we use marketing data with our clients to ask better questions, think more strategically, and make smarter decisions about the marketing we produce." 
— Beth Carter, Chief Strategist


OK, so now you know why gathering your digital marketing data and calculating your digital marketing ROI can make you a more efficient and effective marketer.

But how do you create the right digital marketing reports? By sticking to these three key analytics principles:

1. Know which digital KPIs to measure.
2. Set SMART marketing goals for everything.
3. Let your marketing data drive your decisions.


Know What to Measure

Know Which Digital Marketing KPIs to Measure

The best thing about digital marketing is that we can measure everything.

The worst thing about digital marketing is that we can measure everything.

Fortunately, you don’t have to measure every bit of data you get. There are, however, a handful of digital marketing KPIs that you truly need as a baseline.

Consider these marketing metrics your starting point – they’re like the vitals your doctor takes at a checkup. If any of these metrics show that something is off, that’s when you should dive deeper into the data, identify what’s happening and course correct.

When you’re measuring digital marketing effectiveness, you need to focus on two types of metrics: Business metrics and marketing metrics.

Business Metrics: Are We Growing the Business?

Business metricsReal talk: All of your marketing efforts need to tie back to company revenue in some way.

That means every marketing metric needs to ladder up to your business metrics. And every business metric should ladder down to specific marketing metrics. If your marketing strategy isn’t tied to the company’s overall goals, then what’s the point?

Let’s look more closely at the business metrics you should keep on your radar:

Sales Data

Your sales data is pretty straightforward. You’ll want to report on:

  • Total revenue
  • Revenue by product

Customer Data

For customer data, you should measure:

  • Total customers
  • Total new versus repeat customers
  • Customer acquisition cost

Understanding Customer Acquisition Cost (CAC)

Remember when we said that business metrics and marketing metrics impact each other?

It’s great to know you’ve closed 16 new customers, but how much did that cost you? Was it done profitably?

Customer acquisition cost is an important business metric because it tells you how much you spend on average to get every new customer. And it’s relatively easy to determine:

Marketing and Sales Costs =

(salaries, commissions, bonuses) + (software, agency fees, advertising spend)

CAC Example:

Marketing and Sales Cost = $2,000
New Customers = 16

$2,000 ÷ 16 = $125 per customer

Take all of your marketing and sales costs (i.e., how much you pay out to employees, software and agency fees, and your advertising expenditures) and divide that by the number of customers you acquire in a given time period.

In most cases, you want a low CAC. But there are legitimate reasons your CAC may be high or trending upward.

For example, startup companies can have high CACs because they have to spend more to acquire every new customer. The same goes for existing companies that launch new products or service offerings. However, if there’s no reasonable explanation for a high CAC, that’s when you start making adjustments.

In other words, you can’t look at your CAC in a vacuum. Measuring over time, monitoring trends, and considering other factors will help you see the big picture.

Now let’s look at marketing metrics.

Marketing Metrics: Are We on Track to Reach Our Business Goals?

Marketing metricsMarketing metrics help you understand if your marketing strategy is on track to achieve your business metrics. Think of this data like an early warning system – they help you spot problems before they impact revenue.

Marketing metrics also highlight where you’re hitting it out of the park. That’s where you add more fuel, step on the gas, and surge ahead.

Typically, we recommend tracking marketing data by channel:

  • Website Data
  • Digital Ads Data
  • Email Marketing Data
  • Social Media Marketing Data

You can see from this image that within each channel, there are a number of marketing KPIs you should measure. This is by no means an exhaustive list! Consider these KPIs your starting points to give you a feel for how well each channel is working or not working.

Marketing Metrics Chart

Each channel has specific KPIs to track that can help you understand how effective that channel is.

Website Data

Website metrics focus mostly on sessions and clicks.

A session happens when a user interacts with your site for a period of time. You may have heard the term “visit” – it’s the same thing. During a session, the user may visit multiple pages, interact with the site, make purchases or download content. A session ends when there’s no activity for 30 minutes or at the strike of midnight.

Clicks happen when a user follows a link on your website. You can find that data in your Google Search Console account.

Another helpful metric is bounce rate – how many people visit your website and just as quickly hit the exit. If your website is informative and engaging, the reader will stick around – translating to a low bounce rate. But if your bounce rate is high, that may be a sign people are not engaging with your content. Perhaps look at both your copy and the user experience; maybe people are bouncing because the page is a dead end with no navigation or CTAs?

Most marketers also track sessions by source, so it’s important to know that if a user visits your website organically, and, say, 15 minutes later they follow a paid search to your website, the organic session ends and a new session through the paid search begins. You can find total sessions and sessions by source in your Google Analytics account.

But wait! What about search rankings?

To be honest, most companies get overexcited about search result rankings. They spend hours poring over sites like Moz or SEMRush, shaking their fists at the companies in the coveted #1 spot.

But, it’s entirely possible to rank on the first page of Google for a great keyword and have zero clicks. In that case … Houston, we have a problem.

It’s not that we don’t think website ranking is a good metric – but it can be misleading. Instead, put context around those rankings by looking at your clicks per queries in Google Search Console. That will tell you which keywords are actually bringing in business.

Inbound Marketing Data

Speaking of keywords, inbound marketing is designed to attract new leads with the information customers are already looking for online.

Organic traffic volume tells you how many users found your website simply by doing a search on specific keywords. This measures your keyword effectiveness.

By tracking website leads that originate from the forms on your blogs, pillar pages, and pillar posts, you can evaluate which of your blog posts and specific content offers are generating more leads – and where you may need to make adjustments by switching gears or even optimizing existing blog posts.

Digital Ads Data

While many marketers like to measure the clicks their digital ads generate, your real goal with digital ads is conversions. Think of clicks as the equivalent to leading horses to water, but those horses have to drink for you to see any results. That’s where conversions come in.

But what constitutes a conversion? Is it a purchase, a registration, a download, a social media like or follow? In order to measure conversions, you need to know what you’re measuring for each digital ad.

Email Marketing Data

With email marketing, we look at clicks as well as opens. Both are important, but the holy grail of email marketing is when the reader clicks on an email link.

By measuring both clicks and opens, you can evaluate the effectiveness of your subject lines, your email content and your CTAs. If you’re seeing low open rates but high click-through rates, it’s probably time for some subject line A/B testing. If you have the opposite problem, the content of your email may be the problem.

Email list growth measures if you’re reaching more people. This metric isn’t even on the radar at many companies, and it should be: A bigger email list means more potential leads, more clicks, more conversions, more sales and more revenue.

Social Media Data

Generally, there are three metrics to focus on with social media. You may not get direct revenue out of likes, but they are a strong indicator of how engaging your readers find your content, which can work in your favor with the algorithms in these platforms, putting your content in front of more people.

Shares are the gift that keeps on giving. Not only do they extend your reach (for free!), they’re a great indicator of how buzzworthy the post is. If you notice a few people consistently sharing your content, you may be able to approach them with influencer or affiliate marketing ideas.

And clicks, as always, are key. Experiment with your messaging and monitor what changes result in better click rates.

Important: Capture Metrics Specific to Your Business

While the data and metrics we recommend makes for a great baseline, you may need other data points.

For example, at Clariant Creative, we have about 90% repeat customers, so the new versus repeat customer business metric doesn’t help us much. However, a software company concerned about customer turnover would find new versus repeat customers an incredibly valuable metric.

The best way to determine which metrics to measure is by looking at the numbers that will tell you whether or not your business is growing, and whether your marketing strategy is truly helping it grow.

EBOOK: Six Marketing Metrics You Can't Afford to Ignore


Create SMART Goals for Everything

Create SMART Marketing Goals for Everything

As you start gathering all the numbers from the marketing metrics we just reviewed, you’re going to learn things like this: Organic traffic generated 16 leads last month.

Is this good news or bad news?

When we create digital marketing reports, we're not just gathering numbers for the sake of the numbers themselves. We’re gathering numbers because those numbers need to tell us things.

And the way we get numbers to tell us things is to have a goal for every number we look at. And not just any goal – we need SMART goals.

What Are SMART Goals?

SMART goals are:







Having SMART goals for your metrics creates purpose for your marketing strategy, so you know exactly what you need to accomplish … and how close you are to accomplishing it.

Test your skills: Is this sentence a SMART goal?

We want to grow revenue from $10,000 in November to $11,000 in December.

It’s specific. It’s measurable. It’s relevant. It’s time-bound. So far, so good.

Is it attainable?

Well, maybe it is and maybe it’s not. That depends on your resources.

To figure out if this goal is attainable, consider how you’re going to adjust your marketing strategy and what you’re going to do differently in December (or maybe even in October or November, depending on how long it takes your business to land a new client). Maybe you need to double down on advertising, or you might have to create an email campaign – whatever makes sense for your business.

You can have a SMART revenue goal like this and ladder it down to your marketing tactics, deciding what you’ll need to do to hit this revenue goal.

Then, you can set SMART goals for each of these tactics. And by tracking them, you’ll have a clear view of whether you’re on track to hit the SMART goal of $11,000 in December. You’ll also get to see in real time which tactics are falling flat and which ones are a hit, so you can adjust your budget on the fly and maximize your results.

That’s how it all comes together.

Learn how to set the right marketing goals for your business.
Download your free SMART goals template!

Download Now

How Do You Set SMART Marketing Goal Targets?

Set Marketing Goal TargetsThere are three ways to set your SMART goal targets.

Preferred: Use Your Own Data

It’s always best to set your targets using your own data. Start by looking at your company’s past data, calculating averages over specific timeframes, and then using those averages as the basis for your new goals.

Next Best: Use Industry Benchmarks

Let’s say you don’t have much in the way of past data. Maybe you’re just starting up and you’re not sure what your goals should be. In this situation, industry benchmarks can be a good place to start.

The tricky part is finding comparisons across industry segments, geographic markets, business size and so on. For example, if you run a small consulting firm and you look at benchmarks for the entire professional services industry, is it fair to compare your company against behemoths like Deloitte?

It’s fine to use industry benchmarks as a gut check, but be mindful that you’re not comparing apples and oranges.

Now, if you’re looking for industry benchmarks, a good resource is eMarketer’s Insider Intelligence, which compares marketing performance across industry metrics.

Acceptable: Take a Guess!

OK, this may seem silly, but guessing which benchmarks to use isn’t the worst idea.

You can put a stake in the ground, set a goal, and do your best to reach it. Once you get more data, you can make adjustments to your goals and your guesses will become more educated and experience-based.

Now the question is, what do you do with the data you capture?


Act on What the Numbers Tell You

Let Your Marketing Analytics Drive Your Decisions

Like we’ve said a few times, you’re not gathering marketing data to satisfy some sort of analytical obsession. The point of this entire exercise is to determine if your business is moving in the right direction and your marketing strategy is helping you get there.

One of the biggest mistakes digital marketers make is focusing on point-in-time data instead of trends. Point-in-time data often doesn't have the context needed to be useful. You need your marketing analytics to answer questions such as, is your campaign performance getting better or worse? What trends are impacting your marketing ROI? Is a rogue data point just an outlier, or something more?

To make sure you’re capturing the complete analytics picture, set up a process and a schedule for gathering your metrics.

How Should You Capture Your Marketing Data?

To make sure your data steers you in the right direction, you first need to organize it.

You’re going to be comparing data to recognize trends, so you’ll need to record it in a way that makes those trends stand out. There’s no need to invest in fancy digital marketing reporting tools. A simple spreadsheet where each row represents a metric and the columns represent time will suffice.

If your business is using a marketing automation platform like HubSpot, you’ll be able to find (almost) all this marketing data right within your software. If you’re not, you’ll have to go into each account – Google Analytics, Google Search Console, Google Ads, your email tool and social media accounts – to gather this data.

Reviewing Your Metrics

Certain metrics lend themselves to much more frequent monitoring, while others are little more “set it and forget it.” For example, a paid social media campaign’s performance should be monitored daily. Just reoptimized an old blog post? It’ll take awhile to see real results, so monthly reporting should be fine.

At Clariant Creative, our Inbound Marketing Specialists have a comprehensive list of marketing metrics they track and discuss with clients on a weekly, monthly and quarterly basis. Depending on the timeframe, the goal and focus varies.

Weekly Metrics

Weekly metrics tend to be more tactical with a focus on wins to share and anything that needs to be fixed immediately. These include:

  • Recent email opens and clicks
  • Recent blog post views and conversions
  • Recent landing page views and conversions
  • Recently added or updated webpage views and conversions

Monthly Metrics

Our monthly conversations zoom out a bit and look at how well our clients are hitting their monthly goals. That’s when we talk about what’s working and what’s not working.

The questions you’ll want to answer are these: What should you keep, what should you kill, and what should you fix?

These three questions will give you the right context to evaluate each aspect of your marketing strategy, based on what the numbers tell you to do.

Keep, Kill or Fix

Quarterly Metrics

Quarterly reviews are considered the gold standard for when the rubber hits the road for any marketing team. By the end of a quarter, we have enough data to tell a story about how well our activities are fulfilling on a client’s goals. We use marketing metrics to plan future quarters, change course, confirm overall business goals, and take a general temperature of the marketing strategy.

  • We dive deep into new leads and whether they are MQLs and/or SQLs. We may look at new business opportunities and new customers that could mean a lot more business.
  • We evaluate how the heck these leads are finding our clients? What are the sources for web traffic, search queries, entry pages, the most opened and clicked emails, and which keywords are getting the job done?
  • We look at content to see what is resonating with leads using metrics like most visited webpages, blog posts and landing pages.
  • And, of course, we have to look at conversions based on webpages, blog posts, landing pages and even CTAs.


Putting It All Together: A Real-Life Example

Putting It All Together: Real-Life Digital Marketing Reports

For this example, we’ve pulled marketing data from a real Clariant Creative client. We measure a lot of digital marketing KPIs for this client, but for this example, we’re showing just a handful of the metrics we track.

You can see that this digital marketing report is just a simple spreadsheet. There are no bells or whistles, other than color coding, which makes it very easy to read and understand.

Real-life example

This client sells corporate wellness programs to large employers and health insurance plans. The best way for our client to reach their customers is through email, so we run a lot of email campaigns for this client. All of these campaigns link back to the client’s website.

Our goal with each of the emails we send is to have people open the emails, click on the links in the emails, and go to specific pages on this company’s website where we can educate them about all aspects of corporate wellness programs.

This is a big component of their marketing strategy, so let’s look at how well their email marketing and website strategies are working.

The Metrics

For this example, we’re tracking how many people come to their website, how many people come to their website via the emails we’re sending, email click-through rates, total new leads generated, and new leads generated from email campaigns.

The SMART Marketing Goals

For each metric, we’ve set targets based on the company’s 2020 data. You can see in the “Monthly Target” column that each target is specific, measurable, relevant and time-bound.

To make it easy for us to see whether we’re hitting these targets, we’ve set “conditional formatting” in this spreadsheet. If the number is equal to or greater than the target, the cell contents are green. If the number is less than the target, the cell contents are red.

What this Marketing Data Tells Us

If you notice, an interesting pattern appears across the months of April, May, June and July.

There’s a lot of red!

As a result, we have lots of questions and quite a few discussion points for this client:

  • Email is definitely not producing the ROI we anticipated. Why?
  • Was 2020 an outlier year and therefore not a good benchmark for 2021?
  • Are we sending too many emails and people are getting fatigued?
  • Should we change something about our emails to get more people to click through to the website?
  • Should we change something about our website to get more people to sign up for a demo?
  • Should we be concerned that we're not going to hit our year-end revenue goals?

Note that if we had only looked at the website sessions metric, we would have been in blissful ignorance.

But, because we have a great digital marketing reporting strategy in place, we can see there’s a problem to fix. That’s where the inquiry and troubleshooting begins.

We need to evaluate what we should keep, what we should kill, and what we should fix.

At the end of the day, that’s what your digital marketing reports should do – allow you to ask better questions so you can make smarter decisions. It allows you to focus your time, money, and efforts in the best way possible.


Set Your Business Up for Success with Free, Ready-to-Use Marketing Reporting Templates

Get Started with Ready-to-Use Digital Marketing Report Templates

By following the recommendations above, identifying your digital marketing KPIs, SMART  marketing goals, and using our simple process for evaluating your data, you’ll be well on your way to achieving your business and marketing targets.

To make it even easier for you, we’ve taken all of this information a step further and developed a digital marketing report toolkit that features pre-made monthly and quarterly marketing report templates in Excel to help you track the metrics that matter to your business.

Happy reporting!

Create killer reports - download our marketing report template

Share this guide: