As a Data Analyst on Snowflake's Marketing Analytics team, you're analyzing the CRM to determine what percent of marketing touches were of type "webinar" in April 2022. Round your percentage to the nearest integer.
Did you know? Marketing touches, also known as touch points are the brand's (Snowflake's) point of contact with the customers, from start to finish.
In April 2022, there is 1 webinar out of a total of 8 marketing events. Thus, the ratio is 1/8 = 12.5% ~ 13%.
For an easier understanding of solving the question, let's take this problem apart.
To filter for the month of April 2022, we have 2 methods:
Feel free to use either option. If you need more reading about the function, click here.
Next, we want to obtain the number of webinar events. To do this, we can utilize the statement. Thus, if the is 'webinar', we assign the value 1, otherwise 0. Keep in mind that this allocates the value 1 to rows only, so to get the total number, we can simply use .
To obtain the number of total events, we can just count all of the rows in the dataset.
We are almost done - one simple step left. To obtain the percentage, first, divide the webinar events by the total amount of events, and multiply by 100.
Lastly, round the result to 0 decimals (the default value for the function is 0, so you don't need to pass that argument at all).