2 hour job. BigQuery SQL Script (Google Analytics)

종료 등록 시간: 1년 전 착불
종료 착불

I want you to write me a SQL script with the following:

Dimensions:

1) Date

2) Breadcrumb (this is a hit level custom dimension)

3) Device

4) Channel

Metrics:

1) Entrances

2) Bounces

3) Total session Duration (s)

3) Add To Cart Completions (This is a custom goal)

4) Reached Basket page (based on URL)

4) Transactions

5) Revenue

Filters:

1) Only show date for sessions where the landing pages, had Page Type = PDP (Page Type is a custom dimension)

2) Date range = 1st Dec 2022 - 31st Dec 2022

This is a quite basic script - I expect it to take 2hrs maximum.

Do not reply if you are not confident with SQL. Do not reply if you can't do the job in 24 hours.

구글 웹 로그 분석 SQL BigQuery

프로젝트 ID: #35858526

프로젝트 소개

7 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 1년 전

이 일자리에 대한 프리랜서 7 명의 평균 입찰가: £32

prince4dev

Hello, Greetings, As an SEO and SMM and a certified Google, Instagram & Facebook Ad Expert, I am capable of devising marketing strategies and a well-rounded strategy within a planned budget. I always use only white-ha 기타

£24 GBP (15일 이내)
(1 리뷰)
2.4
mobimubasir

Hello. I read your requirement i will do that. I can do it within 24 hours. Please come on chat we will discuss more about this. I will waiting your reply.

£20 GBP (1일 이내)
(3 리뷰)
2.5
oba2311

Money back guarantee. Possibly can deliver late night tomorrow or otherwise the day after. Vast experience with Google BQ. Ping me for Qs.

£30 GBP (3일 이내)
(1 리뷰)
0.5
fmfelipemart

I'm Felipe Martins, I'm 31 years old. I am currently a student of information systems at University of the Americas (FAM) in Sao Paulo, Brazil. I have more than 9 years of experience working in this market. In the last 기타

£20 GBP (7일 이내)
(0 리뷰)
0.0