Metrics seem to be occasionally coming through in date formats.
Thanks for contacting us, sorry about the issue.
It is unfortunately Google Sheets that tries to interpret the data, and reformats it after the results come in. Please select the column, and set cell formatting for example as "Plain text" or any other than date.
Does this solve your issue?
Heidi / Supermetrics