Construct a Content material Efficiency Dashboard With Google Looker


With so many nuances to content material, from distribution to format to the customer’s journey, you could take a drill-down strategy to your analytics. Assess efficiency from a chook’s eye view after which break it into a number of views.

This course of lets you really grasp the elements of content material and distribution that contribute to your overarching content material targets.

You are able to do this in a number of methods, however probably the most efficient is a real-time dashboard created by Google Looker, which integrates seamlessly with Google Analytics 4.

Let’s discover the constructing blocks of content material measurement and stroll by a Google Looker dashboard. The free template may also help you measure, justify, and brag in regards to the nice affect content material has on what you are promoting.

What metrics to research

Earlier than you construct an analytics dashboard, you could determine the important thing metrics that align along with your content material’s function. Your content material’s breadth makes it a strong device to have interaction audiences at a number of touchpoints, nurture relationships, and encourage them to behave. Nonetheless, your particular targets rely on the character of your services or products, the shopping for cycle of your clients, the connection you search along with your viewers and different components.

Among the many frequent aims and corresponding metrics:

Goal Key Efficiency Indicator
Model consciousness Web site guests
Web page views
Model engagement Engaged classes
Lively customers
Common session length
Common time on web page
Bounce charge
Buy consideration Return guests
Product web page views
Checkouts initiated
Leads generated
Purchases/conversions Distinctive purchases
New shoppers

Consider content material AND distribution

To judge your content material’s effectiveness towards its enterprise function, it’s worthwhile to assess the 2 sides of the coin — the content material and the distribution. Measuring the efficiency of content material with out contemplating the context of who noticed it and beneath what circumstances can be like evaluating the standard of a automotive based mostly solely on its high velocity.

You additionally should assess who had the chance to see the content material. For instance, chances are you’ll decide one weblog submit resonates stronger than one other as a result of it noticed twice the site visitors. However, upon additional examination, you uncover the weblog submit that carried out higher had higher distribution. The CEO shared it on LinkedIn, however the poorer performing submit wasn’t promoted in any respect. In that case, metrics, equivalent to web page views and common engagement time, don’t function the very best indicators to determine your strongest-performing content material.

Alternatively, a bit of web site content material might need a excessive site visitors depend however low engagement. You might first assume the content material missed the mark, inflicting folks to depart your web site at alarming charges. Nonetheless, while you dig into the distribution, you see the majority of that low-engagement site visitors got here from a digital advert with poor focusing on. The content material appeared like a failure, however the distribution technique is what failed.

Inspecting the content material and distribution in tandem lets you determine the true strengths and weaknesses of your technique and keep away from making inaccurate assumptions based mostly on incomplete data.

Armed with this holistic view, you’ll be well-equipped to construct a strong measurement program that permits data-driven decision-making and steady enchancment.

Consider the accessible metrics

To drag collectively all of the related information in a single place, think about the free model of Google Looker. It helps you to create a number of tabs in a single report and customise the look, really feel, peak, and width of your information views.

On the primary tab, create a holistic view of your content material. I’ll clarify the way to do it technically later. The primary function of this part is to reply the query, “Is the model’s content material attaining what it’s designed to do?”

To exhibit that, choose metrics associated to your content material targets. In case you take a full-funnel strategy to content material, you must embrace KPIs at totally different phases of the consumer journey. However in case you give attention to content material for a single function, use these related metrics.

This record from Google encompasses dozens of accessible metrics. A number of the commonest ones are included on this chart:

Metric title Definition Part
Classes Any time a consumer arrives in your web site Consciousness
Views Variety of pages visited Consciousness
Complete customers Complete quantity of people that visited your web site Consciousness
New customers Complete quantity of people that visited your web site for the primary time Consciousness
Returning customers Complete quantity of people that initiated a couple of session Engagement
Engaged classes Variety of classes lasting at the least 10 seconds, had at the least one key occasion, or included at the least two web page or display views Engagement
Common session length Common seconds of customers’ classes earlier than abandonment Engagement
Bounce charge Not engaged classes divided by whole classes (proportion) Engagement
Engagement charge Engaged classes divided by whole classes (proportion) Engagement
Views per session Complete views divided by whole Classes Engagement
Classes per consumer Common variety of engaged classes per consumer        Engagement
Lively customers Variety of customers leading to an engaged session Engagement

Construct a Google Looker dashboard

I’ve included a Google Looker template that will help you rise up and operating along with your content material measurement program. To make use of this dashboard along with your web site information, click on on the three dots within the higher right-hand nook and choose “Make a replica.”

