google_analytics_bq: Get Google Analytics 360 BigQuery data

In MarkEdmondson1234/googleAnalyticsR_public: Google Analytics API into R

Get Google Analytics 360 BigQuery data

Description

Turn a google_analytics style call into BigQuery SQL. Used with Google Analytics 360 BigQuery exports.

Usage

google_analytics_bq(
  projectId,
  datasetId,
  start = NULL,
  end = NULL,
  metrics = NULL,
  dimensions = NULL,
  sort = NULL,
  filters = NULL,
  max_results = 100,
  query = NULL,
  return_query_only = FALSE,
  bucket = NULL,
  download_file = NULL
)

Arguments

projectId	The Google project Id where the BigQuery exports sit
datasetId	DatasetId of GA export. This should match the GA View ID
start	start date
end	end date
metrics	metrics to query
dimensions	dimensions to query
sort	metric to sort by
filters	filter results
max_results	How many results to fetch
query	If query is non-NULL then it will use that and ignore above
return_query_only	Only return the constructed query, don't call BigQuery
bucket	if over 100000 results, specify a Google Cloud bucket to send data to
download_file	Where to save asynch files. If NULL saves to current working directory.

Details

All data will be unsampled, and requests will cost money against your BigQuery quota.

Requires installation of bigQueryR and authentication under ga_bq_auth() or googleAuthR::gar_auth() with BigQuery scope set. View your projectIds upon authentication via bigQueryR::bqr_list_projects()

No segments for now.

Goals are not specified in BQ exports, so you need to look at how you define them and replicate per view e.g. unique pageviews or unique events.

Custom dimensions can be specified as session or hit level, so ignoring the setting in GA interface.

You can get a sample Google Analytics dataset in bigquery by following the instructions here: https://support.google.com/analytics/answer/3416091?hl=en

Value

data.frame of results

See Also

https://support.google.com/analytics/answer/4419694?hl=en https://support.google.com/analytics/answer/3437719?hl=en

MarkEdmondson1234/googleAnalyticsR_public documentation built on Dec. 10, 2023, 2:43 a.m.