Learning Google BigQuery

Making a scatterplot in Data Studio

The following steps show how to make a scatterplot in Data Studio with the data from BigQuery:

1. Update the original query by adding the transaction metric. In the edit screen of your report, click on the bar chart to bring up the chart options on the right-hand-side navigation. Click on the pencil icon next to the data source titled BigQuery to edit the data source.
2. Click on the left-hand-side arrow icon titled Edit Connection:

3. In the dialog titled Enter Custom Query, add this query:

SELECT trafficsource.medium as Medium, COUNT(visitId) as Visits,SUM(totals.transactions) AS TransactionsFROM `google.com:analytics-bigquery.LondonCycleHelmet.ga_sessions_20130910` ...