Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
Score Level: 2 - Approaches Expectations
Comment(s): On 2.2, the top 2 campaigns are switched and 2.4, the numbers on the slides were off by 1-2 even though the queries were correct. So, just make sure to double check your work to catch this. You forgot to do 2.5, where you summarize your queries on the user journey.
For Question 3.1, they should focus on the campaigns that drive the highest first touches, then the ones that drive the most purchases. Ultimately, purchases is what the end goal is.
Articles drive a lot of people to the site. They should invest in the article campaigns to increase first touches. They can focus less on google searches. This probably means reducing focus on SEO.
The facebook retargeting ad and email weekly newsletter get people to make purchases. They should invest in those to increase purchases. (The email retargeting campaign and google paid search were less effective in driving purchases.)
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
Score Level: 4 - Exceeds Expectations
Comment(s): All queries accurately retrieve the data intended. Good job including ORDER BY statements to organize the tables and make interpretation easier.
Criteria 3: Query Formatting
Score Level: 4 - Exceeds Expectations
Comment(s): Queries adhere to at the rules of the style guide. Good work using aliases to rename the columns and using indentation to organize your subqueries, both make your queries more readable.
Criteria 4: Understanding underlying concepts and terminology
Score Level: 3 - Meets Expectations
Overall Score: 13/16
Jesus, really good work with the SQL queries, it's clear you have a strong understanding of SQL basics. Some things to look out for are confirming the data in your report to the queries, and using that information to better address that last question of how to best reinvest. Other than that, great work!
Criteria 1: Report: Are conclusions clear and supported by evidence in all eight answers?
For Question 3.1, they should focus on the campaigns that drive the highest first touches, then the ones that drive the most purchases. Ultimately, purchases is what the end goal is.
Articles drive a lot of people to the site. They should invest in the article campaigns to increase first touches. They can focus less on google searches. This probably means reducing focus on SEO.
The facebook retargeting ad and email weekly newsletter get people to make purchases. They should invest in those to increase purchases. (The email retargeting campaign and google paid search were less effective in driving purchases.)
Criteria 2: Query Accuracy: Do queries do what they were supposed to do?
ORDER BY
statements to organize the tables and make interpretation easier.Criteria 3: Query Formatting
Criteria 4: Understanding underlying concepts and terminology
Score Level: 3 - Meets Expectations
Overall Score: 13/16
Jesus, really good work with the SQL queries, it's clear you have a strong understanding of SQL basics. Some things to look out for are confirming the data in your report to the queries, and using that information to better address that last question of how to best reinvest. Other than that, great work!