![]() ![]() The green check indicates that your formula does not contain any syntax errors. In the formula field, you can define how your existing dimensions or metrics should be manipulated.įor your first calculated field, you might want to stick to the basics and just do a simple arithmetic calculation between metrics. a table)Įxample: Since we want to use our calculated field Goal Conversion Rate (All Contact Forms) in other reports as well and we do have the Data Source editor rights, we opt for a Data Source Calculated Field. Chart-specific calculated fieldsįor now, let’s go ahead and create a data source level calculated field.Īdd any chart to your page that can take multiple dimensions and metrics as inputs (i.e. Add a New Field to Your Data Source / Chartĭecide whether you want to create a Data Source or Chart Level Calculated Field with the help of our little comparison table.ĭata source vs. ![]() Some basic arithmetic in a calculated field will get us to the desired result. To create a Calculated Field Goal Conversion Rate (All Contact Forms) you will need one Google Analytics view as a data source, your individual goal completion metrics, and your session metric. However, in the dashboard they want you to report the Contact Form Conversion Rate for all three contact form goals combined. Define which data sources, dimensions, metrics, and functions you will need to create those.Įxample: Your client’s lead generation website has three contact forms that are each tracked as separate goals in Google Analytics. When you sketch your dashboard’s design, take inventory of all KPIs that are not directly available in a single data source. Step by Step: Your First Calculated Field Plan Your Calculated Field Chart Level Calculated Fields?Ĭhart level calculated fields can only be used on one particular chart however they work on blended data. What Are Data Source Calculated Fields?ĭata source calculated fields are added to the data source and can be reused in other charts, and reports. However, only Chart level calculated fields can be used on blended data sources. They are perfect for summarizing trends and answering business questions! Where Can I Use Them?Ĭalculated Fields can be used in any chart type. Pivot tables can also prove useful when presenting data. Presenting your data in the most user-friendly and unambiguous way is paramount if you want your stakeholders to trust your recommendations and take appropriate action on them. by concatenating hostname + landing page path) Whenever you want to present data that is not already available in your source data, calculated fields are your BFF. Why Use Calculated Fields in Looker Studio?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |