Get your Custom Channel Grouping and Content Grouping using Data Studio in 10 Minutes

Hey there! Today I am going to cover really helpful Quick Hacks for Data Studio.

1. Create custom channel grouping
2. Content grouping in data studio

1. Create Custom Channel Grouping

Custom Channel Grouping! Seems like a familiar phrase? Naah! Please, refer to Google’s Document for Custom Channel Grouping.

If you have created Custom Channel Grouping in Google Analytics, you would have noticed that they are not available in Data Studio when you connect.

However, you can create the Custom Channel Grouping in Data Studio using calculated fields.

Configuration of Custom Channel Grouping in Data Studio:

1. In your Data Studio, create a new calculated field.
2. Create the new dimension with the following CASE formula:

In the above CASE formula, each WHEN condition contains custom channel group.

To adjust the particular channel definition, change the condition in the WHEN clause.

To add new channel definition, add WHEN … THEN clause.

Note that the WHEN clauses above are processed in the order. So, a given session will be grouped into the first channel definition that is matched.

Image : Custom Channel Grouping

2. Content Grouping in Data Studio

Content Grouping allows you to group the content of your site’s URL. For Example, you can see the aggregated number of page views for all pages in a group.

Unfortunately, Content Grouping is not retroactive. The Content Groups that you create are valid only from the date of creation.

It takes about 24 hours after you create a Content Grouping to reflect in your Google Analytics reports. However, in Data Studio, you can overcome this drawback, by creating calculated fields.

Configuration of Content Grouping in Data Studio follow the below steps: 

In your Data Studio, create a pie chart. Create a new calculated field, to add new custom dimension.

Image: Create new calculated field

Enter the Name of Calculated field and paste the following CASE formula:  

Image : CASE Formula for Content Grouping

Now change the dimension value to the newly created calculated field.

Image : Set the dimension “Content Grouping” calculated field 

Exclude the “other” pages for the report.

Image : Apply filter with excluding Content grouping “Other” pages

Provide the date range, from which date you want to see the past data. Finally, your report is ready, where you will see your sites URL’s grouped

Happy insights to you :)