Hello, thanks for reviewing.
I am looking to have some SQL written that will run on BigQuery with standard SQL to attribute some actions to events that took place before the action following some rules.
I will provide 3 tables of dummy data impressions, clicks & activities with the following schema::
impressions & clicks:
The SQL should take all actions in the activity table and identify the last event in the impression/click table that occurred prior to the time of the action. It also needs to follow the rule of; if a click existed in the previous events leading up to the action, the click should get credit, if no click existed in the path leading up to the action, then the last impression prior to the action gets credit.
The output should look something like:
campaign_id | site_id | attributed_to_click | attributed_to_impression
campaign_1 | site_1 | 2 | 1
campaign_1 | site_2 | 1 | 4
When the SQL is completed full comments should be added to explain the build.
This may lead to more work on an on going basis.
Hey there, I think I've got the script in my head already! :-) Contact me, and let's get it done. Carlos.
4 freelance font une offre moyenne de $29 pour ce travail
Hi There, I can do this task of SQL Complex query. Task related specification required. Thanks...
Hello! My name is Stuart, and I've never worked with BigQuery, but sounds like an interesting - and simple - project to do so! In the other hand, my experience with SQL is of quite some years, that's why I'm conf Plus
Hi I've got 15 years of experience in database development. I'm sure that I will be able to come up with this query very quickly. Regards Kamran