2 hour job. BigQuery SQL Script (Google Analytics)

Job Description:

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


1) Date

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

3) Device

4) Channel


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


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.

Compétences : Google Analytics, SQL, BigQuery

Concernant le client :
( 4 commentaires ) Slough, United Kingdom

Nº du projet : #35858526

7 freelances font une offre moyenne de 32 £ pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 15 jours
(1 Évaluation)

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(3 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(1 Évaluation)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)