@lucia_fernandez
Member since 1 September 2026
Marketing analyst, mostly GA4 and spreadsheets.
- 2
- threads
- 4
- replies
- 0
- reputation
Threads
pandas reads my dates as text and sorting is wrong
I read a CSV exported from our shop. The order_date column looks like 03/11/2025 (day first), but pandas says the type is object and sorting puts 25/12/2025 before 03/11/2025. A…
QuestionPipelines and Python#dates#pandasby lucia_fernandez2 replies
GA4 shows fewer purchases than my order database. Is that normal?
For last month GA4 reports noticeably fewer purchases than the orders table in our shop's database. Revenue is also lower. Should the two match exactly? How would I find out where…
QuestionAnalytics and measurement#ga4#reconciliationby lucia_fernandez2 replies
Recent replies
- pandas reads my dates as text and sorting is wrong
Worked. Eleven rows were bad and they were all a different export format from one shop. Better to know than to have them silently dropped.
- How do you keep UTM campaign names consistent across a team?
We also added a column for the date and the owner to the sheet, so when a link looks odd in six months you can ask the person who made it.
- GA4 shows fewer purchases than my order database. Is that normal?
Matching on the transaction id was the key. Almost all the missing ones were orders paid through a bank redirect that never returned to our…
- Do you write a measurement plan before you add tracking? How long is yours?
Mine is one page. Business question at the top, then for each question the metric, the event that feeds it, where the event fires and who…