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 Nov 11, 2022
Richard Ni
from Veneto, Italy

Skills & Expertise Required

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

Open for hiringApply before - Jul 16, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$479.50

Cost

Offer to work on this project closes in 14 days!
Are you interested in this Opportunity?

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

Define trading strategies for Expert Adivors (EA) - Quant/trader (forex) - Hourly
Telecommunications Architect need to design Freeswitch Architecture - Hourly
Setup jumpcloud & zerotier network for laptops (Must be available to work onsite initially - Delhi) - Fixed
Female voice actor for satirical animated show - Hourly
Intuit Quickbooks Book Keeper - Part Time - Long Term - Hourly
Linux admin - Hourly
VIRTUAL ASSISTANCE WITH STRONG AMAZON & EBAY SKILLS REQUIRED - Hourly
Developer for call center, with phone/text/email group & personal inboxes. - Fixed
Create an Mobile app that can open different social media app through webview - Fixed
People entry/exit counting - Fixed
1-2 minutes of simple animation for a music video - Hourly
Developer needed for editing Shopify checkout page - Hourly
Retaining Wall Plan Takeoffs - Ongoing Work - Hourly

Similar Projects

Survey Analysis in Python

I need someone to analyze a small survey in python. Freelancer should be familiar with pandas, numpy, and google sheets. The job involves data wranging and organizing mostly categorical data and creating contingency tables and simple summary graphs....read more

Re-create Data Science projects from Kaggle and Github (code + videos)

Hi,

Thanks for your interest.

We have a list of 45 Data Science projects that we are building for educational purposes. You need to review these projects (code + videos) and recreate them -
1) With better quality
2) Add m...read more

Webscraping HKJC to create data set for project

I need an expert python data scraper to scrape the required data for a machine learning project.

The data is publicly available on the HKJC website

all horse/jockey/trainer and past results.

If you have experience scraping...read more

Java Engineer/Architect - Data Structure/Algorithm

Java Engineer/Architect - Data Structure/Algorithm
Looking for a full stack developer that is a jack of all trades and interested in learning to architect for scale.Need to be generally familiar with AWS and Google cloud APIs.

Skill set...read more

Solr Consultancy

Hello,

We are small team that work as freelancer. We build up a system with python and Solr . The DB hold 1.8 billion data. We create Solr cloud instance for that project Using Solr Cloud with two server and build in Zookeper. I know that i...read more