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 May 20, 2018
Adam Maulana
from Lombardia, Italy

Skills & Expertise Required

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

Candidate shortlisted and hiredHiring open till - Feb 25, 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

Facebook Ads Specialist - Hourly
CAD designer to create a 3D model of a residential building Using Chief Architect - Fixed
Customize and brand Ubuntu - Fixed
R Programmer needed to help create an function to process documents - Hourly
Short laboratory report - Hourly
Looking for a 3D renderer for a 32' x 36' event space - Fixed
Data Entry - Fixed
Network Engineer for handling network problems. Must have CCNA certification. - Hourly
Pop-Art Cover for Teen Workbook - Fixed
Color correct/Whitebalance about 750 wedding photos - Hourly
Proofread a 36 page magazine - Fixed
Agency looking for stand-by translators in all languages. - Hourly
Financial Planning Firm workflow automation - Hourly

Similar Projects

BitMEX Exchange Websocket Connection

Requirements:
- a class which is able to connect to the BitMEX exchange through websocket (if not possible you can use the Rest-API) in order to perform buy, sell and cancel orders
- has to be written in Python

Please make me an off...read more

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)

Connect Google Analytics to my exist Ionic App

Im looking for a developer that helps me to connect Google Analytic to my app made in Ionic Framework. I already did some tries but without success. I followed the official guide of Ionic: ionicframework/docs/native/google-analytics but nothing. May...read more

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