Google Looker downloadable template.

You may be prompted to switch the pattern GA4 information supply (unique information supply) along with your analytics (new information supply):

Prompt to replace the sample GA4 data source (original data source) with your analytics (new data source):

You now have a dashboard able to populate.

As I stroll by this instance, please know that some metrics is not going to carry over into your model as they’re proven under as a result of the pattern information isn’t essentially arrange as yours. To repair that, choose every metric and chart and substitute them with the specified dimensions on the right-hand menu. From right here, it’s also possible to change the visualizations, show, and elegance of your information.

Create government content material dashboard

The primary tab of the dashboard consists of the template for the chief abstract. It compares the chosen KPIs (listed on the high) to the earlier interval. Stakeholders can simply see adjustments in key metrics that could be disrupting or enhancing your content material efficiency.

On this pattern content material measurement dashboard, the KPIs embrace energetic customers, classes, engagement charge, bounce charge, common session length, and conversions. Under every quantity is the change proportion in purple (destructive) or inexperienced (constructive). It additionally features a chart exhibiting the comparative classes over time.

n this sample content measurement dashboard, the KPIs include active users, sessions, engagement rate, bounce rate, average session duration, and conversions. Below each number is the change percentage in red (negative) or green (positive). It also includes a chart showing the comparative sessions over time.

The manager dashboard additionally consists of charts and graphs for brand spanking new vs. returning customers, common views per session, views by web page and channel, guests by location, classes by channel, and extra.

The executive dashboard also includes charts and graphs for new vs. returning users, and average views per session.
Chart shows views visitors by location, and sessions by channel.

This dashboard tracks the web site. If you wish to observe solely content material pages, equivalent to your weblog, add a page- or report-level filter.

So as to add a filter that applies to all tabs on the dashboard, go to the highest menu and choose “File” then “Report Settings.” A column will open on the appropriate aspect of the dashboard. Choose “Add A Filter” on the backside.

The method is comparable for page-level filters, however they solely apply to the present tab. To create a page-level filter, go to the highest menu and select “Web page” then “Present Web page Settings.” A column will seem on the appropriate. Choose “Add A Filter.”

From right here, the page- or report-level filter course of is similar. Choose “Create A Filter.” A field will pop up on the backside.

In case your web site makes use of a breadcrumb taxonomy or different technique to distinguish amongst content material varieties, create this filter by choosing “Web page path.” Then, choose “Embrace” within the first drop-down field and “Comprises” within the second field. Add “weblog” or no matter key phrase seems in all of the URLs designating that content material sort within the third field.

Select “Page path.” Then, select “Include” in the first dropdown box and “Contains” in the second box. Add “blog” or whatever keyword appears in all the URLs designating that content type in the third box.

TIP: If the content material sort consists of a number of key phrases, choose the “And” or “Or” that seem subsequent to or under the standards.

This 30,000-foot view paves the best way for extra targeted visualizations to pinpoint the needle movers in your content material. You aren’t solely poised to speak content material efficacy to your stakeholders but additionally equip your self with the data wanted to meaningfully interpret extra granular insights and translate them into actionable optimizations.

Drill down into channels

Now that you’ve got established the massive image, it’s time to drill down into what drives that affect. By isolating content material and site visitors by channel, you’ll be able to take away the anomaly round viewers origin and intent and perceive the content material’s efficiency throughout the context of its distribution.

Relying on how deep you need to go and what number of channels drive your site visitors, chances are you’ll create particular person channel sections inside one tab or designate particular person tabs to research every channel.

Within the template, the “Channels” tab tracks how totally different channels contribute to content material views and engagement. Underneath the label “Channels Over Time” seems a chart exhibiting energetic customers by channel (referral, direct, natural social, natural search, electronic mail, and unassigned) for the previous 4 months. I selected the energetic customers metric as a result of it doesn’t depend bot site visitors, which usually lands on and abandons your web site instantly.

It additionally exhibits a pie chart of channel contributions to point out the share every channel contributes to energetic customers.

Under the label, “Channels Over Time”, appears a chart showing active users by channel (referral, direct, organic social, organic search, email, and unassigned) for the past four months. It also shows a pie chart of channel contributions to show the percentage each channel contributes to active users.

Then, it features a channel breakdown chart. It particulars energetic customers, new customers, classes, and common session length by channel. It additionally features a top-pages-by-channel chart, figuring out the preferred web page titles visited by energetic customers coming from every channel.

