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 - Nov 18, 2022

Toogit Instant Connect Enabled


Objectives:
  1. Query data (all dimensions and metrics) out of GA through Reporting API and stream it to Google Big Query.
  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.
    Details: 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 Mar 14, 2020 Tirlok Singh
from Yucatan, Mexico

Skills & Expertise Required

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

Candidate shortlisted and hiredHiring open till - Dec 9, 2022

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$483.50
Cost

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.


Related Jobs


Latest In Google Analytics Jobs


Latest In Extract, Transform and Load Jobs


Latest In BigQuery Jobs


Latest In Python Jobs


Latest In Google Cloud Platform Jobs