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 BigQuery.
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
Support Archiz
from Odisha, India

Skills & Expertise Required

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

Candidate shortlisted and hiredHiring open till - Oct 7, 2021

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$347.60

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

Expert AWS Developer for server management - Hourly
Need an expert to Set up for function of Gmelius - Fixed
Wix Developer needed to add more capability to Wix payment plans - Hourly
Invoice Management Portal - Fixed
Need an editor for the personal statement, resume and an essay with background of architecture - Fixed
Creating a professional one product Shopify store - Fixed
Virtual staging - Hourly
Fix Wordpress Fatal error - Hourly
helm3 or kustomize templates for kubernetes yaml files - Fixed
Configure AWS AD Connector over OpenVPN - Hourly
CPA required for a Real Estate Corp - Hourly
Odoo Developer (part-time) needed to assist with basic sales funnel implementation - Hourly

Similar Projects

Automated Text Analyse

Looking for someone with expert knowledge of Python and Regex.

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.