Date Ranges- Google Data Studio-(from Google Sheets & SM)-
I can get data from SM (Super Metrics) into Google Sheets- and then into Data Studio (GDS).
I have an issue with the treatment of dates. What is the best way to get dates for inclusion within Google Sheets- and then GDS?
(using a 2ndary dimension I was able to get some date specific data- but it is not really smart)
I need the data to show for any period range in the calendar of GDS. (e.g. last seven days, last 30D, last quarter, etc., etc.)
GDS has metrics and dimension fields which can be taken from the Google Sheet- after running SM. (I have seen some references to dates)
1. What are the best way/s to import data that is date sensitive?
Do I need lots of dates- or I can I use one period of all time by sufficient?
GDS has a calendar so it has lots of options for date specific analysis
I am not sure if I need to create calculated fields within Google Data Studio- by copying a single date range that is a metric or dimension from the import) (e.g. last seven days, last 30 days, last quarter).
How are GDS and SM smart enough to understand what date is for which specific period- within a mass of data? Is their metadata instructions?
Do you have any tutorials for using SM with GDS, and Google Sheets?
Or do you have specific information just about date ranges for Google Sheets- with SM?