Question

Photo of Kelley Johnson

0

Children's Ministry Reports

3

Is anyone using Rock to create reports for Children's Ministry?  Our church recently switched to using Rock and I am trying to create reports for kids first visit and second visit, as well as a report that captures kids who have not attended in a while. When I set up a data view using any of these fields as a filter there are no results.  It appears that even though we have used Rock for 6 weeks to check kids in and have 6 weeks of attendance data that there is still no information being stored in the first visit, second visit, or last checked-in fields.  I would love to connect with someone who is using Rock effectively in children's ministry!  Thanks for your help!!

  • Photo of Daniel Hazelbaker

    0

    Hi Kelley,

    Got an update for you. It looks like the Family Analytics job might have a bug that prevents it from ever populating the 'First Visit' and 'Second Visit' attributes. I have submitted a bug report on it here. It's probably more tech talk than you care to read, but you should be able to monitor it to see when it is reported as fixed.

    (Edit:) The 'Last Checked-In' and 'First Checked-In' attributes should still be populating as long as the Job is setup to run.

  • Photo of Daniel Hazelbaker

    1

    Both the "First Checked-In" and "Last Checked-In" attributes are populated by the Family Analytics job. It also populates the "Times Checked-In (16 wks)" Attribute as well. If that job isn't setup to run make sure to do so and then check again after it runs. If that still doesn't fix it (or it's already on) post back and we can try to do some more digging.

  • Photo of Michael Garrison

    0

    Hey Kelley!

    I'm afraid I can't answer why "Last check-in" isn't being populated- I'll have to leave that to others.

    I can tell you that first visit and second visit only get automatically populated if you have the "Family Analytics" job turned on- and then only when the records meet certain criteria. See callout 3 on the graphic in the documentation here for more information on that. It's possible this same tool is what sets first/last checked in (above) but I don't know that one way or another.

    Regarding creating reports, I recommend that you take a look at the built-in attendance analytics page for lots more options.

    If you really, really want a dataview-driven report that uses check-in information, you can do so by using the "Attended [group] x number of times in the last y weeks" filter. For instance, if you want first time check-ins, you could use two such filters together- something like "Attended children's services exactly 1 time in the last 200 weeks" and "Attended children's services exactly 0 times in the previous 199 weeks"...of course, that would require that you always check the report in the week directly following the weekend in question. For other uses I think you'd be better off using the Attendance Analytics, since you can dynamically set the weekend in question.

    Once you figure out if/why "first/last checked-in" attributes aren't working, you could also create a data view to get people who first checked in greater than (current date-28 days), for instance.

    Finally, I have an old post on ShoulderTheBoulder.com that ... isn't what you're probably thinking of as a "report" but gives an interesting color-coded grid view of attendance patterns...check that out here.

    Attendance Grid

    Be sure to let us know if you have questions about any of these tools, or need clarification on anything I mentioned

    And welcome to Rock! =)