SSW Coding Challenge Updates Sep... I mean Oct 2025
By SSW Coding Challenge
Summary
## Key takeaways - **New charts visualize challenge data**: The coding challenge app now features charts to summarize monthly challenges, participation per person, and overall totals, offering better data visibility. [00:12] - **Dashboard charts offer date range filtering**: The dashboard now includes charts with a customizable date range, defaulting to the current month, to display challenge summaries and participation. [01:54], [02:07] - **Candidate funnel tracks progress through stages**: A new candidate funnel chart visualizes how many people progress from V1 to V2 of the comms challenge and subsequently to the tech challenge. [03:14] - **Refined deletion process prevents data loss**: The cancellation process for comms challenges has been updated to prevent data loss and address issues where records were previously stuck or incorrectly deleted. [05:21], [06:16] - **Edge case: Stuck records now visible**: A previously 'stuck' record, which couldn't be cancelled due to provisioning logic, is now handled correctly, showing its V1 and V2 data even after deletion. [05:40], [08:00]
Topics Covered
- Dashboard Charts Track Full Candidate Funnel
- How Date Ranges Impact Funnel Metrics
- Retaining Data Integrity When Cancelling Challenges
Full Transcript
How's everyone? This is Gordon from SSW
and today I just want to take you
through some of the changes we've made
to the coding challenge app. So, with
the app having run now for a couple of
years, um I thought it'd be quite cool
to introduce some charts.
Um so, the first thing I'll show you is
on the tech challenges. So, you'll now
notice there's this little uh charts
button.
If we click that, you'll see it shows
you uh some summaries. So this shows you
for the last 12 months how many
challenges we've had every month and
then also um every month well of those
challenges how many challenges have been
done by which people and then you can
see at the bottom here that it's just
showing you this is currently the date
range that these are showing and then
you can click and open this up and this
will show you who's been doing how many
challenges um across that time span. The
summary at the top is for total amount.
So this summary isn't um just for um
this sort of bottom uh range here.
That's for all of them.
Now obviously if we adding um charts to
the tech tech challenge, it makes sense
that we'll just add them for the coms
challenge as well. So if we head over to
the coms challenge, you can see that
these charts are also here. um and they
also show in the same way. So you can
see it does the the little split u and
the chart show. So those are those two
work um pretty much identical to each
other.
Then the next bit of changes here. So
when I showed these changes to cookie,
he had some ideas of other stuff that
sort of that they
um look for um or data that they're
trying to pull out of the system. And so
I went and added more charts for this.
So as you'll see, sorry I haven't
mentioned here, but charts is now on the
on the dashboard as well. And part of
the reason for that is they wanted some
filtering as well, which I thought would
make sense if this data was all together
to show it. So if we're on the
dashboard, you can see we've got a date
range here. So currently this when this
loads, it will show from uh one year
back and to the 1st. So, because we're
on the 13th of October, this goes back
and shows you from the 1st of October.
And then it shows you for the current
month to the end of that month. So,
again, because we're on the 13th of
October, it defaults to the end of this
month.
And then this shows you that just a
quick summary inside this range. So
there's 85 challenges um across that
span um more coms challenges 27 tech
challenges and then um there's been 10
challenges which from this funnel on the
side haven't actually made it uh gone
through the full uh funnel. Now, that
could happen when we have to change the
email address of someone. Um, or if
there's a test. Um, so like Vlad or
myself does a test to check some stuff.
Uh, we might create a test challenge
that hasn't actually gone through this
full funnel. Which brings me to
obviously that next part of the the
chart and a chart that you didn't see on
the previous pages and that is the
candidate funnel. So, we look at the
email address of the coms challenge and
we see how many people get the V1 that
then make it through to the V2 and then
of those people that then obviously drop
down to the tech challenge.
I'll show you something about that soon.
But then at the bottom here, these are
basically just these same charts that
you saw on the other page um just
filtered down to these date ranges.
So if I go ahead and make this be just
October of last year,
we can see that it says that there was
15 total challenges or coms challenges.
Um on the V1 input of the funnel, there
was 14 and the V2 there was 13. Now,
those three numbers feel like they don't
make much sense, but the way that we
actually calculate this is we look at
the date for the appointment
um and we check if that's inside this
range. So, in this case, it's saying
that we have 14 candidates where their
um appointment date was in this range
and then we have 13 where the V2 was in
that range. And in this case, the actual
data for that, if we go and look at it
and we look at past and then we find
October,
you'll notice if you had to go through
here and count these records that we
have 14 records up until this point, um,
which matches with the, uh, 14 that you
saw. But then if we scroll a little bit
lower down, we have this um this record
that had a V1 that was in September and
the V2 was in October. And that's how
when we look at this um data again,
we get apply we get 13 people that had a
V2 um and only 14 with a V1. And
obviously because that one extra person
is outside of the range that makes the
total amount of coms challenges in that
period 15.
Now outside of just um charts there was
one other small change. So around the
way we sort of cancel and delete com ch
coms's challenges.
So there was a record and if we had to
go look in production you would um see
it but there is a record that was sort
of stuck here because the coms challenge
had been set up but it couldn't get
cancelled
and the reason it couldn't get uh
cancelled is because we had some logic
that said that you can only cancel
something after it's been provisioned
which means that you can only cancel it
after you've created an appointment and
then save that which means the meeting
requests have been sent out to the
candidates.
Now that case itself was a little bit of
an edge case with the way that candidate
was sort of came into the system and
then didn't want to be in the system. Um
but yes, nonetheless there was a record
that was stuck here. So what we've gone
and done is changed how you can delete
um com challenges and we've changed this
for two reasons. one, we've changed it
because of that issue where someone got
stuck on the on the sort of homepage and
you couldn't get rid of them without
actually fully setting them up and then
deleting them. And the second one is um
say for example this person
um had their followup so they they have
their V2 scheduled and then they don't
show up for their V2. Now what would
currently happen or maybe they say
actually I'm fine thanks I don't want to
do the V2. our recruitment team would
hit delete and when they hit delete they
would actually clear out all of these um
times uh time slots and would go cancel
all the meetings and we wouldn't know
that this challenge actually happened
from our data perspective. So now what
happens is if you click delete it says
um do you want to cancel the V1
appointment which is for this date? Do
you want to cancel the the follow-up
which is on this date? Um, and you can
go ahead and say yes, you want to cancel
this one or actually I want to cancel um
basically everything. Um, and then that
just says, hey, when you cancel this,
you'll actually be canceling the V2 as
well. So now if I go and delete this,
that candidate is fully cancelled and
they'll show up in this list.
Now one other thing that you'll notice
here is that from that previous delete,
as I was saying, it would cancel
everything. So in this list currently
everyone has uh no data.
This person if I just move myself to the
side um happens to be the person that
was stuck previously. Um so now um
you'll see that they actually do have
data even though they're showing in the
deleted um appointments which means from
a charting perspective we can pick up
that they had a V1 and a V2 scheduled.
um they just happen to get deleted and
those um the data saying that they
actually did that V1 and V2 um didn't go
with it.
So that's all the changes that I had um
or that I'm publishing at the moment. Um
if you have any questions or feedback uh
let me know. The idea is to let the
recruitment team use these these changes
for a little bit and then potentially
get someone to do any tweaks that they
need. Um, I just had some time um, a
couple weeks back and I decided to start
vibe coding some stuff and this is how
this stuff came up. So yeah, if you have
any questions, let me know. Otherwise,
this has been Gordon from SSW. Cheers.
Loading video analysis...