All posts

Analytics

3 posts on Analytics

The customer identifier: why it has to be the email

One buyer turns into three in the report. Not because the database has duplicates, but because the query groups people by fields they fill in differently every time.

THREE ORDERS FROM ONE PERSON EMAIL NAME PHONE ivan@mail.com Ivan +380 67 123 45 67 ivan@mail.com ivan 0671234567 Ivan@Mail.com Ivan P. +38 067 123 45 67 lower() GROUP BY LOWER(email) 1 customer a new combination every time 3 “customers”

Subscriber growth: why the obvious count overstates it

You compare list sizes at the start and the end of the month and see growth. In fact half of those people were with you last year — they were simply moved into a different list.

An ad dashboard in Google Sheets: when it stops working

Pulling three ad accounts into one spreadsheet is the obvious answer, and it works right up until the data gets big. After that it breaks the same way every time.

If you are looking at something similar

Describe your situation

Tell us which process eats the most time. We will write back with what can be automated and roughly what it would cost.

Discuss a project