Download statistics after a webcast

34 postsstarted by rl_albright 27,999 viewsoriginal topic

#1
Is there a way to download the statistics of the webcast event after the meeting is done?
We just held a VERY successful stake conference, in which we pre-recorded all talks/prayers (except for the stake presidency), and it turned out quite well. I was wanting to get the Individual Site statistics in an excel format or something like it, so that I can drill down on the information that it gives.

Thank you
Community Moderators
#2
Sadly, no. If it helps any, this has been requested quite a bit, so hopefully it will make it into some future update.
So we can better help you, please edit your Profile to include your general location.
Community Moderators
#3
Moderator note: The API that was posted here was removed by the request of the product manager of the Broadcast Infrastructure & Meetinghouse Network team. The church currently does not have any API's setup for general use. I apologize for any inconvenience.
So we can better help you, please edit your Profile to include your general location.
New Member
#4
Mikerowaved wrote:Moderator note: The API that was posted here was removed by the request of the product manager of the Broadcast Infrastructure & Meetinghouse Network team. The church currently does not have any API's setup for general use. I apologize for any inconvenience.
Apologies, I didn't realize that was a hot topic. It is data available in it's entirety to anyone who has access to that dashboard, protected by the login system and doesn't allow access to events not owned by the authenticated users' stake (I wouldn't have shared it without checking that it was protected), so I didn't think it would be an issue. As this data is already available and in a format easily converted to a CSV file, it would be very easy to add a button to download the statistics for simple filtering for attendance reporting.

This is needed as the current analytics page is useless for Ward Sacrament meeting or Stake Conference reporting. It was designed for building-to-building broadcasts, not for building-to dozens of people.
New Member
#5
Hello, YES, WE REALLY NEED IT !! because stake presidency or bishopric are required from the church to give the meetings attendance ! So it is sadly yet not possible to meet the church attendance requirement.
New Member
#6
I've created a created something that I use to download the data. Since there wasn't an API, I utilize another method to download the data and it provides me an output which currently I copy and paste to excel, but I'm going to add a button to make it a csv. When I get it posted, I'll provide a link for people to test it out. You will need 2 things, your stake number and the event ID which you can find in the address bar of your event page.
New Member
#7
Great @jnpetersen I'm exited waiting for it ;)
Community Moderators
#8
The church's newly added reporting system may satisfy most of the current needs for webcast attendance reporting. Not that your efforts aren't appreciated.

https://webcast.churchofjesuschrist.org/#/event/attendance-report
(Available to stake STS and ATS callings.)
So we can better help you, please edit your Profile to include your general location.
Community Administrator
#9
Mikerowaved wrote:The church's newly added reporting system may satisfy most of the current needs for webcast attendance reporting.
Questionable. The link on the left is the same as what we've always had. The link on the right is just a simple list of names. There is no download link. And I wouldn't consider it the layout the friendliest format.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
Community Moderators
#10
Probably moot anyway now that we've been asked to move to other platforms.
So we can better help you, please edit your Profile to include your general location.
New Member
#11
I understand the need for Zoom accounts, but I really think the webcasting platform is the best platform for most cases as it is the most non-interactive platform we can use. Especially from a Building, since you would be doing a webinar anyway with just the host (chapel) as the stream, it would make since to just use the webcasting platform.

Back to the topic here, the problem I find with the reporting is that there isn't a way to find out how many people may be watching from 1 location. We asked people in my Ward when we were using it to put their last name with the number of people (for example, "Smith (7)" in the name field). Then I wrote a little application to grab the data from the webcast platform and extract the number from the line and make it available in a column for easy counting. I also made it so it would look at the connected time and only count people who were connected for 10 minutes or more.

I'll have it posted to my web server tomorrow, so I'll keep you posted on when its up.
New Member
#12
We've just wrapped up our stake conference that we conducted via a Zoom Webinar. It's a smaller stake so we didn't come near the 500 connection limit. In order to count the attendance, we set up a Zoom poll that we showed during the intermediate hymn asking "How many are watching from your home?" with options 1, 2, etc. up to "10 or more".

You can then head to the Reports section of Zoom and download the poll results as a CSV. On the reports page you can see the number of unique viewers, and the number of responses will be in the CSV, so you can even extrapolate the responses to get a better idea of actual attendance if not everyone responds. (e.g. If you get 120 responses from 150 unique views, that's 120/150 = 80%. If the reported attendance from the poll sums up to 300, you can extrapolate by doing 300 / .80 = 375 estimated attendance).
Member
#13
I would like to know if MLS has the event attendance statistics so that the clerks can get it.

At the moment they make me go in and copy and paste the attendance from the logs into an email for each ward, as I am the STS for the Magna Stake.

It is very time consuming, and it would make better sense to not give it to the STS, but to the Ward Clerks who need it, and also the Stake Clerk.

What do you think? Is there a way the Clerks have access to this data?
Community Moderators
#14
simph1 wrote:Is there a way the Clerks have access to this data?
Just give them the calling of Assistant Technology Specialist. Done.
So we can better help you, please edit your Profile to include your general location.
Community Administrator
#15
simph1 wrote:I would like to know if MLS has the event attendance statistics so that the clerks can get it.

At the moment they make me go in and copy and paste the attendance from the logs into an email for each ward, as I am the STS for the Magna Stake.

It is very time consuming, and it would make better sense to not give it to the STS, but to the Ward Clerks who need it, and also the Stake Clerk.

What do you think? Is there a way the Clerks have access to this data?
Keep in mind the church is trying to encourage units to use their Zoom account as using the webcast system for weekly meetings is adding a significant cost to the church. Moving the weekly meetings to some other platform solves the problem as well.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
Member
#16
Hi Russell,

I agree, and all I was saying is that in the clerk office computer where the ward clerks actually need the sacrament attendance information, which is contained in part in the logs of the webcast event for that ward.

Do not get me wrong however, because I know STS does need that information for technical reasons to make sure that the broadcast is receiving users and their usernames, which is a nice thing to have at our disposal.

If we had that report put in MLS for only Ward Clerks and Assistant Ward Clerks, perhaps that would help in the long run, and take this burden from STS to give the Clerks that information each week, as it is only really a list of names who attended the sacrament meeting, and they desperately need that information as it is allowed to be included in the Bishops budget which is calculated in part from that attendance.

What do you think?
Member
#17
jnpetersen wrote:I understand the need for Zoom accounts, but I really think the webcasting platform is the best platform for most cases as it is the most non-interactive platform we can use. Especially from a Building, since you would be doing a webinar anyway with just the host (chapel) as the stream, it would make since to just use the webcasting platform.
In our stake we have zoom scheduled meetings for things like 2nd hour classes / lessons (Priesthood, Sunday School, Relief Society etc).

We also have other meetings like Bishop Interviews, Welfare and Ward Council meetings, and all kinds of things.

Benefits of a Zoom Scheduled Meeting as a Webcast:
1. We have members in the ward or stake who have little technical ability.
2. Sometimes we want to include all even if they cannot install and create an account in zoom.
3. Bishop meetings and various council meetings in zoom.
4. Stake President stake conferences where we have interactive Priesthood / Leadership meetings, for those who cannot get into zoom.
5. 2nd hour classes like Priesthood, Relief Society, Youth and Adult Sunday School meetings again for those who want to watch without participating due to technology constraints.

I also from time to time if I cannot make the scheduled 2nd hour, give say the Elders Quorum President or Relief Society President the host keycode, so that the designated person can start the breakout rooms, and ensure that the meeting starts on time, where they click participants and then click on 'claim host', type the 6 digit number in, and whola, we have a host in the meeting. Then when I arrive into the meeting signed in as the license credentials, it automatically makes that host a participant instantly, and you are the host.

That is a great way to allow a class to start where you cannot get there, and where you do not have to give out the credentials to the zoom license account, where someone could delete meetings, change settings and so forth!

I hope that gives you some ideas, of that we use.

Simon
Community Moderators
#18
I am receiving reports today that the Church webcast system randomly, unceremoniously, and with equal opportunity dumped most of our members at various points during stake conference. Almost all of them dutifully reacquired the link and continued watching.

Now, as I review the attendance report, I see that almost everyone in on the list twice. Does that mean that our attendance was actually only half of the number reported?
Community Administrator
#19
I've always found multiple entries on the list. You'd probably have to count them by hand to have an accurate number.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
Community Moderators
#20
russellhltn wrote:I've always found multiple entries on the list. You'd probably have to count them by hand to have an accurate number.
Even better, our conference ended this morning, and the attendance count is still going up! Every time I check there are more names on the list. There are over 100 more names this evening than were on the list after the session ended at noon.
Community Administrator
#21
lajackson wrote:Even better, our conference ended this morning, and the attendance count is still going up!
Presumably those additions are showing as "post event".
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
Community Moderators
#22
russellhltn wrote:Presumably those additions are showing as "post event".
Nope. I think they should show when they happen, don't you? We got another 3% bump in stake conference attendance overnight. And some of our recent sacrament meetings are up, as well. Should I tell the ward clerks?
Community Administrator
#23
That's strange.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
#24
Mikerowaved wrote:Probably moot anyway now that we've been asked to move to other platforms.
This is not moot, the existing platform is still widely used for stake conferences as designed, the historical report is useless without a TON of time to process that data. The API (which access appears to have been shut off) provided the data in a format that was at least useful.

Just had a stake conference today, and the historical report wasn't helpful at all to the stake clerk. *frustrated*
New Member
#25
I was just going to use the script I wrote to grab the data from a recent meeting using the webcast platform and my error states "Authorization has been denied for this request." I guess they may have picked up on us using it :D
rl_albright wrote:
Mikerowaved wrote:Probably moot anyway now that we've been asked to move to other platforms.
This is not moot, the existing platform is still widely used for stake conferences as designed, the historical report is useless without a TON of time to process that data. The API (which access appears to have been shut off) provided the data in a format that was at least useful.

Just had a stake conference today, and the historical report wasn't helpful at all to the stake clerk. *frustrated*
New Member
#26
I did however find a way to use it again, but only by logging in, viewing the network traffic to find the key I need, then placing it in my script... extra work, but it makes the data so much easier to use.
New Member
#27
I do the same! I've actually added logic to remove duplicates unless they start with "Anonymous".

Our chapels all have literal push-button solutions that stream sacrament meeting to repeat scheduled Meetinghouse webcast events. Bishoprics arrive, push "on", and the stream starts going when the event ends the pre-buffer process. Then, they push "off" when they're done. So much easier than Zoom...and running a quick script with each ward's respective clerk's email address configured makes for very fast report generation, filtering, and delivery.

Benefits outweigh Zoom in many aspects in my opinion...like not depending on someone's device each week, which can be a real pain when the designated person or persons aren't in attendance for whatever reason.
New Member
#28
We also face the same sitiuation This is needed as the current analytics page is useless for Ward Sacrament meeting or Stake Conference reporting. It was designed for building-to-building broadcasts, not for building-to dozens of people.
Community Administrator
#29
mantigliozk wrote: Mon May 09, 2022 9:38 am We also face the same sitiuation This is needed as the current analytics page is useless for Ward Sacrament meeting or Stake Conference reporting. It was designed for building-to-building broadcasts, not for building-to dozens of people.
Given that the church webcast system is being shut down in two months, I wouldn't expect any kind of fix.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
Member
#30
I have built a custom website that records the peoples names, how many watching on the device and when and for what meeting type. Sacrament, Baptisms etc, I even programmed a form for the sacrament program etc, so our historian can have it for posterity. If anyone is interested in such a system let me know, it works great for our stake. I am a former missionary php programmer for lds tech. The YouTube link is put into the website, and obs creates the stream. Then there is stake and ward clerk reports built into the site.
Member
#31
Obs allows for scenes. For example when I click talks scene, the microphone and video comes on, and when I click on sacrament scene a text and picture of Jesus comes up saying that the sacrament is now being blessed and passed by the priesthood, broadcast will continue shortly. The audio and video is not on that scene and then I click back onto the talks scene to bring back online the mic and video. Without stopping the broadcast, very easy to setup and use during meetings.
#32
simph1 wrote: Tue May 10, 2022 6:09 am I have built a custom website that records the peoples names, how many watching on the device and when and for what meeting type. Sacrament, Baptisms etc, I even programmed a form for the sacrament program etc, so our historian can have it for posterity. If anyone is interested in such a system let me know, it works great for our stake. I am a former missionary php programmer for lds tech. The YouTube link is put into the website, and obs creates the stream. Then there is stake and ward clerk reports built into the site.
I would be interested in taking a look at this.
Member
#33
rl_albright wrote: Wed May 11, 2022 12:47 am
simph1 wrote: Tue May 10, 2022 6:09 am I have built a custom website that records the peoples names, how many watching on the device and when and for what meeting type. Sacrament, Baptisms etc, I even programmed a form for the sacrament program etc, so our historian can have it for posterity. If anyone is interested in such a system let me know, it works great for our stake. I am a former missionary php programmer for lds tech. The YouTube link is put into the website, and obs creates the stream. Then there is stake and ward clerk reports built into the site.
I would be interested in taking a look at this.
I have messaged you in a private message screenshots etc. . . let me know if you do not get the message. :)
Member
#34
Is anyone interested in looking over the system I programmed for my stake?