Blog post looks at using Google Sheets as an external [federated] data source and how date format needs to be handled to query data. Solving For 'Error while reading table: Could not convert value to date. Error: Invalid date.
All tagged bigquery
BigQuery ML + Google Analytics: Forecast sales For Multiple SKU's Using A Single Query + Model
Blog post uses Google Analytics merchandise store demo data in BigQuery to forecast the expected quantities that will be sold for two particular SKU’s. Uses BigQuery, BigQuery ML and DataStudio.
BigQuery for Google Analytics App + Web: Get User Counts By Date Between Two Fixed Dates
BigQuery example to extract Google analytics app plus web User counts by date between two fixed dates.
BigQuery Google Analytics App + Web: Query User Count Where Medium Matches Parameter
Blog post looks at using the key/value pairs in event parameters within Google Analytics app plus web event hits to extract user count
BigQuery ML: Time Series Forecasting Using Google Analytics App+Web Data
Blog post looks at examining the forecasting a time series for user values for a sample GA App+Web property using BigQuery and Data Studio
Sample SQL Queries For Google Analytics BigQuery Public Dataset
Some sample queries to get you playing around with Google Analytics merchandise store in BigQuery. Queries use Standard SQL format to answer some GA questions