Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Google Analytics,Extract, Transform and Load,BigQuery,Python,Google Cloud Platform freelancer for Google Analytics data transfer to Bigquery job

Posted at - May 1, 2020

Toogit Instant Connect Enabled


1. Query data (all dimensions and metrics) out of GA through Reporting API and stream it to Google BigQuery.
2. Create table schemas in Bigquery
3. Join all the GA data into one big table in Bigquery
4. Automate this ELT job to run periodically


There are about 500 metrics and dimensions in GA. It is possible to query a maximum of 10 metrics + 7 dimensions at a time from GA. This means that queries need to be run many times and later duplicated data needs to be deleted.

The data can be transferred using python scripts and Google App Engine, Google App Scripts or any way you prefer.

Background info:

We want to get GA hit-level raw data into Bigquery to create a customer journey. We have implemented following custom dimensions:
a) ClientID
b) SessionID
c) Timestamp
d) UserID

About the recuiterMember since May 20, 2018 Adam Maulana
from Lombardia, Italy

Skills & Expertise Required

Google Analytics Extract, Transform and Load BigQuery Python Google Cloud Platform 

Candidate shortlisted and hiredHiring open till - Feb 25, 2021

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Data Mining And Management category.