This guide applies to the following error in Data Studio when users blend multiple data sources using "Date" as a joined key (note that you might need to click on "see details" to see this):
Quick links to sections below:
- How to check which data source uses compatibility Date & Time mode
- How to solve this issue
- Engaging support
The error message appears in the blended data source because of the new feature released from Data Studio. Data Studio has released a new Date & Time to replace the old compatibility mode Date & Time. Data sources created before September 15th, 2020 will have the compatibility Date & Time mode while data sources created after that have the new Date & Time mode. Unfortunately, the new Date & Type cannot blend with the old compatibility Date & Time.
More information on this feature: https://support.google.com/datastudio/answer/6401549
How to check which data source uses compatibility Date & Time mode
The compatibility Date & Time mode has the format of "Date (YYYYMMDD)":
The new Date & Time mode has a text format of only "Date":
How to solve this issue
- If native Google data sources have the compatibility Date & Time: You could upgrade the compatibility Date & Time mode in the native data sources following the instructions from Google Data Studio: https://support.google.com/datastudio/answer/6401549?hl=en#:~:text=Compatibility%20mode%20dates%20continue%20to,or%20Date%20%26%20Time%20data%20types
- If Supermetrics data sources have the compatibility Date & Time mode: Unfortunately, it is not possible to upgrade the old compatibility Date & Time mode in Supermetrics data sources created before September 15th, 2020. You'd need to create new data sources using Supermetrics connectors. The data sources that are created after September 15th, 2020 automatically have the new Date & Time mode.
If you experience the error message without using "Date" as a joined key or after you've upgraded the date field/ created a new data source, the issue still exists, please send us a new ticket for us to investigate the issue further.