It is necessary to analyze the data by the source from which the user came to the site. The lower function solves the problem with upper and lower case, but does not solve the problem of different names of one source. For example, Facebook can be found in the following variants: “facebook”, “m.facebook.com”, “l.facebook.com”, “facebook.com”, “lm.facebook.com”, “fb”.
To bring all these values into a single format, you need to use the case when function
To avoid duplicates in the parameters list to data you should leave only the newly created field.
By specifying all possible variations of a particular source in the when condition, you can bring them to a single format.
Another big advantage of the case operator is the ability to specify a condition using regular expressions. In this case, the regexp_extract, regexp_match, regexp_replace functions are used simultaneously.
To analyze statistics by page types, the condition will look like this.
When filling in the function conditions, the data is automatically checked, which eliminates the possibility of error. The system also offers available options when selecting fields on the basis of which a new parameter is created, and displays hints for the correct input of the initial data.
User groups
They allow you to create individual user how does new lazada chat response rate response segments without CASE or SQL. This is especially useful when you need to assign fixed labels or categories to values that meet specified conditions.
For example, you have a report on new users by country that you want to break down by region of the world.
There is no such parameter among the data sources. You can create a custom group and combine certain countries into the corresponding parts of the world. To do this:
- In the right pane, select Options and click Create Group.
- Set the required parameters.
- Apply the newly created field.
ConclusionsCalculated fields in Looker Studio make it easier to analyze your data by allowing you to create additional dimensions and metrics.
- Calculated fields support several europe email data types: numeric, text, date and time, logical, geographic data, currency.
- Using calculated fields, you can perform both the most basic calculations and actions, as well as complex functions.
- Lower is one of the most common functions for working with text data, which converts text from uppercase to lowercase.
- regexp_extract, regexp_match, regexp_replace, regexp_contains are four functions that allow you to use regular expressions to create new variables and parameters.
- The case statement is most often used to create new categories or groups of data.
- Custom groups help you aggregate data based on existing dimensions, making reports easier to analyze and more informative for marketing purposes.