program$\_$name$\_$ic utm$\_$campaign leads app paid$\_$app

Program $1$ UTM $1900$

Program $2$ UTM $26642$

Program $3$ UTM $3400$

Program $4$ UTM $4500$

Program $5$ UTM $51220$

Program $6$ UTM $63530$

Program $7$ UTM $7900$

Program $8$ UTM $8900$

Program $9$ UTM $98161$

Program $10$ UTM $103210$

Program $11$ UTM $115510$

Program $12$ UTM $121110$

Program $13$ UTM $132600$

Program $14$ UTM $14600$

Program $15$ UTM $151900$

Program $16$ UTM $16700$

Program $17$ UTM $17100$

Program $18$ UTM $181000$

Program $19$ UTM $19100$

Program $20$ UTM $205930$

Program $1$ UTM $21600$

Program $2$ UTM $221700$

Program $3$ UTM $23300$

Program $4$ UTM $241100$

Program $5$ UTM $251221$

Program $6$ UTM $263921$

Program $7$ UTM $273610$

Program $8$ UTM $281441$

Program $9$ UTM $293622$

Program $10$ UTM $304031$

Program $11$ UTM $311220$

Program $12$ UTM $321000$

Program $13$ UTM $33300$

Program $14$ UTM $342000$

Program $15$ UTM $351010$

Program $16$ UTM $3611751$

Program $17$ UTM $374794$

Program $18$ UTM $382910$

Program $19$ UTM $39800$

Program $20$ UTM $402200$

Program $1$ UTM $412031$

Program $2$ UTM $427042$

Program $3$ UTM $43100$

Program $4$ UTM $441810$

Program $5$ UTM $452100$

Program $6$ UTM $462620$

Program $7$ UTM $47700$

Program $8$ UTM $48200$

Program $9$ UTM $491200$

Program $10$ UTM $503941$

Program $11$ UTM $511000$

Program $12$ UTM $52600$

Program $13$ UTM $53700$

Program $14$ UTM $54500$

Program $15$ UTM $552810$

Program $16$ UTM $563430$

Program $17$ UTM $57200$

Program $18$ UTM $582300$

Program $19$ UTM $59300$

Program $20$ UTM $603942$

Program $1$ UTM $61200$

Program $2$ UTM $621700$

Program $3$ UTM $63600$

Program $4$ UTM $641821$

Program $5$ UTM $652711$

Program $6$ UTM $665300$

Program $7$ UTM $67211$

Program $8$ UTM $689162$

Program $9$ UTM $691020$

Program $10$ UTM $701311$

Program $11$ UTM $71621$

Program $12$ UTM $721800$

Program $13$ UTM $734833$

Program $14$ UTM $74500$

Program $15$ UTM $75610$

Program $16$ UTM $76700$

Program $17$ UTM $77500$

Program $18$ UTM $781610$

Program $19$ UTM $79400$

Program $20$ UTM $80310$

Program $1$ UTM $81100$

Program $2$ UTM $821000$

Program $3$ UTM $83137104$

Program $4$ UTM $843411$

Program $5$ UTM $851420$

Program $6$ UTM $861400$

Program $7$ UTM $872300$

Program $8$ UTM $882500$

Program $9$ UTM $897711$

Program $10$ UTM $902211$

Program $11$ UTM $911610$

Program $12$ UTM $92100$

Program $13$ UTM $931022$

Program $14$ UTM $948954$

Program $15$ UTM $95500$

Program $16$ UTM $96200$

Program $17$ UTM $972231$

Program $18$ UTM $983010$

Program $19$ UTM $991900$

Program $20$ UTM $100500$

A$)$ Write an SQL query which would help you arrive at the final data shared in the excel using the two source tables mentioned below:

Source Table $1$: Prospect ID wise course Lead, App, Paid App status table

Source Table $2$: Campaign Table with UTM level prospect IDs mapping file

B$)$ Identify the top selling courses $[$Hint: Each UTM is mapped to $1$ distinct program$]$

For solving the above question, we are looking for the following approach:

Identify metrics to judge the performance of the courses in terms of revenue generation

Create multiple summaries of the data to represent the performance spectrum across the above defined metrics $[$Bonus points for visualizations$]$

C$)$ Basis the above insights what are your top $3$ performance improvement ideas along with some business impact calculations