Write BIGQUERY SQL To Extract Data From Google Analytics
$250-750 USD
Închis
Data postării: circa 3 ani în urmă
$250-750 USD
Plata la predare
Working on an attribution project.
Wish to extract certain page views from internal website attributed to outside traffic sources,
Compile a history of pages visited for a given google client ID.
write bigquery to extract from GA schema given here
[login to view URL]
Must have experience with Google analytics and BIGQUERY.
I'm having more than 3 years of experience with Google Analytics and other Google Products. I primarily work on data analytics services to the clients with the focus being on Google Analytics and its Enterprise Solution (GA360) by querying data in BigQuery. Being into Data Analytics from the past 3 years, I also developed some predictive models that help in bringing out the right insights from the data that comes in.
Achievements:
Increased the traffic by 2% with the change in website UI
Increased conversion rate by 1.5% via A/B Test
Boosted 6% in conversion rate & 55% in CTR for mobile site optimization
Dear Employer.
With 5 years experience working only as report developer, I can help you write fast and optimize Google Big query.
Please feel free send a message to me for reciving some advice.
Have a great day. Thank you.
I am a Professional Data Entry Person & have More Than 4 Years Experience.
My skills:
1: Microsoft word
2: Microsoft excel
3: Power Point
4: Pdf to word file
5: Image to word (100% guranted accuracy)
Here is just a small overview of My Services how I can help free up your time. Don't see what you need? Let's talk!
You will receive:
☑ High-Quality Deliverable
☑ An On-time Delivery in a Proper Format
☑ 100% Confidentiality
☑ Revisions Provided
Hi there.
I have done many similar projects which get data from API or by scraping and analysis it so save to db and draw chart. And I have enough experience with Google analytics. I have integrated yahoo, twelvedata, eodhistoric, gocardless and etc.
As a database expert I can do this perfectly.
Please contact me and let's discuss in detail.
Best regards.
Shugaev.
I understood your requirement & Interesting one though. Things that we should be strong enough and to be taken care off are the schema contains parent and child elements otherwise can be compared to json key value pair elements. I have worked upon such data and tables and hence I can confidently assure you that this is doable. Then the other part is intraday loads which will update the table thrice a day I beleive. Even this we can implement and also we could maintain a audit table to show all the statistics as in how many records inserted, updated or deleted on daily basis. I am happy to discuss more on the requirements, let me know if you are really interested to work with. Thank you.