Channel Breakdown Chart. It details active users, new users, sessions, and average session duration by channel. It also includes a top-pages-by-channel chart, identifying the most popular page titles visited by active users coming from each channel.

These information views present a complete understanding of how every distribution channel contributes to the content material’s attain and engagement, permitting you to make knowledgeable choices about the place to focus your efforts for max affect.

Pinpoint granular content material efficiency

You can also drill right down to content material web page efficiency. The side-by-side comparisons may also help you determine what messages, content material varieties, and themes are working for what you are promoting.

Within the template, the third tab is “Content material Efficiency By Web page.” It lets you analyze the efficiency of particular person content material items, equivalent to weblog posts, articles, or touchdown pages. The visualization on the high of the web page consists of most of the similar metrics as the chief dashboard, equivalent to classes over time, common views per consumer, and new vs. return customers.

You should use the page-title management on the high (extra on that within the subsequent part) or a page-level filter to look completely on the content material pages.

Content Performance By Page: The visualization at the top of the page includes many of the same metrics as the executive dashboard, such as sessions over time, average views per user, and new vs. return users.

On the backside of the tab, you’ll be able to see two views — web page efficiency by channel and content material web page breakdown. The previous exhibits probably the most considered pages, layering within the channels that drove site visitors to them, whereas the latter breaks down the core metrics for every web page, together with energetic customers, new customers, views, and common session length. 

You can see two views: Page performance by channel and content page breakdown.

By inspecting the efficiency of particular person content material items and understanding which channels are driving site visitors to them, you’ll be able to achieve invaluable insights into what sorts of content material resonate along with your viewers and the place they’re more than likely to have interaction with it. This data may also help you refine your content material technique, prioritize subjects and codecs that generate probably the most curiosity, and optimize your distribution efforts.

Slicing and dicing with information controls

No matter whether or not you select to drill down by channel, content material sort, or one thing else, you’ll be able to layer in additional granularity by including user-friendly drop-down controls to your dashboard.

These controls let dashboard viewers slice and cube the info by dimensions, equivalent to date vary, location, demographics, web page title, web page categorization, site visitors supply, and extra. For instance, in case you created your Google Looker tabs to give attention to the channel, you’ll be able to add a content material management to see how a selected channel contributes to the efficiency of particular pages. You may add these controls for any area accessible in Google Analytics.

To include this function, click on on the “Add a management” icon within the enhancing menu on the high of the dashboard. Choose “Drop-down record” from the menu.

Click on the “Add a control” icon in the editing menu at the top of dashboard. Select “Drop-down list” from the menu.

You may place the management anyplace on the dashboard. Sometimes, they work properly on the high.

Now, on the appropriate, designate the sphere and metric from the menu.  Click on on the “Management area” to decide on the filter dimension, equivalent to “Web page title,” “Touchdown web page,” “Supply/medium,” or “Metropolis.”

Then, within the drop-down management, select the metric of your filter dimension to type. Click on on the “Metric” area within the properties panel. For instance, in case you’ve chosen “Web page Title” as your dimension, you may select metrics like “Classes,” “Customers,” or “Views.” The designated metric can be used to calculate and show the info in your visualizations based mostly on the chosen dimension. In case your dimension is web page title and the metric is classes, the drop-down management will present the overall variety of classes in descending order.

Alternatively, if you’d like the dimension to show alphabetically, don’t designate a metric for the management.

Choose the filter dimension, such as "Page title,".

By offering this stage of interactivity, you’ll be able to cater to the various wants and questions of stakeholders whereas sustaining a clear and targeted dashboard design.

Your content material measurement journey: From insights to affect

Like anything in digital advertising and marketing, content material applications should be extremely dynamic and adaptable to drive actual affect. What’s efficient in the present day will not be the very best technique tomorrow, however companies that aren’t measuring their content material efficiency have a tendency to simply chug alongside, none the wiser.

It’s time to get off that content material choo-choo prepare. Arm your self with information, sharpen your strategic instincts, and prepare to dominate the content material sport. The longer term belongs to those that not solely create nice content material but additionally have the knowledge to measure its affect. Will you be amongst them?

Deliver your group to Content material Advertising World this October for inspiration, concepts, and actionable recommendation on growing and executing a technique that drives revenue for what you are promoting. Group charges can be found. Register in the present day

You may study a lot extra from the voices of expertise in content material advertising and marketing. To subscribe to the every day or weekly updates, go to or click on the orange subscribe button on the high of any web page.


Cowl picture by Joseph Kalinowski/Content material Advertising Institute