Date Format

[Jeff Taylor]

Anyway for the plugin response to return something other than the Google Analytics format of yyyymmdd? It appears Google Spreadsheets doesn't recognize that as a date. Or do I need to set up some formulas in the target report spreadsheet to do the conversion for me?

[Philip Walton]

The add-on should be converting YYYYMMDD values to YYYY-MM-DD for all dates. Sheets should be able to recognize this format for all locales. If this isn't working for you, perhaps you've customized something or have a non-standard setting turned on?

On Tue, Mar 17, 2015 at 7:30 AM, Jeff Taylor <jtgo...@gmail.com> wrote:

Anyway for the plugin response to return something other than the Google Analytics format of yyyymmdd? It appears Google Spreadsheets doesn't recognize that as a date. Or do I need to set up some formulas in the target report spreadsheet to do the conversion for me?

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/068b424a-bc8c-49b6-840c-e68642bbafc4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[crockan...@gmail.com]

In the event anyone else has this issue, the reason this happens is because ga:Date is used instead of ga:date. Capitalizing the "D" causes the date field to appear as yyyymmdd which will not be recognized as a date.