Marketing Dashboard Tutorial: How to Analyze and Track Marketing Performance

Sdílet
Vložit
  • čas přidán 19. 07. 2022
  • We build a growth marketing dashboard to help us attribute performance & analyze the most important marketing KPIs. Discussion & template included!
    ✅ Download the Excel template: www.ericandrewsstartups.com/o...
    🚀 If you want to master the finance skills & frameworks to successfully scale technology startups, secure your spot in my "Finance for Startups" program, today: www.ericandrewsstartups.com/f...
    Communities:
    💼 Linkedin: / eric-andrews-1624b656
    ☑️ Twitter/X: / eric__andrews
    🌟 Instagram: / ericandrews_startups
    🔥 Discord: bit.ly/discord_eric
    💻 Newsletter: bit.ly/joinericnewsletter
    🎥 Clips: / @ericandrewsclips7818
    Related Startup Videos:
    🚩 Unit Economics Explanation: • Unit Economics for Sta...
    🚩 How VCs Calculate Customer Retention & LTV: • Customer Retention & C...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    In this video, we will build a digital marketing dashboard that you could use for a weekly growth marketing meeting to attribute (identify the drivers) revenue changes to your different campaigns.
    We focus on the different marketing KPIs across the full funnel - top, middle and bottom - and analyze the results of many different experiments we ran.
    We will cover all of this using real life examples and discussions.
    SECTIONS:
    0:18 what this marketing dashboard covers & marketing funnel
    2:02 building the high-level full year revenue / spend tracking
    3:30 breaking down the most important marketing metrics MTD
    9:55 interpreting the results of all our marketing activities (funnel breakdown)
    28:35 analyzing drivers behind new vs. returning revenue
    30:07 breaking down paid marketing performance by channel in post-iOS14 world (simple explanation)
    By the end of this video, you will understand how to build a growth marketing dashboard and try to attribute your performance to different campaigns.
    #digitalmarketingKPIs #startups #marketingperformance

