Cacher is the code snippet organizer for pro developers

MAX((SELECT MAX(IF(index=1, value, NULL)) FROM UNNEST(hits.customDimensions))) AS customerID

other dimension names:
pagetype, page ID, visitor type, customer default group, PRO user, visitor phase,
dynamic pricing, client type