logo

Back to questions

Webinar Popularity

Easy

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.

Table:

Column NameType
event_idinteger
contact_idinteger
event_typestring
event_datedate

Example Input:

event_idcontact_idevent_typeevent_date
11webinar4/17/2022
21trial_request4/23/2022
31whitepaper_download4/30/2022
42handson_lab4/19/2022
52trial_request4/23/2022
62conference_registration4/24/2022
73whitepaper_download4/30/2022
84trial_request4/30/2022
94webinar5/14/2022

Example Output:

webinar_pct
13

Explanation:

In April 2022, there is 1 webinar out of a total of 8 marketing events. Thus, the ratio is 1/8 = 12.5% ~ 13%.

PostgreSQL 14

Refer friends to get bonus content & cool prizes.