Let’s analyze the table below:ġst row = the function returns the string “Direct” only if in the cells A2&B2 (I use the & sign to concatenate the two strings)are matching the regular expression. You basically have to use these functions to define the rules you built in Analytics for your Custom Channel Grouping. NOT()it returns the opposite of a logical value NOT(TRUE) = FALSE or NOT(FALSE) = TRUE.AND()the function returns TRUE only if all the arguments are TRUE.IFS()like the IF function, but it evaluates multiple conditions.REGEXMATCH() if the text matches the regular expression the function returns TRUE.Now you have to add an empty column where you’ll add some Spreadsheets functions to determine the channel name of every row (I use Source/Medium/Campaign to determine the Channel Grouping). The add-on will create a new sheet where you’ll find all the data (make sure to generate an unsampled report!). Change the date range and click (TIP: check out this page because I usually use functions like Today() or Yesterday() for the date range) on Run Reports. After the setup, you can click on Create Report.ģ. The dimensions Campaigns and Source / Medium are fundamental for this tutorial. Now you have to select the right Google Analytics account and choose the Metrics and Dimensions you want to have. Go to Add-ons > Google Analytics > Create a new report and the reports builder should appear on the right-hand side.
You’ll use it to pull the data directly from the Google Analytics database into the Sheet.ġ. How to recreate a Custom Channel Grouping in Google Spreadsheetįirst of all, you have to open Google Spreadsheets and install the Google Analytics Add-on. The problem is that the Data Studio connector and the Sheets add-on are based on the Google Analytics API – and currently, it’s not possible to use a Custom Channel Grouping as a dimension. I usually use Google Analytics Add-on for Sheets or I connect the account with Google Data Studio where I have my own templates. As a marketer, one of the first things I do when I start to work with a new client is to check the Acquisition Report in Google Analytics – because it gives me an idea of the marketing activities and the performance of every single channel.
0 kommentar(er)
