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 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

$478.98

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

App Integration with Digital Wallet API - Coinbase? - Hourly
Advertising Platform - Fixed
Create an IPv6 only kubernetes cluster - Fixed
Videographer needed to create a 1min video for crowdsourcing - Fixed
PHP MYSQL API Developer needed - Fixed
Logo design - Fixed
Digital file reorganization,set up, design and installation of SharePoint and one drive - Fixed
udp/53 forward - Hourly
Live Stream Social App full UI/UX design complete, just need coding. - Fixed
Looking for experienced and creative architect for small Caribbean vacation home design & rendering - Fixed

Similar Projects

Mixpanel, Kissmetrics, Segment, Google Analytics, Hotjar Behavioral Analytics Tools Research

Mixpanel, Kissmetrics, Segment, Hotjar, Google Analytics Research Project

We are looking for an analytics expert for a one time project to help us evaluate tools and metrics tracking. You will need to be able to analyze our digital product...read more

Google Tag Manager, Analytics Dashboards, SEO

Looking for somebody who understands GTM, Google Analytics, Google Conversion, E-commerce Data Layer, and Data Studio. Also click tracking on CTA buttons with custom JS code etc. so please dont apply if all you can do it work in the Google GUI. We al...read more

Easy Web Scraping (product entries, longterm)

Dear Freelancer,

we need time to time scrape some data (to .csv), from various sources, sometimes behind CloudFlare or other similar anti-scraping tools.

This job is longterm cooperation..

Thank you for offers!

Machine learning

Looking for some one who has experience in machine and deep learning models and can work quickly.

ImageVis3D - Customize Open Source Software Created using C++

- I need to customize the ImageVis3D - Open Source Software
- I need to explain important functionality of ImageVis3D
I will provide a source code through Toogit chat with right person only.