How to assess the effectiveness of product categories, client segments, and landing pages
Vlada Malysheva, Creative Writer at OWOX BI
Vlad Flaks, CEO OWOX
Marketers are interested in a lot more than just the most efficient way to invest money. For example, they want to know:
- Which items or categories are more profitable to promote?
- What is more profitable for business — attract new clients or motivate existing clients to make purchases?
- Which content pages convert visitors to buyers best?
In this article, we explain how to find answers to these questions using OWOX BI. This service automatically imports cost data from advertising sources to Google BigQuery and distributes it to sessions. This lets you know how much you spent on each session, as well as group costs and revenues by the user, cohort, or landing page. This helps to evaluate the effectiveness of campaigns aimed at returning old users or attracting new ones, while planning the budget for different categories, regions, and segments.
If you want to analyze ROAS not only in terms of campaigns but also other parameters important for your business, sign up for a demo - we show you how to solve this problem with OWOX BI.
30 handpicked Google Data Studio dashboards for marketersDownload now
The efficiency of types of goods
Attribution is designed to objectively link efforts and results. This allows you to understand the best efforts and best allocate available resources. The question is, what kind of effort does attribution rate?
Digital marketing attribution is the most common. In this case, expenses and revenues from advertising campaigns are compared. For example, you can see that the most cost-effective advertising campaigns are 1 and 4:
But apart from allocating the budget to advertising campaigns, there are other ways to boost sales. For example, determining which groups of goods are more profitable to promote. This is important because an item that attracts a user is not necessarily the same item the user buys.
The report above shows that the "Bukinistika" category successfully attracts users who then move to other categories and buy goods there.
To find the most cost-effective product categories to promote, you need to group your online marketing costs into categories. This cannot be done in standard Google Analytics reports because expenses are available in terms of UTM tags, which are properties of advertising campaigns.
However, this can be done with OWOX BI, which transfers spending data from Google Analytics to Google BigQuery and distributes it to all sessions with UTM tags. That is, both expenses and income, in this case, are properties of the session. The report shows that it's most profitable to promote categories 2 and 4:
The efficiency of user segments: new and returned
A similar need to group advertising costs by user segment arises when a business seeks a balance between growth and profitability.
It's worth noting that the returned buyer is not the same as the returned visitor. In Google Analytics, such a report cannot be built because the cost data cannot be associated with specific users, much less combined with CRM transaction data.
Such a report can be built on data collected with OWOX BI, since expense and revenue are properties of the session, and the session has a userId for which it can be linked to a customer segment:
The efficiency of landing pages
Marketing may also be interested in which topics are most popular with audiences. If content marketing spending is a significant part of the budget, you can estimate its profitability and choose the most profitable section for promotion:
The example above shows that it's more cost-effective to attract customers on topic 2, and the least cost-effective is to convert visitors on topic 5. Such a report can be constructed more than once because cost data is known at the session level and the landing page is a property of the session.
How to count ROAS in terms of categories, users, landing pages
- Set up automatic cost data import from different advertising services to Google Analytics.
- Configure the collection of raw unsampled user behavior data from your site to Google BigQuery.
- Upload transaction data from your CRM system to BigQuery.
- With simple SQL queries, create the reports you want in BigQuery and visualize them in Google Sheets, Google Data Studio, OWOX BI Smart Data, or any other tool you know.
OWOX BI has a trial period - you can try for free how it works.
With reports based on data collected with OWOX BI, the marketing team is able to manage performance not only based on the budget of advertising campaigns, but also based on customer segments, product groups, landing pages, and any other session properties.
Find out the real value of campaigns
Automatically import cost data to Google Analytics from all your advertising services. Compare campaign costs, CPC, and ROAS in a single report.