View updates by feature or month

Date conditions in Custom dimensions

Written by Johannes Andreasson,
how many minutes?

Custom Dimensions in Funnel now supports for date conditions and conversions.

There are new "matches date" conditions that can be used with all date fields. This will help common patterns of working with non-aggregateable metrics or forecasting.

For example, using the when condition 'date matches last day of month or date matches today' in a custom metric can allow using month or lifetime non-agg metrics per month together with performance metrics per month.

There are also a number of new 'convert date' options in parallell with the existing convert text ones. These provide the same conversions that exist for the built-in date but can be applied to any field that has the unit "date" (for example from CRM, Organic or Google Sheets) in the same way.

In addition a number of new conversions have been added based on common usage patterns. For example 'to year week' can be used to correctly get a weeks year and week number. Another new useful conversion is 'to start of week' to allow directly visualising per week in time-series charts in different destinations.

Screenshot 2022-02-04 at 11.19.57Screenshot 2022-02-04 at 11.20.15

 

Topics: Data Transformation