The Ecomm Analyst

Growing stores, one honest take at a time.

Category: Uncategorized

  • Is it safe to connect your analytics to an AI assistant?

    Reasonably, if you connect through a sign-in flow with read-only access and you understand that your numbers pass through the assistant provider. The risk is not that someone drains your…


  • Can you connect your Shopify data to Claude or ChatGPT?

    Yes, and not by uploading a CSV. Several analytics platforms now publish a connector that lets Claude or ChatGPT query your live commerce data directly. You authorize it once, then…


  • How do you get new-customer CAC without building a spreadsheet?

    You divide ad spend by new customer orders over the same window. That is the whole formula. The reason it turns into a spreadsheet project is that the two numbers…


  • Zigpoll alternatives for post-purchase survey attribution

    Zigpoll is a reasonable place to start with post-purchase surveys. It is quick to install, it handles on-site and exit intent surveys alongside post-purchase, and the free Lite tier gives…


  • Tableau alternatives for e-commerce reporting

    Tableau is a serious analytics platform, and for most stores under $20M that is exactly the problem. It assumes you already have clean, modeled data sitting somewhere and an analyst…


  • What is MER, and how do you calculate it?

    MER stands for marketing efficiency ratio. You calculate it by dividing total revenue by total marketing spend across the same period. If a store did $620,000 in revenue in July…


  • How do you calculate blended CAC?

    Blended CAC is total marketing spend divided by the number of new customers acquired in the same period. Every dollar of marketing goes in the numerator, whether or not any…


  • What is a good CAC for e-commerce?

    There is no universal good CAC for e-commerce. A good CAC is any acquisition cost that sits comfortably below the contribution profit a new customer produces, either on the first…


  • What happens to your numbers when you switch attribution models

    Something I do with every new account, usually in the first week, is take a single month of spend and run it through three attribution models without changing anything else.…


  • Is retargeting ROAS real?

    Mostly not, in the sense operators usually mean. Retargeting ROAS is real in that the orders exist and the revenue is genuine. It is misleading in that most of those…


Navigation

About

Six years in e-commerce. Three Shopify stores across different niches, one scaled past seven figures. I’ve tested hundreds of ad creatives, obsessed over email flows, and learned more from my failures than my wins.

Now I focus on conversion optimization, retention marketing, and the analytics behind it all. This blog is where I share what actually works, backed by real numbers. No fluff, no guru energy.