brev95 / sql-scratch-capstone-turn-in Goto Github PK

Thanks for your submission.

1. State A Clear Objective: On your first "Get Familiar With CoolTShirts" slide, I recommend giving a brief introduction to who CoolTShirts is and what their objective is. This will help your readers better contextualize the information that you're presenting and stay on the same page as you throughout.

2. Though you explain what the campaigns and sources are, it's important that you also describe their relationship for your reader. Similarly, the significance of the landing pages is not communicated.

3. Narrative And Support Not Methods: My primary critique of your presentation is that it speaks too much about what you did to get a result rather than why it's important or why the reader should care. This is not all bad but it is not enough. Your slides should communicate a narrative and provide support. Slide 2.4 and 3.1 are better examples of this.

4. Query Overkill: Since you provide a .sql file along with your presentation, I can read over this file to verify that your queries correctly retrieve the tables you present. You don't need to present a query for every table and explain how you set up each query. This is mostly noise. I would recommend presenting a query only if it is absolutely necessary.

Rubric Score

Criteria 1: Report

• Score Level: 3
• Comment(s): Your presentation has many good pieces but can be improved in the categories of narrative and an introductory slide with the presentation's stated objective.

Criteria 2: Query Accuracy

• Score Level: 4
• Comment(s): All queries accurately retrieve the data intended.

Criteria 3: Query Formatting

• Score Level: 4
• Comment(s): Queries are formatted well and according to the style presented in the Codecademy lessons.

Criteria 4: Understanding underlying concepts and terminology

• Score Level: 3
• Comment(s): Your report communicates a partial understanding of connections between UTM parameters, marketing touch-points, and touch attribution. I make recommendations about improvements in my comments.

Overall Score: 14/16

Thanks for your submission. What feedback I have can be found here