{"ok":true,"service":"gymmaster-ingest","version":"local","buildTime":"2026-09-24T07:46:15.924Z","frontHousePostgresConfigured":true,"memory":{"rssMb":139.3,"heapUsedMb":26.2,"heapTotalMb":31.3,"externalMb":5.7,"arrayBuffersMb":2.2,"rssLimitMb":6144,"heapLimitMb":3072,"pressure":false},"miniPwpDerivationPolicy":{"version":"2026-06-18-mini-pwp-value-v2","includes":["3D Body Scan","PT / personal training","VO2 / RMR","bloodwork panels"],"excludes":["massage"],"valueSource":"actual GymMaster booking price when available; zero-value bookings stay zero"},"miniPwpTrackerReadModel":{"workerWriterEnabled":true,"postgresConfigured":true,"postgresWriterEnabled":true,"postgresBackfillEnabled":true,"postgresProviderSourceEnabled":true,"independentReconcileEnabled":true,"independentReconcileTimeWita":"01:55","boundedBackfillAvailable":true,"trackerBackfillPath":"/run/mini-pwp-tracker-backfill","postgresBackfillPath":"/analytics/mini-pwp-tracker/backfill","legacyBackfillDisabled":true,"appointmentAutomationInvokedByTrackerBackfill":false,"contractVersion":"2026-07-29-tracker-sidecar-v3","readModelContractVersion":"2026-07-29-report-ready-sidecar-v3","backfill":{"status":"idle"},"postgresBackfill":{"status":"idle"}},"dailyIngestTimeWita":"02:20","dailyAnalyticsTimeWita":"03:40","dailyVisitsTimeWita":"03:50","dailyRevenueTimeWita":"04:20","revenueCampaignSnapshotLookbackDays":14,"dailyRevenueInteractionTimeWita":"04:45","topAttendanceCampaignEnabled":true,"topAttendanceCampaignTimeWita":"04:05","consistencyChampionCampaignEnabled":true,"consistencyChampionCampaignTimeWita":"04:10","revenueIncrementalLookbackDays":14,"revenueIncrementalChunkDays":7,"revenueManagementReadModel":{"source":"postgres","legacyConvexProjection":"retired"},"revenueManagementPostgres":{"configured":true,"primaryWriter":true,"source":"postgres","sourceFactCount":1280443,"rowCount":32036,"coverageStartDate":"2024-01-26","coverageEndDate":"2026-09-25","coverageCount":398,"legacyArchive":[{"sourceTable":"revenueConversionFacts","count":331,"startDate":"2025-12-16","endDate":"2026-07-29"},{"sourceTable":"revenueManagementRows","count":29909,"startDate":"2025-01-01","endDate":"2026-07-31"}]},"revenueInteractionDailyLookbackDays":75,"revenueInteractionAiConfigured":true,"watiHistorySync":{"enabled":true,"configured":true,"intervalMinutes":60,"lookbackDays":14,"targetLimit":500,"dailyPreviousDayEnabled":true,"dailyPreviousDayTimeWita":"00:30","dailyPreviousDayTargetBatchSize":500,"dailyPreviousDayTargetDelayMs":250,"dailyPreviousDayMaxBatches":12,"running":false,"latestRun":{"status":"success","startedAt":"2026-09-24T16:05:15.249Z","finishedAt":"2026-09-24T16:13:23.551Z","metrics":{"ok":true,"dryRun":false,"lookbackDays":14,"maxPages":3,"pageSize":50,"targets":500,"rows":1427,"targetSummaries":[{"target":"380632940031","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"19727400701","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"917456052690","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"16466301224","reason":"recent_campaign_send","rows":0},{"target":"7868706516","reason":"recent_campaign_send","rows":1},{"target":"14133139102","reason":"recent_campaign_send","rows":0},{"target":"7484856238","reason":"recent_campaign_send","rows":4},{"target":"62123123123","reason":"recent_campaign_send","rows":1},{"target":"12623087729","reason":"recent_campaign_send","rows":0},{"target":"19546009446","reason":"recent_campaign_send","rows":0},{"target":"9732165322","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"44123123123","reason":"recent_campaign_send","rows":0},{"target":"503233536","reason":"recent_campaign_send","rows":0},{"target":"6287745034504","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"13105254326","reason":"recent_campaign_send","rows":0},{"target":"447762818944","reason":"recent_campaign_send","rows":1},{"target":"627334897","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"919048765400","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"38970258722","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"15628331946","reason":"recent_campaign_send","rows":0},{"target":"4477802933342","reason":"recent_campaign_send","rows":0},{"target":"971586130023","reason":"recent_campaign_send","rows":0},{"target":"8618657160681","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"18137335488","reason":"recent_campaign_send","rows":0},{"target":"17023032005","reason":"recent_campaign_send","rows":0},{"target":"15136334960","reason":"recent_campaign_send","rows":0},{"target":"141550963","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4815121305373","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905364972766","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"13059895783","reason":"recent_campaign_send","rows":0},{"target":"13476817657","reason":"recent_campaign_send","rows":0},{"target":"971564602286","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"41491950587","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"61404585380","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6288987654350","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282146599381","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"46773642","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6580921275","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"16508339519","reason":"recent_campaign_send","rows":0},{"target":"13372651907","reason":"recent_campaign_send","rows":0},{"target":"19738964295","reason":"recent_campaign_send","rows":0},{"target":"917006429381","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"905334711010","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"14155797908","reason":"recent_campaign_send","rows":0},{"target":"19493062957","reason":"recent_campaign_send","rows":0},{"target":"491607224836","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"35799954605","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"35797484446","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"9524600849","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"14088020158","reason":"recent_campaign_send","rows":0},{"target":"6281337582208","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281554487811","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16462353888","reason":"recent_campaign_send","rows":0},{"target":"6281380219562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"49162268083","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447766928751","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"640068733","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6282339537166","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"17078438089","reason":"recent_campaign_send","rows":0},{"target":"98133470","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6285190477450","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"13233043133","reason":"recent_campaign_send","rows":0},{"target":"97270657","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"421902086777","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6282339641425","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6421960191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33683925370","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"38500805208","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"19498768146","reason":"recent_campaign_send","rows":0},{"target":"13057201266","reason":"recent_campaign_send","rows":0},{"target":"6282339557567","reason":"recent_campaign_send","rows":4},{"target":"19297743802","reason":"recent_campaign_send","rows":0},{"target":"14692859694","reason":"recent_campaign_send","rows":0},{"target":"61400688243","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4387387613","reason":"recent_campaign_send","rows":1},{"target":"61407374817","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4872089111","reason":"recent_campaign_send","rows":1},{"target":"79999969894","reason":"recent_campaign_send","rows":2},{"target":"13055899329","reason":"recent_campaign_send","rows":0},{"target":"14803694697","reason":"recent_campaign_send","rows":0},{"target":"9548398538","reason":"recent_campaign_send","rows":3},{"target":"32470572019","reason":"recent_campaign_send","rows":3},{"target":"6287720933368","reason":"recent_campaign_send","rows":2},{"target":"46420564","reason":"recent_campaign_send","rows":1},{"target":"12245959650","reason":"recent_campaign_send","rows":0},{"target":"2126045855","reason":"recent_campaign_send","rows":3},{"target":"13106514894","reason":"recent_campaign_send","rows":0},{"target":"6285190752683","reason":"recent_campaign_send","rows":2},{"target":"13214247745","reason":"recent_campaign_send","rows":0},{"target":"6289259971550","reason":"recent_campaign_send","rows":2},{"target":"720486363","reason":"recent_campaign_send","rows":2},{"target":"3403673185","reason":"recent_campaign_send","rows":3},{"target":"14359998620","reason":"recent_campaign_send","rows":0},{"target":"19132002082","reason":"recent_campaign_send","rows":0},{"target":"19725671155","reason":"recent_campaign_send","rows":0},{"target":"18014004469","reason":"recent_campaign_send","rows":0},{"target":"7496315516","reason":"recent_campaign_send","rows":1},{"target":"19253898695","reason":"recent_campaign_send","rows":0},{"target":"17475772791","reason":"recent_campaign_send","rows":0},{"target":"6285190636633","reason":"recent_campaign_send","rows":1},{"target":"17077070117","reason":"recent_campaign_send","rows":0},{"target":"79037491451","reason":"recent_campaign_send","rows":4},{"target":"37361005128","reason":"recent_campaign_send","rows":4},{"target":"19178608750","reason":"recent_campaign_send","rows":0},{"target":"971556415762","reason":"recent_campaign_send","rows":2},{"target":"12154508767","reason":"recent_campaign_send","rows":0},{"target":"15599166247","reason":"recent_campaign_send","rows":0},{"target":"15625081618","reason":"recent_campaign_send","rows":0},{"target":"6281353562595","reason":"recent_campaign_send","rows":3},{"target":"6508338641","reason":"recent_campaign_send","rows":1},{"target":"9175844886","reason":"recent_campaign_send","rows":1},{"target":"13039605733","reason":"recent_campaign_send","rows":0},{"target":"919394419817","reason":"recent_campaign_send","rows":1},{"target":"16073810420","reason":"recent_campaign_send","rows":0},{"target":"6281325517103","reason":"recent_campaign_send","rows":2},{"target":"4366567221984","reason":"recent_campaign_send","rows":1},{"target":"6289152285952","reason":"recent_campaign_send","rows":1},{"target":"79980020","reason":"recent_campaign_send","rows":1},{"target":"3161354722","reason":"recent_campaign_send","rows":1},{"target":"447741275881","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6282141759225","reason":"recent_campaign_send","rows":1},{"target":"18057559827","reason":"recent_campaign_send","rows":0},{"target":"14259411864","reason":"recent_campaign_send","rows":0},{"target":"19546435137","reason":"recent_campaign_send","rows":0},{"target":"520512","reason":"recent_campaign_send","rows":0,"error":"wati_history_fetch_failed_400"},{"target":"674731044","reason":"recent_campaign_send","rows":1},{"target":"611475293","reason":"recent_campaign_send","rows":1},{"target":"79653464554","reason":"recent_campaign_send","rows":1},{"target":"19173025603","reason":"recent_campaign_send","rows":0},{"target":"451631362507","reason":"recent_campaign_send","rows":1},{"target":"14242992549","reason":"recent_campaign_send","rows":0},{"target":"768330111","reason":"recent_campaign_send","rows":1},{"target":"85255102350","reason":"recent_campaign_send","rows":1},{"target":"6421376939","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34711775542","reason":"recent_campaign_send","rows":2},{"target":"16097758233","reason":"recent_campaign_send","rows":0},{"target":"61400703904","reason":"recent_campaign_send","rows":1},{"target":"79819730047","reason":"recent_campaign_send","rows":2},{"target":"17149098691","reason":"recent_campaign_send","rows":0},{"target":"79281326880","reason":"recent_campaign_send","rows":1},{"target":"0944612970","reason":"recent_campaign_send","rows":1},{"target":"9862948323","reason":"recent_campaign_send","rows":1},{"target":"805334675654","reason":"recent_campaign_send","rows":1},{"target":"447828441092","reason":"recent_campaign_send","rows":0},{"target":"6281246391772","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"14505598979","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"62881027089497","reason":"recent_campaign_send","rows":1},{"target":"89227889","reason":"recent_campaign_send","rows":1},{"target":"6597514074","reason":"recent_campaign_send","rows":1},{"target":"971585392728","reason":"recent_campaign_send","rows":1},{"target":"491726938148","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"447985967573","reason":"recent_outbound_whatsapp_message","rows":8},{"target":"6281237563772","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447490401748","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917620956471","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"4915129651953","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"79213634353","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31641518403","reason":"recent_outbound_whatsapp_message","rows":11},{"target":"4367762724796","reason":"recent_outbound_whatsapp_message","rows":12},{"target":"353830072778","reason":"recent_outbound_whatsapp_message","rows":56},{"target":"628111977287","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"447501126371","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6281239232323","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61422755457","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"79205770808","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"393453565754","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"64273382617","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"447502486480","reason":"recent_outbound_whatsapp_message","rows":39},{"target":"33781852961","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"16047821462","reason":"recent_outbound_whatsapp_message","rows":15},{"target":"31655538407","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"6282145593585","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"491726808054","reason":"recent_outbound_whatsapp_message","rows":12},{"target":"447508792562","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"61401339320","reason":"recent_outbound_whatsapp_message","rows":23},{"target":"31625180094","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"61410655645","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6282339518274","reason":"recent_outbound_whatsapp_message","rows":17},{"target":"447725950970","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61413323645","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"61401738596","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"6282247137870","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31611958904","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"447475123637","reason":"recent_outbound_whatsapp_message","rows":20},{"target":"61406806871","reason":"recent_outbound_whatsapp_message","rows":17},{"target":"27834602438","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"31637446105","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"31684926663","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"18187478659","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"6285219526780","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"61412461571","reason":"recent_outbound_whatsapp_message","rows":19},{"target":"6287739910155","reason":"recent_inbound_whatsapp_message","rows":26},{"target":"27810460926","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"6282266690319","reason":"recent_inbound_whatsapp_message","rows":13},{"target":"79250600857","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"61436312619","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"491607589139","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6282146180266","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"213797272180","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491725769714","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447399753838","reason":"recent_inbound_whatsapp_message","rows":42},{"target":"353862173490","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"436766371587","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61415044898","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"393758311399","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"6281337192497","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"447508677472","reason":"recent_inbound_whatsapp_message","rows":1},{"target":"628113888621","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"17788887209","reason":"recent_outbound_whatsapp_message","rows":14},{"target":"6281139413451","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"6281339470727","reason":"recent_inbound_whatsapp_message","rows":25},{"target":"491733805887","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"33627708281","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"420721109504","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"447400741596","reason":"recent_inbound_whatsapp_message","rows":15},{"target":"971585168037","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447860295625","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"33769965196","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"31614445293","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"34667007120","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"4915753582044","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"34672076187","reason":"recent_inbound_whatsapp_message","rows":11},{"target":"353877411104","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6281237570440","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"447771985163","reason":"recent_outbound_whatsapp_message","rows":18},{"target":"34641425058","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"4917696079449","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6285333686572","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"33618532036","reason":"recent_inbound_whatsapp_message","rows":11},{"target":"436764622760","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447495468145","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"27738445418","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33767323457","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"31648630924","reason":"recent_inbound_whatsapp_message","rows":15},{"target":"33744433043","reason":"recent_inbound_whatsapp_message","rows":8},{"target":"27609610085","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"31629016209","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"6281235044054","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"971506402291","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61478689905","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"491623226900","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"6287718222221","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"353858262584","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"31619525380","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"17788918718","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"6287867147966","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"19054670840","reason":"recent_inbound_whatsapp_message","rows":42},{"target":"66613192699","reason":"recent_inbound_whatsapp_message","rows":41},{"target":"61450651551","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"33767461509","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"5511954376488","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447506726770","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"6287840258332","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"905309401093","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"33676521603","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"6285258065354","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"31653546688","reason":"recent_outbound_whatsapp_message","rows":11},{"target":"33784201976","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"4917664313583","reason":"recent_inbound_whatsapp_message","rows":1},{"target":"61409471609","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"6281779079923","reason":"recent_inbound_whatsapp_message","rows":22},{"target":"6285137312560","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"31657665340","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61452510411","reason":"recent_inbound_whatsapp_message","rows":8},{"target":"447522680703","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"380506641207","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"79508585541","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"79140700036","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"61409714177","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"491625245100","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"6285190152049","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"4917681676613","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"61413035388","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61431007501","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"61489145854","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"4790044005","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"48533445633","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61457866591","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"628132693924","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6421534070","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"358505616028","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491739172540","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34656376710","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491606362581","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6287815640450","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31629394311","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447913381899","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"37494189920","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61423876887","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"529842038911","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"393474374756","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33788104935","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34603643397","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61482904667","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447403122422","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"642041588191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"628135972326","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491776769159","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4790154768","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79147580198","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"35799246732","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447923367265","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"201109480059","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"41798364777","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"79217947175","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447586551138","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905338707170","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971509231091","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34646524459","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447575896204","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6287842179000","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4741295575","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"971523825680","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"66834815500","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447871401124","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"628111539393","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"62817150789","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"5581992995097","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"37062427619","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282147807993","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31630060302","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"4917652910041","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282233105170","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"628111871573","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281353884072","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"905305532020","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447595364166","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61422421229","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"972525655707","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917643737725","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79939701182","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447903046492","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915122442577","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585716323","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281337768495","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4790608203","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61410203088","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"380675601640","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6285952832088","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31653863216","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"353852182120","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447778769743","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"212661360232","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31640502444","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"33616340862","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79313416827","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34625074675","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281233885044","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447479532974","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282144059367","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281237876182","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34620292562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"918383814751","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4797579032","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4591984160","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4591983243","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"376627075","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613816920709","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34666340538","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447738852016","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380988238888","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"35797484447","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971561682318","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971568782318","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61448659151","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"393896350924","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61400963446","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"358451188415","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"447831694696","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33665704004","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"37258117463","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31612490296","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281284463314","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"34647344466","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971526679686","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79202058590","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447759840201","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380994588346","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380991384625","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380957091723","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971585095831","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61403965463","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281339601638","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915174367403","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34627562984","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"19052362539","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447881277721","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34616948441","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436606310037","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447495623430","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6598302809","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33665642636","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447456382212","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"628117270706","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33632352821","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447584850191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282147844233","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"77473206990","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79283027888","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"436644647471","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"375297509755","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447983426412","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915221395742","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31631766531","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447745358516","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"64212211397","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915208762248","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61413237189","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491728141843","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915906425959","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31626542076","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447704059959","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"212658573480","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613981268085","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281246690601","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33677219571","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447308575057","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31642072177","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"393420023817","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61457923196","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61423401605","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33772775546","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447300368366","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61400840919","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61488188695","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61431096112","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61407732000","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447824179604","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436604102357","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61474023037","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436606315882","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"972505588622","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447940510636","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"62811387345","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281229223236","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491718633973","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4740852592","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"919819437156","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"5521975359580","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16132628217","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"15145066505","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33660133783","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31624652493","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61447481030","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79535130377","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79954959874","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61401433238","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6283878910898","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971547005673","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"62818315943","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"351910161622","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31624708101","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31628522662","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61410454794","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281339634521","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"36309002018","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971558970186","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905078228005","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"639157075274","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281338036102","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585308394","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"41798103747","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"358403587084","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971561143534","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33679498764","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585926093","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33651234447","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33658459772","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491771822898","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"306946370067","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61421866946","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"393297431200","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447877567991","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281239240548","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491637377539","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"420605523576","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61411428329","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282339888398","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34637014870","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"46793506370","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281337043020","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16043061562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613268333445","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971563388100","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61449902122","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447887294420","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281110505500","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380967593134","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61456658289","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61457889902","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31625043592","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31651252656","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31619422073","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"971585014779","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971561853856","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917656769029","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"421904433424","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4917655185656","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6584980377","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915254532983","reason":"recent_outbound_whatsapp_message","rows":1}],"upsert":{"inserted":0,"updated":0,"unchanged":1427,"skipped":0,"duplicateInputRows":0,"rows":1427}}},"latestDailyPreviousDayRun":null},"messagingInsightDrilldowns":{"enabled":true,"timeWita":"02:30","reportLimit":500,"campaignLimit":250,"latestRun":{"status":"success","startedAt":"2026-09-24T16:00:50.737Z","finishedAt":"2026-09-24T16:00:53.535Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","periodStart":"2026-09-24","periodEnd":"2026-09-24","campaigns":6,"failedCampaigns":[],"dryRun":false,"capture":{"cadence":"daily","campaignTypes":["guest_pass","instagram_promo","loyalty_3_renewals","renewal_5day","upgrade_short","winback"],"id":"js7y4sacw5y4415z8krdnhh52d8f09qq","periodLabel":"Thu 24 Sep 2026"}}],"startedAt":"2026-09-24T16:00:50.737Z","finishedAt":"2026-09-24T16:00:53.535Z"}}},"messagingInsightReports":{"enabled":true,"mode":"capture","seedTimeWita":"02:20","generationTimeWita":"03:00","externalHttpCaptureEnabled":false,"latestSeed":{"status":"success","startedAt":"2026-09-24T16:00:16.068Z","finishedAt":"2026-09-24T16:00:28.672Z","metrics":{"ok":true,"dryRun":false,"requested":1,"remaining":0,"existing":247,"inserted":1,"batches":1,"startedAt":"2026-09-24T16:00:16.068Z","finishedAt":"2026-09-24T16:00:28.672Z"}},"latestGeneration":{"status":"success","startedAt":"2026-09-24T16:00:54.696Z","finishedAt":"2026-09-24T16:01:45.249Z","metrics":{"ok":true,"mode":"capture","dryRun":false,"reports":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","periodStart":"2026-09-24","periodEnd":"2026-09-24","status":"captured","capture":{"replaced":true},"drilldownRefresh":{"campaigns":6,"captured":true},"qualityGate":{"ok":true,"reasons":[],"warnings":[]},"replyClassification":{"inboundReplies":5,"classified":0,"missingTranscriptRows":0}}],"startedAt":"2026-09-24T16:00:54.696Z","finishedAt":"2026-09-24T16:01:45.249Z"}}},"messagingInsightHistorical":{"status":"idle"},"messagingInsightReportHistorical":{"jobId":"messaging-insight-report-historical:2026-09-24T16:01:45.251Z","status":"success","startedAt":"2026-09-24T16:01:45.251Z","finishedAt":"2026-09-24T16:01:46.661Z","startDate":"2026-03-01","endDate":"2026-09-24","write":true,"localizeOnly":true,"selected":0,"cadence":"localization","processed":0,"captured":0,"localized":0,"alreadyReady":0,"skipped":0,"skipReasons":{}},"messagingReplyClassification":{"configured":true,"model":"gpt-5.6-terra","reasoning":"medium","batchSize":20,"timeWita":"02:50","latestRun":{"status":"success","startedAt":"2026-09-24T16:13:23.995Z","finishedAt":"2026-09-24T16:13:33.962Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"candidatesSeen":3,"classified":3,"unknown":0,"patchedMessages":3,"failedCampaigns":[],"summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"winback","candidates":2,"classified":2,"forceReclassify":false,"dryRun":false},{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"renewal_5day","candidates":1,"classified":1,"forceReclassify":false,"dryRun":false}],"model":"gpt-5.6-terra","reasoning":"medium","forceReclassify":false,"startedAt":"2026-09-24T16:13:23.995Z","finishedAt":"2026-09-24T16:13:33.962Z"}}},"messagingCampaignOptOutReview":{"enabled":true,"timeWita":"03:10","configured":true,"model":"gpt-5.6-terra","reasoning":"medium","batchSize":20,"confidenceThreshold":0.92,"dryRun":false,"latestRun":{"runId":"messaging-campaign-opt-out-review:2026-09-24T16:13:23.553Z","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:13:23.553Z","finishedAt":"2026-09-24T16:13:49.888Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"candidatesSeen":3,"reviewedReplies":3,"nonTextSkipped":0,"patchedMessages":3,"verdictCounts":{"exclude_all_campaigns":0,"do_not_exclude":0,"human_review":3},"eligibleForApply":0,"eligibleApplyItems":[],"appliedExclusions":0,"alreadyExcluded":0,"confidenceThreshold":0.92,"model":"gpt-5.6-terra","reasoning":"medium","summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"winback","candidates":2,"textReviewed":2,"nonTextSkipped":0},{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"renewal_5day","candidates":1,"textReviewed":1,"nonTextSkipped":0}],"startedAt":"2026-09-24T16:13:33.962Z","finishedAt":"2026-09-24T16:13:49.888Z"}}},"topAttendanceCampaign":{"enabled":true,"timeWita":"04:05","latestRun":null},"consistencyChampionCampaign":{"enabled":true,"timeWita":"04:10","latestRun":null},"assessmentAutomation":{"enabled":true,"launchDateConfigured":true,"eligibilityTimeWita":"06:30","preSendReconcileTimeWita":"08:45","maxMemberChecks":200,"latestEligibility":{"businessDate":"2026-09-25","status":"success","metrics":{"businessDate":"2026-09-25","enabled":true,"launchDate":"2026-09-22","membersInLaunchWindow":4,"memberChecksCap":200,"detailChecks":4,"bookingChecks":1,"invitations":1,"confirmations":0,"reminders":0,"memberships":4,"hcMissing":3,"candidates":1,"prior":0,"invalid":0},"queue":{"duplicates":1,"queued":0,"skipped":0}},"latestPreSendReconcile":{"businessDate":"2026-09-25","status":"success","checked":0,"skipped":0,"pendingRows":0,"verifiedMembers":0}},"noShowCompute":{"available":true,"gateHours":2,"writeEnabled":true},"hourlyIngestMinute":10,"visitIngestLookbackDays":7,"frontHouseCheckInLookbackDays":1,"frontHouseCheckInPollMinutes":10,"frontHouseWorker":{"enabled":true,"pollMs":100,"wahaCheckIntervalMs":100,"gymMasterRefreshIntervalMs":10000,"photoFetchIntervalMs":1500,"photoWebLoginConfigured":true,"running":false,"checkInIngestRunning":false,"wahaRunning":false,"refreshRunning":false,"photoRunning":false,"lastWahaAt":"2026-09-24T16:43:52.539Z","lastRefreshAt":"2026-09-24T16:43:48.934Z","lastPhotoAt":"2026-09-24T16:43:53.140Z"},"frontHouseVisitorsLive":{"enabled":true,"primed":true,"hydrated":true,"businessDate":"2026-09-25","lastEntryExitId":"","lastPersistedEntryExitId":"","watermarkSource":"bounded_replay","watermarkPersistedAt":"","lastPollAt":"2026-09-24T16:43:53.240Z","lastSuccessAt":"2026-09-24T16:43:53.303Z","lastIngestAt":"2026-09-24T13:51:23.104Z","lastError":"","lastRawRows":0,"lastDerivedRows":0,"lastUpsert":{"rows":1,"evaluated":1,"inserted":1,"updated":0,"unchanged":0},"intervalMs":250,"limit":20,"door":"-1","scrapeMemberPage":true,"maxMemberPageScrapesPerPoll":2,"running":false,"lastTickAt":"2026-09-24T16:43:53.240Z"},"frontHouseExtensionStream":{"active":0,"accepted":6,"rejected":0,"disconnected":6,"broadcastCount":176,"lastBroadcastAt":"2026-09-24T13:51:23.104Z","lastBroadcastReason":"live_check_in_ingested","lastConnectionAt":"2026-09-24T12:03:11.971Z","lastDisconnectAt":"2026-09-24T14:02:33.136Z","lastDisconnectReason":"client_close_1001","lastDisconnectAfterMs":7161165,"lastClientMessageAt":"2026-09-24T14:02:32.046Z","lastError":"write EPIPE","path":"/front-house/extension/ws"},"schedulerState":{"lastDailyDate":"","lastDailyPreSignalAttemptDate":"","lastDailyPreSignalAttemptAt":0,"lastCampaignDailyCountsDate":"2026-09-25","lastCampaignDailyCountsAttemptDate":"2026-09-25","lastCampaignDailyCountsAttemptAt":1790265709286,"lastAssessmentAutomationDate":"2026-09-25","lastAssessmentAutomationAttemptDate":"2026-09-25","lastAssessmentAutomationAttemptAt":1790265711862,"lastAssessmentPreSendReconcileDate":"2026-09-25","lastAssessmentPreSendReconcileAttemptDate":"2026-09-25","lastAssessmentPreSendReconcileAttemptAt":1790265715436,"lastAnalyticsDate":"2026-09-25","lastAnalyticsAttemptDate":"2026-09-25","lastAnalyticsAttemptAt":1790265716047,"lastVisitsDate":"","lastRevenueDate":"2026-09-25","lastRevenueAttemptDate":"2026-09-25","lastRevenueAttemptAt":1790265732372,"lastRevenueInteractionDate":"","lastRevenueConversationTimelineDate":"2026-09-25","lastHourlyKey":"2026-09-24T23","lastFrontHouseKey":"2026-09-25T24:40","lastWatiHistorySyncKey":"2026-09-25T24:00","lastWatiDailyHistorySyncDate":"","lastMessagingInsightDrilldownDate":"2026-09-25","lastMessagingInsightReportSeedDate":"2026-09-25","lastMessagingInsightReportClassificationDate":"2026-09-25","lastMessagingInsightReportClassificationAttemptAt":1790265633121,"lastMessagingInsightReportGenerationDate":"2026-09-25","lastMessagingInsightHistoricalLocalizationDate":"2026-09-25","lastMessagingCampaignOptOutReviewDate":"2026-09-25","lastTopAttendanceCampaignMonth":"","lastConsistencyChampionCampaignMonth":"","lastMiniPwpTrackerReconcileDate":"2026-09-25","running":false},"lastRunsByType":{"messaging-insight-historical-seed":{"status":"success","startedAt":"2026-09-24T16:00:16.068Z","finishedAt":"2026-09-24T16:00:28.672Z","metrics":{"ok":true,"dryRun":false,"requested":1,"remaining":0,"existing":247,"inserted":1,"batches":1,"startedAt":"2026-09-24T16:00:16.068Z","finishedAt":"2026-09-24T16:00:28.672Z"}},"messaging-insight-drilldowns":{"status":"success","startedAt":"2026-09-24T16:00:50.737Z","finishedAt":"2026-09-24T16:00:53.535Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","periodStart":"2026-09-24","periodEnd":"2026-09-24","campaigns":6,"failedCampaigns":[],"dryRun":false,"capture":{"cadence":"daily","campaignTypes":["guest_pass","instagram_promo","loyalty_3_renewals","renewal_5day","upgrade_short","winback"],"id":"js7y4sacw5y4415z8krdnhh52d8f09qq","periodLabel":"Thu 24 Sep 2026"}}],"startedAt":"2026-09-24T16:00:50.737Z","finishedAt":"2026-09-24T16:00:53.535Z"}},"messaging-insight-report-generation":{"status":"success","startedAt":"2026-09-24T16:00:54.696Z","finishedAt":"2026-09-24T16:01:45.249Z","metrics":{"ok":true,"mode":"capture","dryRun":false,"reports":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","periodStart":"2026-09-24","periodEnd":"2026-09-24","status":"captured","capture":{"replaced":true},"drilldownRefresh":{"campaigns":6,"captured":true},"qualityGate":{"ok":true,"reasons":[],"warnings":[]},"replyClassification":{"inboundReplies":5,"classified":0,"missingTranscriptRows":0}}],"startedAt":"2026-09-24T16:00:54.696Z","finishedAt":"2026-09-24T16:01:45.249Z"}},"mini-pwp-tracker-reconcile":{"runId":"mini-pwp-tracker-reconcile:2026-09-24T16:01:45.251Z","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:01:45.251Z","finishedAt":"2026-09-24T16:01:48.982Z","metrics":{"skipped":false,"dryRun":false,"startDate":"2026-09-12","endDate":"2026-09-25","outcomeEndDate":"2026-09-25","reconcileFullHistory":true,"gymMasterIds":34,"writes":{"blood_draw":{"cases":45,"metrics":37,"snapshotReportReadyEvents":192,"reportReadyEvidence":{"cases":19,"events":19},"postgres":{"skipped":false,"cases":45,"metrics":37,"providerFacts":525},"providerFacts":525,"snapshotAnchorSourceLimitReached":false},"consultation":{"cases":2,"metrics":25,"snapshotReportReadyEvents":192,"reportReadyEvidence":{"cases":2,"events":2},"postgres":{"skipped":false,"cases":2,"metrics":25,"providerFacts":0},"providerFacts":525,"snapshotAnchorSourceLimitReached":false}}}},"campaign-daily-counts":{"runId":"campaign-daily-counts:2026-09-24T16:01:49.286Z","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:01:49.286Z","finishedAt":"2026-09-24T16:01:51.585Z","metrics":{"startDate":"2026-09-18","endDate":"2026-09-24","catalogVersion":"2026-09-20-v10","sourceRows":{"messages":496,"ledger":0,"queue":421},"days":7,"sourceEvents":451,"mappedEvents":421,"unmappedEvents":30,"dryRun":false,"write":{"skipped":false,"dates":7,"sourceEvents":451,"mappedEvents":421,"unmappedEvents":30}}},"assessment-automation":{"businessDate":"2026-09-25","status":"success","metrics":{"businessDate":"2026-09-25","enabled":true,"launchDate":"2026-09-22","membersInLaunchWindow":4,"memberChecksCap":200,"detailChecks":4,"bookingChecks":1,"invitations":1,"confirmations":0,"reminders":0,"memberships":4,"hcMissing":3,"candidates":1,"prior":0,"invalid":0},"queue":{"duplicates":1,"queued":0,"skipped":0}},"assessment-pre-send-reconcile":{"businessDate":"2026-09-25","status":"success","checked":0,"skipped":0,"pendingRows":0,"verifiedMembers":0},"daily-analytics":{"runId":"daily-analytics:2026-09-24T16:01:56.047Z","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:01:56.047Z","finishedAt":"2026-09-24T16:02:12.053Z","metrics":{"window":{"startDate":"2026-09-12","endDate":"2026-09-25"},"rawRows":{"report312_classAttendances":1638,"report341_classSummary":164,"report347_staffList":50,"report351_classBookingsByMember":12670},"derivedRows":{"memberAttendances":1623,"membershipBookingFacts":1623,"classOccurrenceSummaries":164,"memberCancellations":372,"cancellationReportReadyDates":14,"cancellationReportNotReadyDates":[]},"upserts":{"memberAttendances":{"skipped":true,"reason":"postgres_authoritative"},"classOccurrenceSummaries":{"skipped":true,"reason":"postgres_authoritative"}},"zeaburStore":{"rows":1623,"membershipBookingFacts":1623,"memberCancellations":372,"coveredDates":14,"postgres":{"skipped":false,"attendances":1623,"membershipBookingFacts":1623,"memberCancellations":372,"occurrenceSummaries":164,"cancellationReportReadyDates":14}},"memberCancellationReconciliation":{"requestedDates":14,"readyDates":14,"failedDates":[]}}},"messaging-reply-classification":{"status":"success","startedAt":"2026-09-24T16:13:23.995Z","finishedAt":"2026-09-24T16:13:33.962Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"candidatesSeen":3,"classified":3,"unknown":0,"patchedMessages":3,"failedCampaigns":[],"summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"winback","candidates":2,"classified":2,"forceReclassify":false,"dryRun":false},{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"renewal_5day","candidates":1,"classified":1,"forceReclassify":false,"dryRun":false}],"model":"gpt-5.6-terra","reasoning":"medium","forceReclassify":false,"startedAt":"2026-09-24T16:13:23.995Z","finishedAt":"2026-09-24T16:13:33.962Z"}},"messaging-campaign-opt-out-review":{"runId":"messaging-campaign-opt-out-review:2026-09-24T16:13:23.553Z","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:13:23.553Z","finishedAt":"2026-09-24T16:13:49.888Z","metrics":{"ok":true,"dryRun":false,"cadences":["daily"],"candidatesSeen":3,"reviewedReplies":3,"nonTextSkipped":0,"patchedMessages":3,"verdictCounts":{"exclude_all_campaigns":0,"do_not_exclude":0,"human_review":3},"eligibleForApply":0,"eligibleApplyItems":[],"appliedExclusions":0,"alreadyExcluded":0,"confidenceThreshold":0.92,"model":"gpt-5.6-terra","reasoning":"medium","summaries":[{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"winback","candidates":2,"textReviewed":2,"nonTextSkipped":0},{"cadence":"daily","periodLabel":"Thu 24 Sep 2026","campaignType":"renewal_5day","candidates":1,"textReviewed":1,"nonTextSkipped":0}],"startedAt":"2026-09-24T16:13:33.962Z","finishedAt":"2026-09-24T16:13:49.888Z"}},"front-house-checkins":{"runId":"front-house-checkins:2026-09-25:1790268016079","status":"success","businessDate":"2026-09-25","startedAt":"2026-09-24T16:40:16.079Z","finishedAt":"2026-09-24T16:40:18.003Z","source":"gymmaster_to_db_crm","metrics":{"window":{"startDate":"2026-09-24","endDate":"2026-09-25","lookbackDays":1},"rawRows":{"report361_successfulMemberVisits":537,"report330_currentMemberships":872},"derivedRows":{"frontHouseMembershipSnapshots":872,"frontHouseEvaluations":0,"reportCandidates":391,"doorPattern":"/^turnstile\\s+main\\s+entrance$/i"},"upserts":{"frontHouseMembershipSnapshots":{"attempted":872,"written":0,"unchanged":872,"pruned":0,"complete":false},"frontHouseEvaluations":{"rows":0,"evaluated":0,"inserted":0,"updated":0,"unchanged":0}}}},"messaging-insight-report-historical":{"jobId":"messaging-insight-report-historical:2026-09-24T16:01:45.251Z","status":"success","startedAt":"2026-09-24T16:01:45.251Z","finishedAt":"2026-09-24T16:01:46.661Z","startDate":"2026-03-01","endDate":"2026-09-24","write":true,"localizeOnly":true,"selected":0,"cadence":"localization","processed":0,"captured":0,"localized":0,"alreadyReady":0,"skipped":0,"skipReasons":{}},"wati-history-sync":{"status":"success","startedAt":"2026-09-24T16:05:15.249Z","finishedAt":"2026-09-24T16:13:23.551Z","metrics":{"ok":true,"dryRun":false,"lookbackDays":14,"maxPages":3,"pageSize":50,"targets":500,"rows":1427,"targetSummaries":[{"target":"380632940031","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"19727400701","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"917456052690","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"16466301224","reason":"recent_campaign_send","rows":0},{"target":"7868706516","reason":"recent_campaign_send","rows":1},{"target":"14133139102","reason":"recent_campaign_send","rows":0},{"target":"7484856238","reason":"recent_campaign_send","rows":4},{"target":"62123123123","reason":"recent_campaign_send","rows":1},{"target":"12623087729","reason":"recent_campaign_send","rows":0},{"target":"19546009446","reason":"recent_campaign_send","rows":0},{"target":"9732165322","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"44123123123","reason":"recent_campaign_send","rows":0},{"target":"503233536","reason":"recent_campaign_send","rows":0},{"target":"6287745034504","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"13105254326","reason":"recent_campaign_send","rows":0},{"target":"447762818944","reason":"recent_campaign_send","rows":1},{"target":"627334897","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"919048765400","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"38970258722","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"15628331946","reason":"recent_campaign_send","rows":0},{"target":"4477802933342","reason":"recent_campaign_send","rows":0},{"target":"971586130023","reason":"recent_campaign_send","rows":0},{"target":"8618657160681","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"18137335488","reason":"recent_campaign_send","rows":0},{"target":"17023032005","reason":"recent_campaign_send","rows":0},{"target":"15136334960","reason":"recent_campaign_send","rows":0},{"target":"141550963","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4815121305373","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905364972766","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"13059895783","reason":"recent_campaign_send","rows":0},{"target":"13476817657","reason":"recent_campaign_send","rows":0},{"target":"971564602286","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"41491950587","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"61404585380","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6288987654350","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282146599381","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"46773642","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6580921275","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"16508339519","reason":"recent_campaign_send","rows":0},{"target":"13372651907","reason":"recent_campaign_send","rows":0},{"target":"19738964295","reason":"recent_campaign_send","rows":0},{"target":"917006429381","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"905334711010","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"14155797908","reason":"recent_campaign_send","rows":0},{"target":"19493062957","reason":"recent_campaign_send","rows":0},{"target":"491607224836","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"35799954605","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"35797484446","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"9524600849","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"14088020158","reason":"recent_campaign_send","rows":0},{"target":"6281337582208","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281554487811","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16462353888","reason":"recent_campaign_send","rows":0},{"target":"6281380219562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"49162268083","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447766928751","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"640068733","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6282339537166","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"17078438089","reason":"recent_campaign_send","rows":0},{"target":"98133470","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6285190477450","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"13233043133","reason":"recent_campaign_send","rows":0},{"target":"97270657","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"421902086777","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6282339641425","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6421960191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33683925370","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"38500805208","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"19498768146","reason":"recent_campaign_send","rows":0},{"target":"13057201266","reason":"recent_campaign_send","rows":0},{"target":"6282339557567","reason":"recent_campaign_send","rows":4},{"target":"19297743802","reason":"recent_campaign_send","rows":0},{"target":"14692859694","reason":"recent_campaign_send","rows":0},{"target":"61400688243","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4387387613","reason":"recent_campaign_send","rows":1},{"target":"61407374817","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4872089111","reason":"recent_campaign_send","rows":1},{"target":"79999969894","reason":"recent_campaign_send","rows":2},{"target":"13055899329","reason":"recent_campaign_send","rows":0},{"target":"14803694697","reason":"recent_campaign_send","rows":0},{"target":"9548398538","reason":"recent_campaign_send","rows":3},{"target":"32470572019","reason":"recent_campaign_send","rows":3},{"target":"6287720933368","reason":"recent_campaign_send","rows":2},{"target":"46420564","reason":"recent_campaign_send","rows":1},{"target":"12245959650","reason":"recent_campaign_send","rows":0},{"target":"2126045855","reason":"recent_campaign_send","rows":3},{"target":"13106514894","reason":"recent_campaign_send","rows":0},{"target":"6285190752683","reason":"recent_campaign_send","rows":2},{"target":"13214247745","reason":"recent_campaign_send","rows":0},{"target":"6289259971550","reason":"recent_campaign_send","rows":2},{"target":"720486363","reason":"recent_campaign_send","rows":2},{"target":"3403673185","reason":"recent_campaign_send","rows":3},{"target":"14359998620","reason":"recent_campaign_send","rows":0},{"target":"19132002082","reason":"recent_campaign_send","rows":0},{"target":"19725671155","reason":"recent_campaign_send","rows":0},{"target":"18014004469","reason":"recent_campaign_send","rows":0},{"target":"7496315516","reason":"recent_campaign_send","rows":1},{"target":"19253898695","reason":"recent_campaign_send","rows":0},{"target":"17475772791","reason":"recent_campaign_send","rows":0},{"target":"6285190636633","reason":"recent_campaign_send","rows":1},{"target":"17077070117","reason":"recent_campaign_send","rows":0},{"target":"79037491451","reason":"recent_campaign_send","rows":4},{"target":"37361005128","reason":"recent_campaign_send","rows":4},{"target":"19178608750","reason":"recent_campaign_send","rows":0},{"target":"971556415762","reason":"recent_campaign_send","rows":2},{"target":"12154508767","reason":"recent_campaign_send","rows":0},{"target":"15599166247","reason":"recent_campaign_send","rows":0},{"target":"15625081618","reason":"recent_campaign_send","rows":0},{"target":"6281353562595","reason":"recent_campaign_send","rows":3},{"target":"6508338641","reason":"recent_campaign_send","rows":1},{"target":"9175844886","reason":"recent_campaign_send","rows":1},{"target":"13039605733","reason":"recent_campaign_send","rows":0},{"target":"919394419817","reason":"recent_campaign_send","rows":1},{"target":"16073810420","reason":"recent_campaign_send","rows":0},{"target":"6281325517103","reason":"recent_campaign_send","rows":2},{"target":"4366567221984","reason":"recent_campaign_send","rows":1},{"target":"6289152285952","reason":"recent_campaign_send","rows":1},{"target":"79980020","reason":"recent_campaign_send","rows":1},{"target":"3161354722","reason":"recent_campaign_send","rows":1},{"target":"447741275881","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6282141759225","reason":"recent_campaign_send","rows":1},{"target":"18057559827","reason":"recent_campaign_send","rows":0},{"target":"14259411864","reason":"recent_campaign_send","rows":0},{"target":"19546435137","reason":"recent_campaign_send","rows":0},{"target":"520512","reason":"recent_campaign_send","rows":0,"error":"wati_history_fetch_failed_400"},{"target":"674731044","reason":"recent_campaign_send","rows":1},{"target":"611475293","reason":"recent_campaign_send","rows":1},{"target":"79653464554","reason":"recent_campaign_send","rows":1},{"target":"19173025603","reason":"recent_campaign_send","rows":0},{"target":"451631362507","reason":"recent_campaign_send","rows":1},{"target":"14242992549","reason":"recent_campaign_send","rows":0},{"target":"768330111","reason":"recent_campaign_send","rows":1},{"target":"85255102350","reason":"recent_campaign_send","rows":1},{"target":"6421376939","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34711775542","reason":"recent_campaign_send","rows":2},{"target":"16097758233","reason":"recent_campaign_send","rows":0},{"target":"61400703904","reason":"recent_campaign_send","rows":1},{"target":"79819730047","reason":"recent_campaign_send","rows":2},{"target":"17149098691","reason":"recent_campaign_send","rows":0},{"target":"79281326880","reason":"recent_campaign_send","rows":1},{"target":"0944612970","reason":"recent_campaign_send","rows":1},{"target":"9862948323","reason":"recent_campaign_send","rows":1},{"target":"805334675654","reason":"recent_campaign_send","rows":1},{"target":"447828441092","reason":"recent_campaign_send","rows":0},{"target":"6281246391772","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"14505598979","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"62881027089497","reason":"recent_campaign_send","rows":1},{"target":"89227889","reason":"recent_campaign_send","rows":1},{"target":"6597514074","reason":"recent_campaign_send","rows":1},{"target":"971585392728","reason":"recent_campaign_send","rows":1},{"target":"491726938148","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"447985967573","reason":"recent_outbound_whatsapp_message","rows":8},{"target":"6281237563772","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447490401748","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917620956471","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"4915129651953","reason":"recent_outbound_whatsapp_message","rows":9},{"target":"79213634353","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31641518403","reason":"recent_outbound_whatsapp_message","rows":11},{"target":"4367762724796","reason":"recent_outbound_whatsapp_message","rows":12},{"target":"353830072778","reason":"recent_outbound_whatsapp_message","rows":56},{"target":"628111977287","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"447501126371","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6281239232323","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61422755457","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"79205770808","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"393453565754","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"64273382617","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"447502486480","reason":"recent_outbound_whatsapp_message","rows":39},{"target":"33781852961","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"16047821462","reason":"recent_outbound_whatsapp_message","rows":15},{"target":"31655538407","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"6282145593585","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"491726808054","reason":"recent_outbound_whatsapp_message","rows":12},{"target":"447508792562","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"61401339320","reason":"recent_outbound_whatsapp_message","rows":23},{"target":"31625180094","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"61410655645","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6282339518274","reason":"recent_outbound_whatsapp_message","rows":17},{"target":"447725950970","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61413323645","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"61401738596","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"6282247137870","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31611958904","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"447475123637","reason":"recent_outbound_whatsapp_message","rows":20},{"target":"61406806871","reason":"recent_outbound_whatsapp_message","rows":17},{"target":"27834602438","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"31637446105","reason":"recent_outbound_whatsapp_message","rows":6},{"target":"31684926663","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"18187478659","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"6285219526780","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"61412461571","reason":"recent_outbound_whatsapp_message","rows":19},{"target":"6287739910155","reason":"recent_inbound_whatsapp_message","rows":26},{"target":"27810460926","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"6282266690319","reason":"recent_inbound_whatsapp_message","rows":13},{"target":"79250600857","reason":"recent_inbound_whatsapp_message","rows":0},{"target":"61436312619","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"491607589139","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"6282146180266","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"213797272180","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491725769714","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447399753838","reason":"recent_inbound_whatsapp_message","rows":42},{"target":"353862173490","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"436766371587","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61415044898","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"393758311399","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"6281337192497","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"447508677472","reason":"recent_inbound_whatsapp_message","rows":1},{"target":"628113888621","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"17788887209","reason":"recent_outbound_whatsapp_message","rows":14},{"target":"6281139413451","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"6281339470727","reason":"recent_inbound_whatsapp_message","rows":25},{"target":"491733805887","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"33627708281","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"420721109504","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"447400741596","reason":"recent_inbound_whatsapp_message","rows":15},{"target":"971585168037","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447860295625","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"33769965196","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"31614445293","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"34667007120","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"4915753582044","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"34672076187","reason":"recent_inbound_whatsapp_message","rows":11},{"target":"353877411104","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6281237570440","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"447771985163","reason":"recent_outbound_whatsapp_message","rows":18},{"target":"34641425058","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"4917696079449","reason":"recent_outbound_whatsapp_message","rows":5},{"target":"6285333686572","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"33618532036","reason":"recent_inbound_whatsapp_message","rows":11},{"target":"436764622760","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447495468145","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"27738445418","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33767323457","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"31648630924","reason":"recent_inbound_whatsapp_message","rows":15},{"target":"33744433043","reason":"recent_inbound_whatsapp_message","rows":8},{"target":"27609610085","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"31629016209","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"6281235044054","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"971506402291","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61478689905","reason":"recent_outbound_whatsapp_message","rows":10},{"target":"491623226900","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"6287718222221","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"353858262584","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"31619525380","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"17788918718","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"6287867147966","reason":"recent_outbound_whatsapp_message","rows":13},{"target":"19054670840","reason":"recent_inbound_whatsapp_message","rows":42},{"target":"66613192699","reason":"recent_inbound_whatsapp_message","rows":41},{"target":"61450651551","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"33767461509","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"5511954376488","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"447506726770","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"6287840258332","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"905309401093","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"33676521603","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"6285258065354","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"31653546688","reason":"recent_outbound_whatsapp_message","rows":11},{"target":"33784201976","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"4917664313583","reason":"recent_inbound_whatsapp_message","rows":1},{"target":"61409471609","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"6281779079923","reason":"recent_inbound_whatsapp_message","rows":22},{"target":"6285137312560","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"31657665340","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61452510411","reason":"recent_inbound_whatsapp_message","rows":8},{"target":"447522680703","reason":"recent_inbound_whatsapp_message","rows":9},{"target":"380506641207","reason":"recent_inbound_whatsapp_message","rows":7},{"target":"79508585541","reason":"recent_outbound_whatsapp_message","rows":7},{"target":"79140700036","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"61409714177","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"491625245100","reason":"recent_inbound_whatsapp_message","rows":6},{"target":"6285190152049","reason":"recent_inbound_whatsapp_message","rows":4},{"target":"4917681676613","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"61413035388","reason":"recent_inbound_whatsapp_message","rows":5},{"target":"61431007501","reason":"recent_inbound_whatsapp_message","rows":2},{"target":"61489145854","reason":"recent_inbound_whatsapp_message","rows":3},{"target":"4790044005","reason":"recent_inbound_whatsapp_message","rows":10},{"target":"48533445633","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61457866591","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"628132693924","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6421534070","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"358505616028","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491739172540","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34656376710","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491606362581","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6287815640450","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31629394311","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447913381899","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"37494189920","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61423876887","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"529842038911","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"393474374756","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33788104935","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34603643397","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61482904667","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447403122422","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"642041588191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"628135972326","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491776769159","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4790154768","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79147580198","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"35799246732","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447923367265","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"201109480059","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"41798364777","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"79217947175","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447586551138","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905338707170","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971509231091","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34646524459","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447575896204","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6287842179000","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4741295575","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"971523825680","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"66834815500","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447871401124","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"628111539393","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"62817150789","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"5581992995097","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"37062427619","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282147807993","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31630060302","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"4917652910041","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"6282233105170","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"628111871573","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281353884072","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"905305532020","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447595364166","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61422421229","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"972525655707","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917643737725","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79939701182","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447903046492","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915122442577","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585716323","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281337768495","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4790608203","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61410203088","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"380675601640","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6285952832088","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31653863216","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"353852182120","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447778769743","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"212661360232","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31640502444","reason":"recent_outbound_whatsapp_message","rows":4},{"target":"33616340862","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79313416827","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34625074675","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281233885044","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447479532974","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282144059367","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281237876182","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34620292562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"918383814751","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4797579032","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4591984160","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4591983243","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"376627075","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613816920709","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34666340538","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447738852016","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380988238888","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"35797484447","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971561682318","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971568782318","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61448659151","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"393896350924","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61400963446","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"358451188415","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"447831694696","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33665704004","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"37258117463","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31612490296","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281284463314","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"34647344466","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971526679686","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"79202058590","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447759840201","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380994588346","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380991384625","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380957091723","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971585095831","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61403965463","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281339601638","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915174367403","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34627562984","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"19052362539","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447881277721","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34616948441","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436606310037","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447495623430","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6598302809","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33665642636","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447456382212","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"628117270706","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33632352821","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447584850191","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282147844233","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"77473206990","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79283027888","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"436644647471","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"375297509755","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447983426412","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915221395742","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31631766531","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447745358516","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"64212211397","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915208762248","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61413237189","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491728141843","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4915906425959","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31626542076","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"447704059959","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"212658573480","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613981268085","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281246690601","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33677219571","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447308575057","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"31642072177","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"393420023817","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61457923196","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61423401605","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"33772775546","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447300368366","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61400840919","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61488188695","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61431096112","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61407732000","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447824179604","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436604102357","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61474023037","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"436606315882","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"972505588622","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447940510636","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"62811387345","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281229223236","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"491718633973","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"4740852592","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"919819437156","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"5521975359580","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16132628217","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"15145066505","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33660133783","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31624652493","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61447481030","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79535130377","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"79954959874","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61401433238","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6283878910898","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971547005673","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"62818315943","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"351910161622","reason":"recent_outbound_whatsapp_message","rows":3},{"target":"31624708101","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"31628522662","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61410454794","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281339634521","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"36309002018","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971558970186","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"905078228005","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"639157075274","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281338036102","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585308394","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"41798103747","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"358403587084","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971561143534","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33679498764","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971585926093","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33651234447","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"33658459772","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491771822898","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"306946370067","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"61421866946","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"393297431200","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"447877567991","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"6281239240548","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"491637377539","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"420605523576","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61411428329","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6282339888398","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"34637014870","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"46793506370","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281337043020","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"16043061562","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"8613268333445","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"971563388100","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61449902122","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"447887294420","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"6281110505500","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"380967593134","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"61456658289","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"61457889902","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31625043592","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31651252656","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"31619422073","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"971585014779","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"971561853856","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4917656769029","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"421904433424","reason":"recent_outbound_whatsapp_message","rows":1},{"target":"4917655185656","reason":"recent_outbound_whatsapp_message","rows":2},{"target":"6584980377","reason":"recent_outbound_whatsapp_message","rows":0},{"target":"4915254532983","reason":"recent_outbound_whatsapp_message","rows":1}],"upsert":{"inserted":0,"updated":0,"unchanged":1427,"skipped":0,"duplicateInputRows":0,"rows":1427}}},"hourly-blood-draw":{"runId":"hourly-blood-draw:2026-09-24T15:10:16.053Z","status":"success","businessDate":"2026-09-24","startedAt":"2026-09-24T15:10:16.053Z","finishedAt":"2026-09-24T15:11:28.856Z","metrics":{"rawRows":{"report9":1219,"report7":23,"report330":943},"derivedRows":{"bloodDrawBookings":20,"pwpConsultationBookings":6,"miniPwpExposures":104,"currentMemberships":943},"upserts":{"bloodDrawBookings":{"inserted":0,"updated":0,"unchanged":20,"skipped":0,"duplicateInputRows":0,"rows":20},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0},"miniPwpExposures":{"inserted":0,"updated":0,"unchanged":104,"skipped":0,"duplicateInputRows":0,"rows":104},"currentMemberships":{"inserted":0,"updated":0,"unchanged":943,"skipped":0,"duplicateInputRows":0,"rows":943}},"signalRun":{"enabled":true,"success":true,"result":{"duration":33316,"engineResult":{"date":"2026-09-24","nowIso":"2026-09-24T12:00:00+08:00","stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":943,"report7_cancellations":23,"report9_bookings":1219},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"sequencesCreated":0,"success":true}}}}},"frontHouseGatekeeperProbe":{"ok":true,"mode":"shadow_probe","endpointPath":"/front-house/gatekeeper-event/probe","configured":true,"writesAlerts":false,"report361StillPrimary":true,"totalCount":0,"acceptedCount":0,"skippedCount":0,"cacheTtlMs":10000,"generatedAt":"2026-09-24T16:43:49.066Z"},"classAnalyticsDb":{"source":"postgres","healthy":true,"configured":true,"attendanceCount":56204,"occurrenceCount":5516,"membershipBookingFactCount":56204,"memberCancellationCount":15603,"coveredDateCount":784,"coveredStartDate":"2024-08-03","coveredEndDate":"2026-09-25","cancellationCoveredEndDate":"2026-09-25","memberCancellationCoveredEndDate":"2026-09-25","updatedAt":"2026-09-24 16:02:10.802+00"},"durableStatus":{"ok":true,"generatedAt":"2026-09-24T16:43:49.065Z","cacheTtlMs":60000,"source":"convex","recentRuns":[{"runId":"messaging-campaign-opt-out-review:2026-09-24T16:13:23.553Z","jobType":"messaging-campaign-opt-out-review","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:13:23.553Z","finishedAt":"2026-09-24T16:13:49.888Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"daily-analytics:2026-09-24T16:01:56.047Z","jobType":"daily-analytics","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:56.047Z","finishedAt":"2026-09-24T16:02:12.053Z","error":null,"rawRows":{"report312_classAttendances":1638,"report341_classSummary":164,"report347_staffList":50,"report351_classBookingsByMember":12670},"derivedRows":{"cancellationReportNotReadyDates":[],"cancellationReportReadyDates":14,"classOccurrenceSummaries":164,"memberAttendances":1623,"memberCancellations":372,"membershipBookingFacts":1623},"upserts":{"classOccurrenceSummaries":{"reason":"postgres_authoritative","skipped":true},"memberAttendances":{"reason":"postgres_authoritative","skipped":true}},"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"campaign-daily-counts:2026-09-24T16:01:49.286Z","jobType":"campaign-daily-counts","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:49.286Z","finishedAt":"2026-09-24T16:01:51.585Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"mini-pwp-tracker-reconcile:2026-09-24T16:01:45.251Z","jobType":"mini-pwp-tracker-reconcile","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:45.251Z","finishedAt":"2026-09-24T16:01:48.982Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T15:10:16.053Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T15:10:16.053Z","finishedAt":"2026-09-24T15:11:28.856Z","error":null,"rawRows":{"report330":943,"report7":23,"report9":1219},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":943,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":0,"rows":943,"skipped":0,"unchanged":943,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":943,"report7_cancellations":23,"report9_bookings":1219},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T14:10:16.039Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T14:10:16.039Z","finishedAt":"2026-09-24T14:11:29.965Z","error":null,"rawRows":{"report330":943,"report7":23,"report9":1212},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":943,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":0,"rows":943,"skipped":0,"unchanged":943,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":943,"report7_cancellations":23,"report9_bookings":1212},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T13:10:16.022Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T13:10:16.022Z","finishedAt":"2026-09-24T13:11:22.171Z","error":null,"rawRows":{"report330":943,"report7":23,"report9":1207},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":943,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":1,"rows":943,"skipped":0,"unchanged":942,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":943,"report7_cancellations":23,"report9_bookings":1207},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T12:10:16.003Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T12:10:16.003Z","finishedAt":"2026-09-24T12:11:24.992Z","error":null,"rawRows":{"report330":942,"report7":23,"report9":1205},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":942,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":0,"rows":942,"skipped":0,"unchanged":942,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":942,"report7_cancellations":23,"report9_bookings":1205},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T11:10:15.986Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T11:10:15.986Z","finishedAt":"2026-09-24T11:11:20.465Z","error":null,"rawRows":{"report330":942,"report7":23,"report9":1201},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":942,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":2,"rows":942,"skipped":0,"unchanged":940,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":942,"report7_cancellations":23,"report9_bookings":1201},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T10:10:15.969Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T10:10:15.969Z","finishedAt":"2026-09-24T10:11:22.788Z","error":null,"rawRows":{"report330":940,"report7":23,"report9":1194},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":940,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":1,"rows":940,"skipped":0,"unchanged":939,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":1,"rows":104,"skipped":0,"unchanged":102,"updated":1},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":940,"report7_cancellations":23,"report9_bookings":1194},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T09:10:15.950Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T09:10:15.950Z","finishedAt":"2026-09-24T09:11:20.814Z","error":null,"rawRows":{"report330":939,"report7":22,"report9":1182},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":939,"miniPwpExposures":103,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":1,"rows":939,"skipped":0,"unchanged":938,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":103,"skipped":0,"unchanged":103,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":939,"report7_cancellations":22,"report9_bookings":1182},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"hourly-blood-draw:2026-09-24T08:10:15.933Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T08:10:15.933Z","finishedAt":"2026-09-24T08:11:22.094Z","error":null,"rawRows":{"report330":939,"report7":21,"report9":1173},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":939,"miniPwpExposures":103,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":0,"rows":939,"skipped":0,"unchanged":939,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":103,"skipped":0,"unchanged":103,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":939,"report7_cancellations":21,"report9_bookings":1173},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"messaging-campaign-opt-out-review:2026-09-24T07:47:40.163Z","jobType":"messaging-campaign-opt-out-review","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:47:40.163Z","finishedAt":"2026-09-24T07:48:06.211Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"daily-analytics:2026-09-24T07:47:27.031Z","jobType":"daily-analytics","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:47:27.031Z","finishedAt":"2026-09-24T07:47:39.495Z","error":null,"rawRows":{"report312_classAttendances":1634,"report341_classSummary":164,"report347_staffList":50,"report351_classBookingsByMember":12679},"derivedRows":{"cancellationReportNotReadyDates":[],"cancellationReportReadyDates":14,"classOccurrenceSummaries":164,"memberAttendances":1616,"memberCancellations":385,"membershipBookingFacts":1616},"upserts":{"classOccurrenceSummaries":{"reason":"postgres_authoritative","skipped":true},"memberAttendances":{"reason":"postgres_authoritative","skipped":true}},"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"campaign-daily-counts:2026-09-24T07:47:21.395Z","jobType":"campaign-daily-counts","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:47:21.395Z","finishedAt":"2026-09-24T07:47:23.699Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"mini-pwp-tracker-reconcile:2026-09-24T07:47:18.362Z","jobType":"mini-pwp-tracker-reconcile","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:47:18.362Z","finishedAt":"2026-09-24T07:47:21.113Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"messaging-campaign-opt-out-review:2026-09-24T07:21:15.081Z","jobType":"messaging-campaign-opt-out-review","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:21:15.081Z","finishedAt":"2026-09-24T07:21:46.004Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"daily-analytics:2026-09-24T07:21:01.642Z","jobType":"daily-analytics","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:21:01.642Z","finishedAt":"2026-09-24T07:21:14.439Z","error":null,"rawRows":{"report312_classAttendances":1633,"report341_classSummary":164,"report347_staffList":50,"report351_classBookingsByMember":12679},"derivedRows":{"cancellationReportNotReadyDates":[],"cancellationReportReadyDates":14,"classOccurrenceSummaries":164,"memberAttendances":1615,"memberCancellations":385,"membershipBookingFacts":1615},"upserts":{"classOccurrenceSummaries":{"reason":"postgres_authoritative","skipped":true},"memberAttendances":{"reason":"postgres_authoritative","skipped":true}},"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"campaign-daily-counts:2026-09-24T07:20:56.706Z","jobType":"campaign-daily-counts","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:20:56.706Z","finishedAt":"2026-09-24T07:20:58.677Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},{"runId":"mini-pwp-tracker-reconcile:2026-09-24T07:20:53.227Z","jobType":"mini-pwp-tracker-reconcile","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T07:20:53.227Z","finishedAt":"2026-09-24T07:20:56.394Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"}],"latestRunsByType":{"messaging-campaign-opt-out-review":{"runId":"messaging-campaign-opt-out-review:2026-09-24T16:13:23.553Z","jobType":"messaging-campaign-opt-out-review","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:13:23.553Z","finishedAt":"2026-09-24T16:13:49.888Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},"daily-analytics":{"runId":"daily-analytics:2026-09-24T16:01:56.047Z","jobType":"daily-analytics","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:56.047Z","finishedAt":"2026-09-24T16:02:12.053Z","error":null,"rawRows":{"report312_classAttendances":1638,"report341_classSummary":164,"report347_staffList":50,"report351_classBookingsByMember":12670},"derivedRows":{"cancellationReportNotReadyDates":[],"cancellationReportReadyDates":14,"classOccurrenceSummaries":164,"memberAttendances":1623,"memberCancellations":372,"membershipBookingFacts":1623},"upserts":{"classOccurrenceSummaries":{"reason":"postgres_authoritative","skipped":true},"memberAttendances":{"reason":"postgres_authoritative","skipped":true}},"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},"campaign-daily-counts":{"runId":"campaign-daily-counts:2026-09-24T16:01:49.286Z","jobType":"campaign-daily-counts","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:49.286Z","finishedAt":"2026-09-24T16:01:51.585Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},"mini-pwp-tracker-reconcile":{"runId":"mini-pwp-tracker-reconcile:2026-09-24T16:01:45.251Z","jobType":"mini-pwp-tracker-reconcile","businessDate":"2026-09-25","status":"success","startedAt":"2026-09-24T16:01:45.251Z","finishedAt":"2026-09-24T16:01:48.982Z","error":null,"rawRows":null,"derivedRows":null,"upserts":null,"signalRun":null,"coverage":null,"source":"convex:gymMasterIngestRuns"},"hourly-blood-draw":{"runId":"hourly-blood-draw:2026-09-24T15:10:16.053Z","jobType":"hourly-blood-draw","businessDate":"2026-09-24","status":"success","startedAt":"2026-09-24T15:10:16.053Z","finishedAt":"2026-09-24T15:11:28.856Z","error":null,"rawRows":{"report330":943,"report7":23,"report9":1219},"derivedRows":{"bloodDrawBookings":20,"currentMemberships":943,"miniPwpExposures":104,"pwpConsultationBookings":6},"upserts":{"bloodDrawBookings":{"duplicateInputRows":0,"inserted":0,"rows":20,"skipped":0,"unchanged":20,"updated":0},"currentMemberships":{"duplicateInputRows":0,"inserted":0,"rows":943,"skipped":0,"unchanged":943,"updated":0},"miniPwpExposures":{"duplicateInputRows":0,"inserted":0,"rows":104,"skipped":0,"unchanged":104,"updated":0},"pwpConsultationBookings":{"deleted":6,"inserted":6,"unchanged":0,"updated":0}},"signalRun":{"enabled":true,"success":true,"skipped":false,"error":null,"sequencesCreated":0,"stats":{"countsByType":{"blood_draw_48h":0,"blood_draw_booked":0,"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"dataSource":"zeabur","exactScheduledByType":{"blood_draw_completed":0,"blood_draw_no_show":0,"pwp_consultation_24h":0},"insertedByType":{},"reportCounts":{"reconciledBookings":26,"report330":943,"report7_cancellations":23,"report9_bookings":1219},"signalCandidates":0,"signalsInserted":0,"signalsSkipped":0,"skippedByType":{}}},"coverage":null,"source":"convex:gymMasterIngestRuns"}},"staleRunningRuns":[],"warningCount":0,"revenueFreshness":{"source":"postgres","configured":true,"sourceFactCount":1280443,"rowCount":32036,"coverageStartDate":"2024-01-26","coverageEndDate":"2026-09-25","coverageCount":398,"legacyArchive":[{"sourceTable":"revenueConversionFacts","count":331,"startDate":"2025-12-16","endDate":"2026-07-29"},{"sourceTable":"revenueManagementRows","count":29909,"startDate":"2025-01-01","endDate":"2026-07-31"}]},"memberVisitCoverage":{"countsByDate":{"2026-09-18":1030,"2026-09-19":717,"2026-09-20":716,"2026-09-21":1281,"2026-09-22":1228,"2026-09-23":1178},"distinctVisitDates":6,"duplicateExactKeys":0,"endDate":"2026-09-25","maxVisitDate":"2026-09-23","minVisitDate":"2026-09-18","missingVisitKey":0,"rowCount":6150,"startDate":"2026-09-18"}}}