title: Connecting Google Analytics clientId to BigQuery fields
body: <p>I wanted to resurface this <a href="https://stackoverflow.com/questions/31465418/trouble-mapping-a-ga-client-id-to-a-bigquery-fullvisitorid">question</a> since I couldn't find a good answer. </p>
  
  <p>How do you match the dot-separated clientId (see link google analytics <a href="https://cloud.google.com/solutions/google-analytics-bigquery" rel="nofollow noreferrer">section</a>) in Google Analytics to fields in BigQuery? I'd expect the clientId to be the fullVisitorId, but it isn't. The clientId is in the form 1234567890.9876543210 where the last ten digits are the visitId in BigQuery. </p>