Did They Attend A Second Time?

Sept. 24, 2024

On facebook someone asked:

I want a report:
That shows all people who have come for the first time
That then lists the true false for if they came back.

With Datafeeds this is simple.

didtheyreturn

Create a Check-Ins Activity Datafeed for the range of time we want to analyze.

Name your Datafeed "Checkins From 2024" to make the formulas easier.

Screenshot 2021-03-23 191717


Once Datafeed runs then Open a new google Sheet and link the Datafeed to a tab in your sheet. Learn to do this here. Make sure you check the box to rename the sheet.

Now we will use a couple formulas to get our final data.
You can use this Google Sheet Template for Did They Return?


Create A second tab and in the first column and row add this formula
=UNIQUE('Checkins From 2024 (CHECKINS PEOPLE ACTIVITY)'!B:B)

column1_did_they_return


This will show only the first time a pco_id shows up in the Datafeed.

In the second column enter Name for the header and in the cell beneath the formula:
=ARRAYFORMULA(IF(A2:A="", "", VLOOKUP(A2:A, 'Checkins From 2024 (CHECKINS PEOPLE ACTIVITY)'!B2:F, 2, FALSE)))

column2_did_they_return

In the third column add First Attendance and in the cell beneath add:
=ARRAYFORMULA(IF(A2:A="", "", VLOOKUP(A2:A, 'Checkins From 2024 (CHECKINS PEOPLE ACTIVITY)'!B2:F, 5, FALSE)))

column3_did_they_return


This shows the first date they attended

Finally in the fourth column put "Came Back?" and in the cell beneath:
=ARRAYFORMULA(IF(A2:A="", "", IF(COUNTIF('Checkins From 2024 (CHECKINS PEOPLE ACTIVITY)'!B2:B, A2:A)>1, "Yes", "No")))

column4_did_they_return

Now you have a list of everyone who attended across the entire Datafeed's time range and whether they returned or not!

Again the Free Google Sheet Template is at this link.

Datafeeds are a chef+ recipe and require a subscription, but you can make a 7 day Datafeed to try this out! I hope this helps you do more ministry less paperwork!