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

  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

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