You can copy and paste this into your own field. Then we can create a CASE statement like the one shown below. Next, open up our data source and click to ‘Add a Field’. The first thing to do is to create a new Data Studio report and add Google Analytics as our data source.
Now that we have an idea how it might be useful to split up our data let’s construct our CASE statement. We can see Twitter is a considerable driver of traffic too. We might also be interested in having Google searches from mobile as its own channel. That is clearly enough traffic to be a channel on its own. We can see that a huge amount of traffic is from Google searches on a desktop.
To figure out what types of channels might be useful, let’s look at a breakdown of traffic by Source/Medium and Device Category. Here’s a previous post about how to use CASE statements to create new geographic regions.īut before we create our CASE statement, the first step is to determine how we should divide up our data. This allows us to segment data based on the criteria we specify. To create our custome channel grouping we need to create a CASE statement. Deciding what custom Channels we should have This allows you to have control over how you view your data and without making any changes to the Google Analytics view itself. One way to get a around this is to create your own channel grouping using a CASE statement in Data Studio. Our other options are to look at Source, Medium or Source/Medium but they might be too complex. While this is fine for understanding our data, it might not be specific enough to have too much value. Google Analytics provides us with a Default Channel Grouping to understand how visitors arrive on our website.įor example, here’s a breakdown of the default channel grouping from a Google Analytics account. ClickInsight has a great article about how to create custom channel groupings in Data Studio and Seer Interactive have a great article on creating CASE statements in Data Studio. In this post I’ll discuss how to create custom channel groupings in Google Data Studio using CASE statements.īefore I begin, I’d like to mention that I’m not the first to write on this topic.
0 kommentar(er)
