Rubric Score

Criteria 1: Report

• Score Level: 4 (Exceeds Expectations)
• Comment(s): Every answer has three components: 1) SQL queries, 2) output tables as evidence, 3) text interpreting the query results. Your supporting text was very thorough, though I wished it did a little more personal reinterpretation rather than restating the table contents.

Criteria 2: Query Accuracy

• Score Level: 4 (Exceeds Expectations)
• Comment(s): Most queries are accurate. However, we were seeking you to use to COUNT() function in the first question asking how many campaigns/sources there are: note.

Criteria 3: Query Formatting

• Score Level: 3 (Meets Expectations)
• Comment(s): Queries adhere to at least 7 rules of the style guide. However, we recommend renaming columns for readability like ft_attr.utm_source could be renamed "Sources".

Criteria 4: Understanding underlying concepts and terminology

• Score Level: 4 (Exceeds Expectations)
• Comment(s): Report demonstrates a solid understanding of funnels. You correctly understand the distinction between different touch methods and how they may drive not only visits, but also purchases. You provided good recommendations based on the purchase rates.

Overall Score: 15/16

Overall, very good job! Your presentation is very well made and demonstrates a clear understanding of how the SQL tables relate to real-world business problems. One area of improvement is to include renamed columns and table aliases to improve readability. But otherwise, you did a great job grasping the importance of both campaign types and conversion rates. Well done!

Good work pulling out the distinct sources and campaigns. However, we wanted you to count how many campaigns and sources there were. You can do so with the COUNT() command:

SELECT COUNT(DISTINCT utm_source)
FROM page_visits;
SELECT COUNT(DISTINCT utm_campaign)
FROM page_visits;

It's a good idea to rename columns to make the table more readable, especially when you are pulling data from multiple sources or using aggregate commands (like COUNT()). The syntax for renaming a column is:
SELECT original_column_name AS 'new_column_name'

Here you could it apply it with:

SELECT ft_attr.utm_source AS 'Source',
       ft_attr.utm_campaign AS 'Campign',
       COUNT(*) AS 'Number of First Touch'
FROM ft_attr