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 Nov 11, 2022
Randhir Swamy
from Rajasthan, India

Skills & Expertise Required

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

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$479.44

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

Data Scientist, Behavior Economist, Psychometrician, Industrial Scientist for Purpose Data Product - Hourly
3D Model of Fish Tank using Google SketchUp 3D - Fixed
Looking for Expert Zendesk - Hourly
Customer Service / Technical assistant - Hourly
Looking for long term partners to convert point cloud to AutoCAD plans or Revit model - Fixed
Angular Expert Needed - Must start right now. - Hourly
Chatbot to integrate to my CRM application - Fixed
Facebook Marketing including Bots, growing Social Media audience, Blog writing - Hourly
Content arrangement - English GYM Project - Hourly
Tensorflow / NLP/AI Project .Knowledge in Javascript - Hourly
GPS software - Hourly
Need a Patio Design for my restaurant - Fixed

Similar Projects

Python + AWS + CloudFormation

We are looking for proffessionals that will work on moving businesses into cloud.
Req:
Python
AWS ( EC2 Lambda Cloudformation DynamoDB)
May be a plus:
ECS

Front-End Development

I am currently a few months away from launching my brand worldwide. In order to achieve this I am developing my website. My products are prosthetic leg covers. That will give a style to the conventional prosthesis.

Currently, in order to ach...read more

Python data engineering for COVID-19 Modeling

We represent a team working with various government organizations to create custom COVID-19 models and reports. These require a fair bit of data collection, cleaning, and processing with various analysis toolkits. One of the main programs used is GLE...read more

Data Mining

I am looking for a software developer to create a robot that will scrape online and county records for recent bankruptcies and evictions within the last 30 days.

Google Ads - Geofencing for a conference

My client is a software that wants to book more demos.

This month, however, we want to do geofencing around an event in NYC at the end of Month.

Looking for someone has experience with Google ads + Geofencing + Events.

If n...read more