In this blog post, I want to summarize the new releases from the Google tools, that we use daily in datadice. Therefore I want to give an overview of the new features of BigQuery, Data Studio, Google Analytics and Google Tag Manager. Furthermore, I will focus on the releases that I consider to be the most important ones and I will also name some other changes that were made.
With a new DDL statement, you can change the name of an already existing column. An example would be:
You have to address the table you want to change and then the original column name and the new name of the column.
When you are querying this table and changing columns, you must change the query to use the new names.
It is now possible, to add a default value for columns in new or already existing tables. When a new row has no data for a value with a default assignment, it gets the default value, instead of NULL. For E.g. inside a DML statement, you can set default values:
So with the DEFAULT parameter after the selected data type you can set a default value. After that in the inserts, you can use assign new values or use the default values.
As default values, you can use literals, but also some functions like
It is NOT possible to reference columns to do some kind of calculation like
def_int_3 INT64 DEFAULT def_int_1 - def_int_2
You can also change the defaults or delete this setting. You can check the documentation here for that.
Data Studio got some new features for the GA4 connector. Google already added two new kinds of properties for GA4. The sub- and roll-up properties.
Before the change, it was just possible to connect the default properties. Now it is even possible to add subproperties and roll-up properties to your dashboards.
There is a new API for Google Analytics 4 available!
With the Logging API, you can get data for accessing the data of the properties. You can see the IP or the email address of the persons who are looking at the different reports. Additional information like the report type which was accessed or the timestamp when the report got visited are offered.
This attribution black box model from Google got improved. The improvements come into action when the properties do have not much historical data or there is not much daily conversion data in the property. Then the final data of the attribution should be more accurate.
The GTM server-side tracking still needs a lot of improvements and this is one small step. The GAds tag got separate conversion value fields and the corresponding currency field.
If no conversion value is selected, it takes the “value” parameter of the selected event data you chose in the tag.
With this configuration, it is much easier to send your conversion data to Google Ads.
There is also a new feature for client-side tracking.
With the new “Tag Coverage” system you can observe which pages get tracked by the GTM container. This feature is automatically enabled and you see it in the admin section of your client-side container.
In the screenshot above all pages are part of the tracking. In the table, under the summary, you can scroll through all the pages which send tracking information.
The four metrics are the following:
It can happen that GTM does not know all the pages which are part of your website. If that is the case, you can add manually URLs or upload a CSV with URLs inside.
If you see some irregularities in your tracking this is an easy first check you can do, to see how good your tag coverage is.