Transactions by browser in July 2017
Analytics sample in BQ
SELECTdevice.browser,SUM ( totals.transactions ) AS total_transactionsFROM `bigquery-public-data.google_analytics_sample.ga_sessions_*`WHERE_TABLE_SUFFIX BETWEEN '20170701' AND '20170731'GROUP BY device.browserHAVING SUM ( totals.transactions ) > 0 ORDER BYtotal_transactions DESC