-
Pivoting multiple columns to one, while keeping correlating data
Ok pretty sure I need to creat a pivot table of some kind, to move data that extends in rows across an unknown number of columns, and bring it all into one uniform column. The problem I have is keeping the associated row data when you move the data into one column. See below ---> What I have: What I need: How do I do this?
-
FROM_UNIXTIME not returning any results
Just looking for a simple beast mode to convert Unix timestamps into date format. FROM_UNIXTIME(`FieldName`,'%m,%d,%y') This doesn't return any data despite being a valid formula. Everything I've found on the straight SQL function says this is correct and should yield a date. What am I missing? Thanks.
-
Importing Google Analytics Custom Dimensions
Wondering if there's a way to import Custom Dimensions created in GA. This used to be a feature in the beta version of the GA connector, but now all you can access are the static / predefined metrics and dimensions. Anybody know what's up?