title: Best way to measure transactions completed and conversion rate in Google Analytics - Big Query?
body: <p>I'm new to google analytics and wanted to make sure I was doing this accurately. I have a sample table</p>
  <p><a href="https://i.stack.imgur.com/XI0NM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XI0NM.png" alt="enter image description here" /></a></p>
  <p>Since I do not have too many rows (about 5000 rows only) I just created a pivot table in excel.</p>
  <p>I counted how many visitors had an action type of &quot;6&quot; which is 'completed purchase' in GA terminology. I used visitId so that I can capture conversion rate based on all visits.</p>
  <p>My result would look like this:</p>
  <p><a href="https://i.stack.imgur.com/JZHs5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JZHs5.png" alt="enter image description here" /></a></p>
  <p>Is this the best way to do it? Am I missing anything?</p>