Compare show-up rate by registration date

Using my Livestorm data, look at my public webinar sessions from the [LAST 6 MONTHS] with at least 20 registered participants (not team members), up to the [10] most recent. If fewer qualify, use those and say how many. Skip internal meetings (all-hands, team syncs, trainings), one-to-one or sales calls, and test events, and sum up what you skipped by type in a line or two. For every registered participant, work out how many calendar days before the session (in my time zone) they registered, using the date they registered rather than when their contact was created, and whether they attended. Group them into: registered on the day, 1 to 7 days before, 8 to 30 days before, and more than 30 days before. Give me a table with, for each group, the number of registrants, how many attended and the show-up rate, overall and per webinar. Then tell me what this means for when to promote and when to send reminders.