Cameron Rentch (cameron@internetthings.com)
2025-05-01 13:04:05

@Ryan @deleted-U06C7A8PVLJ @Nicholas McFadden @deleted-U05EFH3S2TA @Malissa

Please see atatched screenshot from @deleted-U05EFH3S2TA in regards to DL/Flatirons/ACTS LA County juv Hall campaign

Benchmark report here showing:

https://docs.google.com/spreadsheets/d/1m4rxn2RqSaVGAiuInWMKWRkKaaWZ0G40bkW9GnC1gBM/edit?gid=432371362#gid=432371362

CA juv Hall = 331 QA signed and approved, DL Flatirons DASH/and our database showing 334 (NOT MATCH)

LA county foster care = 11 QA signed and approved. DL Flatirons DASH/AND OUT DATABASE SHOWING 10 (NOT MATCH)

LA JUV HALL TV = 3 QA signed and approved. DL Flatirons dash /and our databse showing 3 (MATCH)

I can not express how important and critical it is that our numbers MATCH 100%. We can not have discrepancies, under any circumstances. Please review this and ensure ALL match, and everything is updated to properly reflect whatever is accurate. Also, please let me know WHERE the discrepancy is in the data

Flatirons Campaign Benchmark Data
☝️:skin_tone_4: Ryan
Cameron Rentch (cameron@internetthings.com)
2025-05-01 13:04:08

@Ryan @deleted-U06C7A8PVLJ @Nicholas McFadden @deleted-U05EFH3S2TA @Malissa

Please see atatched screenshot from @deleted-U05EFH3S2TA in regards to DL/Flatirons/ACTS LA County juv Hall campaign

Benchmark report here showing:

https://docs.google.com/spreadsheets/d/1m4rxn2RqSaVGAiuInWMKWRkKaaWZ0G40bkW9GnC1gBM/edit?gid=432371362#gid=432371362

CA juv Hall = 331 QA signed and approved, DL Flatirons DASH/and our database showing 334 (NOT MATCH)

LA county foster care = 11 QA signed and approved. DL Flatirons DASH/AND OUT DATABASE SHOWING 10 (NOT MATCH)

LA JUV HALL TV = 3 QA signed and approved. DL Flatirons dash /and our databse showing 3 (MATCH)

I can not express how important and critical it is that our numbers MATCH 100%. We can not have discrepancies, under any circumstances. Please review this and ensure ALL match, and everything is updated to properly reflect whatever is accurate. Also, please let me know WHERE the discrepancy is in the data

Cameron Rentch (cameron@internetthings.com)
2025-05-01 13:06:21
image (6).png
Cameron Rentch (cameron@internetthings.com)
2025-05-01 13:06:29

above is image from Alan^

deleted-U06C7A8PVLJ
2025-05-01 13:06:59

@Cameron Rentch We will look into this and we will post an updated status on this that includes those discrepancies along with the proper corrections to fix this

✅ Ryan
Cameron Rentch (cameron@internetthings.com)
2025-05-01 13:10:36

thanks @deleted-U06C7A8PVLJ

✅ deleted-U06C7A8PVLJ, Ryan
Ryan (ryan@themedialab.agency)
2025-05-01 13:26:55

@Zekarias Haile, please get with Edward to ensure SL PostGress MediaRaw_v2 table is updated to match Edwards post-reconciliation perfectly.

✅ deleted-U06C7A8PVLJ
deleted-U06C7A8PVLJ
2025-05-01 15:20:47

Hi team, just providing an update on the discrepancies mentioned above — @here After completing my investigation, I was able to identify the reasons behind the differences and have attached screenshots for visual reference. CA Juv Hall: Law Ruler shows 331 leads when filtered by the following statuses: • Signed e-Sign FINAL • Signed e-Sign FINAL - SENT • Signed e-Sign QA • Signed e-Sign RE-TRIGGERED This matches the count in both our Flatirons Benchmark (which applies a custom filter for just these four statuses) and our raw database queries. The Looker Studio dashboard shows 334, and the difference of 3 comes from leads marked as Signed e-Sign - Billable Declined by Firm. This is still considered a billable status and is included in Column F of the Flatirons Benchmark, but not in Column B (which is used for the comparison). So, 331 (from Column B) + 3 (from Column F) = 334, matching the dashboard — no discrepancies here. LA County Foster Care: The count was off by 1 because the dashboard had not yet been updated at the time it was reviewed. I’ve since updated the Flatirons Benchmark for that one-off client to ensure alignment so that should be reflecting now. Meanwhile, the reporting team is currently in the process of updating secondary interview dates in Law Ruler using the Import Wizard, (to align with Abe's request earlier ago). Moving forward, we’ll make sure the count and statuses are updated earlier in the day to avoid timing discrepancies. I hope that makes sense and please let me know if you have any questions @Cameron Rentch

image.png
image.png
image.png
image.png
image.png
image.png
deleted-U06C7A8PVLJ
2025-05-01 15:24:51

@Cameron Rentch Normally, the dashboard is updated first thing in the morning. However, due to a priority deadline from Abe, the reporting team focused on reconciling secondary interview dates — before updating the dashboard which is why we had that 1 off.

Since updating Law Ruler through the Import Wizard takes time, the plan was to refresh the dashboard once that process was complete.

That said, going forward, we’ll ensure the dashboard is still updated at the start of the day. Any additional updates, such as changes to date fields, can be applied afterward. This will help prevent delays in counts and avoid discrepancies between the Flatirons Benchmark (Google Sheets) and our database.

🙏 Cameron Rentch
🙏:skin_tone_4: Ryan