To do this, we will go to docs.google.com spreadsheets , a page dicat to Google spreadsheets, although you all know that it can also be access through Drive.
Google Sheets allows add-ons
Which are like Excel macros but programm in Javascript and with access to APIs. The best thing about these add-ons is that we have a gallery from which we can import those made by third parties or by Google itself. To do this, we only have to click on the menu Extensions > Add-ons > Download Add-ons.
Inside the gallery we should look for the
Google Analytics plugin. It is quite easy to find as it is one of the TOP plugins.
We incorporat it and from then on in the line data Add-ons Menu itself we will have a new option call “GA4 Reports Builder for Google Analytics™” with 3 options: Create Report, Run Report and Help.
We click on “Create new report”
A new Sheet will be creat with our report template. In this Sheet, each column is a query to the Analytics API, and in each row we must indicate the value of the data that we would request from the GA API.
The select day range and the combination of different
Dimensions can affect the quality of the data obtain from the Analytics API, whether in its free or premium version. The application of sampling and cardinality limitations, which classify excessive values under the “other” category, increase is it possible to monetize an app? with the amount of data request.
This requires a balance between maintaining
Data quality and expanding the day range to improve the functionality of our dashboard, offering flexibility in date selection without compromising the accuracy of the analysis due to sampling and cardinality grouping.
Dimensions should always include “date” at a minimum:
Looker Studio dashboards work much better when they yeezys shoes have a date range to associate the data with.