Organize the requirements
Posted: Thu Jan 23, 2025 6:23 am
How you use it is up to your ideas, but I'll explain three examples that I think many companies can use. Creating a report from a Google spreadsheet By connecting a Google spreadsheet that manages your sales results to Looker Studio as a data source, you can analyze your sales situation from various perspectives. When graphing collected data, you specify "dimensions" and "metrics." Dimensions specify the range in which the data is divided. For example, if you set the metric to sales volume and the dimension to "date," you can create a graph that shows "sales volume by day.
" If you set the dimension to "Product Name," you vietnam telegram phone number list can graph "Sales volume per product." By combining these two, you can create a variety of graphs. Summarizing Google Analytics analysis information into reports By linking Google Data Portal and Google Analytics, you can compile analysis information into reports. By selecting a combination of "dimensions" and "indicators," you can compile a variety of analysis information into reports. For example, if you set "Page" as the "Dimension," you can get data for each page.
Then, if you set the indicator to the information you want to know, such as sessions or exit rate, you can create a report that visualizes "access and exit rate for each page." \If you haven't yet migrated or installed GA4, check out these materials! / Understand search trends with Google Search Console This is a way to understand the search situation by integrating Looker Studio with Google Search Console. To track the ranking of each keyword monthly, go to the Pivot table and select the column dimension "Date", row dimension "Query", and metric "Average Position".
" If you set the dimension to "Product Name," you vietnam telegram phone number list can graph "Sales volume per product." By combining these two, you can create a variety of graphs. Summarizing Google Analytics analysis information into reports By linking Google Data Portal and Google Analytics, you can compile analysis information into reports. By selecting a combination of "dimensions" and "indicators," you can compile a variety of analysis information into reports. For example, if you set "Page" as the "Dimension," you can get data for each page.
Then, if you set the indicator to the information you want to know, such as sessions or exit rate, you can create a report that visualizes "access and exit rate for each page." \If you haven't yet migrated or installed GA4, check out these materials! / Understand search trends with Google Search Console This is a way to understand the search situation by integrating Looker Studio with Google Search Console. To track the ranking of each keyword monthly, go to the Pivot table and select the column dimension "Date", row dimension "Query", and metric "Average Position".