Komentáře • 40

  • @eric_andrews
    @eric_andrews  Před rokem +1

    Questions? Let me know in the comments happy to discuss.
    💡 Also, if you want to learn how to systematically scale your startup without ending up as one of the 90% of startups that fail, check out my free training webinar ⇒ www.ericandrewsstartups.com/financeforstartups

  • @kopcurry
    @kopcurry Před 2 lety +9

    Hey Eric, I found your channel a few weeks ago when I joined my first job in a startup in a business role. This channel has really helped me alot to expand my knowledge across business functions. What I really like is you do it hands on and not just talk about stuff which one should do. It is really an underrated channel for startup folks. Thank you for this.

    • @eric_andrews
      @eric_andrews  Před 2 lety +1

      That means a lot to me! You are very welcome and good luck with your new role

  • @anjawsm
    @anjawsm Před 2 lety +3

    My job as a digital marketer (all rounder) sometimes makes me confused about what to do especially performance marketer.
    Idk how your channel come into my home, and it's helped me a lot!
    Please continue to make this typical content, Eric!

  • @abdullah_shaikh95
    @abdullah_shaikh95 Před rokem +2

    Hey Eric You are a genius the performance marketing playlist that you have provided is gold mine. Please keep making more of it It will help us in our job as a performance marketer

    • @eric_andrews
      @eric_andrews  Před rokem +1

      I'm so glad to hear it, I'll keep making more marketing content!

  • @bdofficial3951
    @bdofficial3951 Před 3 měsíci

    you are such a great teacher. thanks

  • @dileepamadusanka5691
    @dileepamadusanka5691 Před rokem

    Hi Eric ,This was really help full since am a student of Digital Marketing an doing my assignments this guid really means to me Tks 🙏

  • @sonerguney3225
    @sonerguney3225 Před 11 měsíci

    Teşekkürler Eric. Çok beğendim. Devam et.❤

  • @sivamokkala
    @sivamokkala Před 3 měsíci

    Really helpful video. Thank you so much

  • @tanhoang5432
    @tanhoang5432 Před měsícem

    One of my friend did recommend me your channel, and this video is the one that make me sub your channel and will try hard for every videos you have. you have awsome works here!!

    • @eric_andrews
      @eric_andrews  Před měsícem

      I appreciate that. Welcome and hope you learn a ton!

  • @sedabakin6240
    @sedabakin6240 Před rokem

    This is very helpful Eric, thanks!

  • @shittumubaraq8540
    @shittumubaraq8540 Před 2 lety

    Hi Eric, I came across your channel few minutes ago and I must say you're doing so much to help marketers.
    Thank you so much.

    • @eric_andrews
      @eric_andrews  Před 2 lety +1

      My pleasure appreciate the comment 👍

    • @shittumubaraq8540
      @shittumubaraq8540 Před 2 lety

      @@eric_andrews ☺️
      A quick one Eric, could you please guide on how to secure an entry role on performance and marketing manager.
      On how to create a resumé and CV.
      I look forward to your response.
      Thank you

  • @mohammedromanshaikh8025
    @mohammedromanshaikh8025 Před 2 lety +1

    Hi Eric, just want to say Can u build a Startup Financial Model for EV ( Electric vehicle) co and Renewable Energy co for Solar may be, because this kind of startups will be dominant in future

  • @marwandeeb6416
    @marwandeeb6416 Před rokem

    Eric thanx for your special and great content, i just want to ask you if you have a special paid courses, marketing consultant or what are the best resource i can check it to learn more about it

    • @eric_andrews
      @eric_andrews  Před rokem

      You are very welcome thanks for the kind words! At this time my only paid program is focused on finance for startups (although we do have a lot of marketers that join specifically to understand more about unit economics, LTV, CAC, growth)...feel free to take a look at the info page if that sounds interesting www.ericandrewsstartups.com/finance-for-startups-info

  • @sarahbrereton6042
    @sarahbrereton6042 Před rokem

    this is great. what platforms are you using to track and attribute performance outside of GA?

    • @eric_andrews
      @eric_andrews  Před rokem

      Elevar is good, and FB ads attribution seems like be slightly improving as well.

  • @louiesumalinog7542
    @louiesumalinog7542 Před 8 měsíci

    Hi Eric 👋 For the spend goal, do you have threshold to protect the unit economics?
    Example: 30% max for Marketing Spend, Fulfillment 10%, COGS, 30%, etc.

    • @eric_andrews
      @eric_andrews  Před 6 měsíci

      Yes that's exactly how you should be thinking about it except the target should be a CAC not a % of revenue! If you were going to do the full analysis, the CAC should be set based on your LTV. The thing is your LTV can change quite a lot over time depending on if your margins change, you implement new recurring revenue streams (like subscriptions), expand AOV, etc. So CAC is honestly a better place to set the targets of a business than the % of revenue.
      That said, that is in a perfect world. A lot of times the best you'll get is a flat $X amount or a % of revenue if you are a marketer!

  • @drbabasahebambedkar150

    Hi Eric, Can you share this Excel? It is so helpful

  • @trieutran1621
    @trieutran1621 Před rokem

    Could you please send me your template?

    • @eric_andrews
      @eric_andrews  Před rokem

      It's right there available for free download in the description 👍

  • @BlesseDana
    @BlesseDana Před rokem

    Hi. I'm not receiving the file by email

    • @eric_andrews
      @eric_andrews  Před rokem

      Hi, sometimes there is a 5 minute delay, but you will receive it!

    • @BlesseDana
      @BlesseDana Před rokem

      @@eric_andrews Thanks Eric. I got it. It was under All Mail

    • @eric_andrews
      @eric_andrews  Před rokem

      @@BlesseDana ok great!

  • @YasinNabi
    @YasinNabi Před rokem

    "Formal education will make you a living; self-education will make you a fortune." - Jim Rohn, This quote helped me to grow and hope it helps you too, a fellow creator,,