Code School of Analytics
BasicData Analysis10 points

Which month did a channel convert?

The growth team of a SaaS company reviews each acquisition channel monthly. The file traffic.csv has one row per channel per day, from 2025-03-05 for 60 days.

  • date: YYYY-MM-DD
  • source: traffic source (Organic Search, Paid Ads, Email, Social)
  • sessions: website visits that day
  • signups: accounts created that day

Task: read a source name (exactly as in the file) on the first line and a month as YYYY-MM on the second line. Print three lines: Sessions: S, Signups: U and Conversion: P% where P is signups divided by sessions times 100 with 2 decimals. If the channel has no sessions in that month (for example the month is outside the file), print Conversion: 0.00%.

Files your program can read

traffic.csv241 lines
date,source,sessions,signups
2025-03-05,Organic Search,704,37
2025-03-05,Paid Ads,390,23
2025-03-05,Email,237,10
2025-03-05,Social,472,24
2025-03-06,Organic Search,921,54
2025-03-06,Paid Ads,539,31
2025-03-06,Email,336,18
...

Open them by name, for example open("traffic.csv").

Sample test

Input

Email
2025-03

Expected output

Sessions: 7822
Signups: 330
Conversion: 4.22%

Your answer is also checked against 4 hidden tests.