ETL – Google Analytics and Ads data into data warehouse – Upwork
Need Google Ads and Google Analytics data extracted into Azure SQL database using Azure Data Factory.
1) Step by step set up of service account in GCP to access Google Analytics Reporting API and Google Ads API
2) proper data model for reporting on google analytics and Google Ads campaign data from SQL server,
3) Linked Service in Azure Data Factory
4) Data flows and pipelines in Azure Data Factory
5) properly modeled google analytics and google ads data in SQL server
You will setup these up in your own environment and provide the following for us to configure and run in our environment.
Deliverables are documentation, SQL script to create the reporting data model in SQL database, all Azure data Factory code for data flows and pipelines, and documentation for setting up linked services and other configuration.
Budget: $200
Posted On: October 08, 2023 04:17 UTC
Category: Data Extraction
Skills:API Integration, Google Analytics, ETL Pipeline, Data Modeling
Skills: API Integration, Google Analytics, ETL Pipeline, Data Modeling
Country: United States
click to apply
2023-10-08 10:17:35,
All jobs | upwork.com ,
https://www.upwork.com/jobs/ETL-Google-Analytics-and-Ads-data-into-data-warehouse_~01664c960df2616add?source=rss,
,
#ETL #Google #Analytics #Ads #data #data #warehouse #Upwork