{"id":1888,"date":"2025-06-24T08:06:09","date_gmt":"2025-06-24T08:06:09","guid":{"rendered":"https:\/\/marcel-jan.eu\/datablog\/?p=1888"},"modified":"2025-06-24T08:33:18","modified_gmt":"2025-06-24T08:33:18","slug":"how-to-use-data-to-find-the-best-spot-for-a-sponsor-event","status":"publish","type":"post","link":"https:\/\/marcel-jan.eu\/datablog\/2025\/06\/24\/how-to-use-data-to-find-the-best-spot-for-a-sponsor-event\/","title":{"rendered":"How to use data to find the best spot for a sponsor event"},"content":{"rendered":"\n

As you might know I’m currently doing sponsor events for Tour for Life<\/a>, to collect funds for the Daniel den Hoed Foundation<\/a>, for cancer research.<\/p>\n\n\n\n

\"\"
Aniel, me and Transfer Solutions CTO Albert Leenders at a sponsor event last Saturday in Ede.<\/figcaption><\/figure>\n\n\n\n

Aniel and me have been doing this for the 3rd year now. And we noticed quite big differences in proceeds per location. You’d think large crowds (like on Dam Square<\/a> in Amsterdam) would guarantee large amounts of donations. Not so. A more humble place like my home town Gouda<\/a> outdid them by a factor of 9 in the same year!<\/p>\n\n\n\n\n\n\n\n

\"\"<\/figure>\n\n\n\n

But let’s be honest: we stayed longer in Gouda. That was because we saw it was so much more effective. But still. Can we get more honest data on our sponsoring events?<\/p>\n\n\n\n

<\/p>\n\n\n\n

What data do I have?<\/h2>\n\n\n\n

At first I thought I had very little data. I get a mail every time someone uses our QR code (or sponsor page) to donate. That mail has a timestamp too. So I can use that also.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then I need to have the time our sponsor event lasted, so I can calculate donations per hour. Luckily I use my cycling computer on my stationary bike during the whole event. And this data gets uploaded to Strava<\/a>. And here I need to use Elapsed time, not the Movement time.
<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

So now I have duration data and you can see that our time on Dam Square was a lot shorter. Still doesn’t explain why Gouda delivered so many more donations. Because we didn’t stay 9 times as long.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

At least I can now calculate the amount of donations per hour and see what location is the most “generous per hour”. But the totals include the donations via social media. That says not a lot about the location itself. So let me exclude that and then you get this result:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Gouda is still doing great. But this year had less donations per hour than previous years. Why is that? I think I can answer that question: it was pouring with rain that day. That means: fewer people passing by. And we decided after 3 hours we were soaked enough to call it quits.<\/p>\n\n\n\n

Two other locations did very well: Bleiswijk<\/a> and Ede<\/a>. But Bleiswijk was a bit of an outlier. I was there with my father and his girlfriend Trijnie. And they knew a lot of people. Also, Trijnie used to be a market vendor. She sold cheese. Altogether they convinced a lot of people to donate. You would think I should repeat that. But both my father and Trijnie are in their 80s and unfortunately currently not in shape for another round.<\/p>\n\n\n\n

My guess would be that the amount per donation were higher in Bleiswijk though. Can we see that?<\/p>\n\n\n\n

Average amount donated<\/h2>\n\n\n\n

We could see that, if I had individual donation data. For cash that’s a bit hard to do. I’m not going to whip out my Excel sheet when people put money in our hat-shaped piggy bank. But for QR code donations: I’ve got those mails, right?<\/p>\n\n\n\n

So this was a bit of manual labour. I went through all the mails and noted the donation amounts. And then you see indeed that Bleiswijk was a bit of an outlier.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

But also, look at Ede! What happened there? Well there was one generous donation of 50 euros (and two of 25 euros) that boosted Ede’s stats quite a bit.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

Data driven sponsor location?<\/h2>\n\n\n\n

All this helps us to find what location worked well previously<\/em>. Based on this data we know where we should return next year. I don’t think having sponsor events in Gouda or Ede every week would work very well.<\/p>\n\n\n\n

Last time I asked ChatGPT to find the best location. I asked to base it on cities where people are more fit and financially strong. That brought us to Leiden and that worked quite well. It didn’t come up with Ede though.<\/p>\n\n\n\n

I’ve also asked ChatGPT on what data it based its decision. It used data from the Dutch office for statistics (CBS) and apparently there’s a site with health statistics: https:\/\/www.vzinfo.nl<\/a>. That might be something to explore next.<\/p>\n\n\n\n

<\/p>\n\n\n\n

If you want to help, you can donate here BTW: https:\/\/supporta.cc\/lfqd\/z0qpn9xqox<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

As you might know I’m currently doing sponsor events for Tour for Life, to collect funds for the Daniel den Hoed Foundation, for cancer research. Aniel and me have been doing this for the 3rd year now. And we noticed quite big differences in proceeds per location. You’d think large […]<\/p>\n","protected":false},"author":1,"featured_media":1909,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[191],"tags":[340,400,399],"class_list":["post-1888","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-engineering","tag-data-bike-ride","tag-sponsor-event","tag-tour-for-life"],"_links":{"self":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/1888","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/comments?post=1888"}],"version-history":[{"count":6,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/1888\/revisions"}],"predecessor-version":[{"id":1917,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/posts\/1888\/revisions\/1917"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/media\/1909"}],"wp:attachment":[{"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/media?parent=1888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/categories?post=1888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/marcel-jan.eu\/datablog\/wp-json\/wp\/v2\/tags?post=1888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}