Posted on Oct 5, 2020
I was working on porting this query today from Storat UAE to US system. It’s 98 lines of code. I wrote it 7 months ago to help automate CAC calculation for our marketplace at the buyers' side. Looking at it now my thought was “Shit, this is complex, I wrote that????”. As I am **officially** a non-technical founder, I decided to write a story about how I became a programmer again. I didn’t write any code since my first job in Microsoft which was more than 20 years ago.
When you are working in B2B2C (like a service marketplace) the algorithm can become complex. It becomes tricky when 60% of buyers opt to call or chat and the order is placed indirectly through the call center. It is not rocket science, but I wanted to come up with an automated way to track CAC, marketing spends, revenue, and profitability. Also, I wanted to determine those factors at top categories and child categories level where we can slice and dice the data easily in excel. Attached also are two frontend systems that are built on those queries so my team in the Middle East can look quickly at those KPIs without wasting time on gathering data again.
Please sign up at https://app.oryxcloud.com/registe... and tell us what do you think!