Weekly Updates

Summary

1. MAU increased in August - PL increases after 4 months and Pi3 continues sustained increase
2. Delinquency has been stable
3. Project Alpha - Carinae is leading to good collection
4. Identity Service is deleted

MAU increased in August - PL increases after 4 months and Pi3 continues sustained increase

Let's just focus on MAU for this week's report. Relevant query is

SELECT
   SUBSTR(bucket_id, 6, 7) AS month,
   COUNT(DISTINCT IF(
        product_id = 'a21b31b4-74b8-4a6e-a2a8-28b85d1f8315' 
        AND merchant_name != 'Billbox'
        AND merchant_name != 'Simpl', user_id, NULL)) AS pl_users,
   COUNT(DISTINCT IF(merchant_name = 'Billbox', user_id, NULL)) AS billbox_users,
   COUNT(DISTINCT IF(
        product_id = '541eeb1c-8212-40f7-af04-05990ff00961', 
        user_id, NULL)) AS pi3_users,
   COUNT(DISTINCT user_id) AS total_users
   
FROM
   public.transaction_events
WHERE
   event_name = 'TransactionChargedEvent'
   AND bucket_id BETWEEN 'date_2024_01_01' AND 'date_2025_08_31'
GROUP BY 1
ORDER BY 1

     

PL MAU showed a growth after several months, reaching 5 month high. Still far away from life time max reached in April 2024 (but unit economics is better now). Pi3 MAU has continued sustained increase.

Delinquencies are stable

Here are PL delinquencies (DPD35)

And here is Pi3 collection view of delinquencies (DPD35) - slight degradation in July.

Project Alpha - Carinae is leading to good collection

Collection team is calling their new collection strategies as Alpha - Carinae which I see is another name of Canopus.

Thanks to Sagar, Shivam, Salman, Harshdeep, Abhishek, Taqee - we are moving really fast on canopus collections. Specific focus is on D300+ collections, and I discussed exact approaches in last week update. Following is daily collection graph of canopous. We have colllected 1.13 cr in first six days of September, compared to 1.09 cr in all of August.

Identity service is deleted

Identity service database was deleted last week. Thanks Vinayak for being persistent and everyone else for doing their part - Shivam, Vikas, Akhil, Krishna and anyone else whom I may have missed.

You can view this talk by Sheekha Verma for a trip to history lane. Sheekha was the leader of our DS team around 2 years ago.

Sveltekit migration ramp up

Sveltekit migration has been ramped to 100%. Some merchants are seeing a bit success rates drop, but they are relatively minor and we are trying to debug.

Batch v6.2 ramped up to 100%

Expect slightly lower delinquencies because of this in coming times.

Tracked events migrated to redis

In CRM, there is a concept of "tracked events". Id of a processed event is put in some DB to guard against duplicate processing (I think). Earlier this was in postgres and that table was becoming big. Now we have moved it to redis, and also reduced ttl, and also stopped processing needless elements. Shoan was pointing out that a date partitioned postgres would be better since then large volume of events only degrades performance and does not need an upgrade. Anyway, we have done this, and later Vikas and team the new owners, will take care.

Yatin's last day in office

Last Friday was Yatin's last day in office. He is away to Delhi because of medical emergency in family. We will ask him to come to office once when he is back to Bangalore. We wish Yatin all the best.

Akshay will be managing payments team

Akshay will be managing the payments team from now on. Thanks Akshay for stepping up.

SIKA for direct integraion

Now direct integrations can also be routed to SIKA via an adapter that Prakash/Ayush have written.

Pi3 routing changes

We have implemented in which we route linked SIKA users to orchestrator and non linked SIKA users to split pay service. This is a temporary change till the time we figure out the cause of latency problems in orechestrator.