Google Big Query Invalid time zone: +0000
Community wiki answer originally left by the question asker as a comment:

The fix was removing the timestamp formatting from FORMAT_TIMESTAMP

TIMESTAMP(FORMAT_TIMESTAMP("%Y-%m-%d", PARSE_TIMESTAMP("%Y%m%d", ga.date )))