To do this we can it our connection (by going back to the home page or by clicking on the pencil icon in the connection when iting any graph) and make some changes.
For this example we have made 2 small additions
On the one hand, using the metrics “Sessions” and “Sessions with interaction” we calculate a new metric “Sessions without interaction” as the difference between “Sessions – Sessions with interaction”
On the other hand, we have creat a regular expression that, bas on the screen size (Screen Resolution) of the users, we only want to capture the width of the screen. Finally, we generate a segmentation variable by page type using the CASE function.
With these 3 new data we can now create a table like this:
This shows us the sessions divid into Sessions with and without interaction by screen width and page typology. This report in GA would be impossible to create without resorting to advanc configurations, so we already have a powerful data modeling skype database advantage within Looker Studio itself.
For this type of task, we should review all the Looker Studio functions available to us and know what possibilities we can play with.
Particularly interesting for dimension manipulation are:
REGEXP_EXTRACT: This allows us to extract only a fragment of text from a dimension.
As we have seen in the example above. But it would also allow us to separate fields that have several values at once.
REGEXP_REPLACE: Allows us to replace one text with another
Ideal for making arrangements (for example: “FB” campaign, change it to “facebook”.
CASE: Allows you to specify values basic technical support for low priority bas on validations.
That is, we write values of the type
CASE WHEN A = B THEN «returns this» ELSE «returns this other» and therefore it becomes an ideal function for grouping.
To simplify, think of things like CASE yeezys shoes WHEN Page = «/» THEN «It is the home» ELSE «It is NOT the HOME» and then think bigger.