Remote Data Mining And Management Job In Data Science And Analytics

Google Analytics data transfer to Bigquery

Find more Data Mining And Management remote jobs posted recently Worldwide

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 recuiter
Member since May 20, 2018
Dhibakar Jeyapa
from Alacant, Spain

Skills & Expertise Required

Google Analytics Extract, Transform and Load BigQuery Python Google Cloud Platform 
Candidate shortlisted and hired
Hiring open till - Mar 7, 2023

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$479.39

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

Other jobs by this client

Pharma Project- Web Design - Hourly
Deep FreeSwitch / Kamailio custom development - Hourly
Need help in Migrating EFT server - Fixed
Amazon ip complaint removal - Fixed
PowerBI based DW Development - Hourly
Food Delivery App - Fixed
Social Media Agency Owner Needed - Fixed
Tech Support Help Desk | Basic/Intermediate Troubleshooting | Fill-in Developer - Hourly
Principal software engineer - Hourly
Product Label Packaging (Cutting File) - Fixed
Voice over needed for medical presentations - Hourly
PROGRAMMING AND NETWORKING SPECIALIST - Hourly
Wordpress Site - Fixed
Wordpress Developer - Hourly

Similar Projects

Dendritic Cell Algorithm

I am looking for someone who worked before with this algorithm cuz I have some questions that I cant find the answer my self

Facial Recognition for Pets

We are looking for a person for pets (dogs/cats etc;) Facial recognition project. This can be an ongoing project and we need a person who is:

- experienced of pet facial recognition
- has something to share with us to confirm the capabil...read more

Python Developer needed to create a desktop GUI application

We need a python GUI code and a python controller code communicating with GUI code. UI code will be displaying some changes based on controller code communication and some things based on buttons in UI. About the communication, we have some ideas usi...read more

Create a web application based on existing sourcecode

A web application that is working online.
The app is a document builder that takes input and forms a specific PDF that the customer can download.

Medical Device Website Development / Improvement for SEO

Looking for a professional to help get our e-commerce website tuned up for seo and Adwords.