Find Jobs
Hire Freelancers

Standard SQL query in Google BigQuery on an advanced eCommerce data set

$30-250 AUD

Zavřený
Zveřejněno přibližně před 5 roky

$30-250 AUD

Zaplaceno při doručení
I need a query to extract the previous 10 values of a custom session level dimension before a purchase event and the value at time of purchase. This is from a Google 360 dataset running advanced eCommerce. Purpose is to track the accuracy of custom Audience modelling. From the results I need to: Validate product purchased matches Audience value Calculate / report on number of visits and time elapsed before a purchase is made Report on how the Audience values change over time before purchase Multiple products need to stringified or piped into a single field. Output will be extracted to Tableau so all results need to be unnested. Query needs to be in Standard Sql Please note that I cannot give access to the bigQuery instance. I expect that I will need these values: visitId, fullVisitorId, ClientId, UserId, session_id, [login to view URL], visitNumber, date, (yyyymmdd) visitStartTime, ("%Y-%m-%d %H:%M:%S", 'Australia/Sydney' ) transactionId, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], (Note a single transactionId may have several different products) [login to view URL], where index=144 AS dimension144, visitNumber where transactionId is NOT NULL as t_visitNumber dimension144 where transactionId as t_dimension144 dimension144 where visitNumber is = t_visitNumber - 1 as minus1 dimension144 where visitNumber is = t_visitNumber - 2 as minus2 dimension144 where visitNumber is = t_visitNumber - 3 as minus3 etc to 10 first occurrence (or minus10) dimension144 value as first_ dimension144 time between visits in days and hours for visits t to minus10 calculated against transaction time time between first_ dimension144 to t_dimension144 TIMEFRAME: 1-2 HOURS
IČ projektu: 18374233

O projektu

10 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
10 freelanceři nabízejí v průměru $179 AUD za tuto práci
Avatar uživatele
Greetings, I'm professional database expert with 10+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs like database administration and development by remotely. I'm top expert. -- Best regards, Davit Dartsimelia Senior Database Administrator & Developer
$277 AUD v 2 dnech
5,0 (2 recenze)
4,2
4,2
Avatar uživatele
I will create query and get required fields. thank you for posting job. I look forward to hear you. anuj
$200 AUD v 7 dnech
5,0 (1 recenze)
1,6
1,6
Avatar uživatele
I'm having more than 2 years 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). Being into Data Analytics from the past 2 years, I also developed some predictive models that help in bringing out the right insights from the data that comes in.
$222 AUD v 3 dnech
5,0 (1 recenze)
0,5
0,5
Avatar uživatele
I am interested this work and I had good experience of this work. I do my best of this work at as soon as possible.
$166 AUD v 1 dni
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi, I have 7 years of experience and working on hadoop, spark, nosql, java, BI tools(tableau, powerbi), cloud(Amazon, Google, Microsoft Azure)... Done end to end data warehouse management projects on aws cloud with hadoop, hive, spark and presodb. Worked on multiple etl project like Kafka, nifi, flume, mapreduce, spark with XML/JSON., Cassandra, mongodb, hbase, redis, oracle, sap hana, ASE.... Many more. Let's discuss the required things in detail. I am committed to work done and strong in issue resolving as well. Thanks
$166 AUD v 2 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Currently working in bigquery and tableau, it could certainly meet your needs on the agreed day. I have a trajectory of 8 years working in Business Intelligence with different types of sql languages and management tools.
$200 AUD v 3 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z AUSTRALIA
Carlingford, Australia
0,0
0
Ověřená platební metoda
Členem od pro 11, 2018

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.