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 Google Data Studio?
0 Comments
Leave a Reply. |