How to Analyze Your LinkedIn Ads in Excel

Поділитися
Вставка
  • Опубліковано 3 лис 2024

КОМЕНТАРІ • 16

  • @gauravgupta8983
    @gauravgupta8983 7 місяців тому +1

    Hi, I find this extremely informative n useful. Just wanna ask if u have any video as how to do competitor analysis on LinkedIn ads?

  • @gabrielasandoval9133
    @gabrielasandoval9133 8 місяців тому +1

    It's the second time i come to see this video bc i find it really useful, thank you! 😊

    • @AJWilcox
      @AJWilcox 8 місяців тому

      Yes! Love hearing that. So glad!!

  • @shwetachaturvedi890
    @shwetachaturvedi890 2 місяці тому

    Let me start by saying Thanks a lot for your wonderful short tutorials. It has given me confidence in LinkedIn marketing and more. Its 3 years now but I am still looking forward to your videos. I have recently noticed something that I would like to ask.
    In my campaign performance report I see double entries for multiple campaigns. I am not running multiple ads, these are sponsored posts (post boost) so I do not know why I see 2 entries for them. I am looking forward to understand the Ads spend on each post by LinkedIn these 2 entries have different values but the total comes out to be my campaign budget. They why 2 values? Can you explain?

  • @victoriaanneberman3819
    @victoriaanneberman3819 Рік тому +1

    This video is packed full of knowledge! Thank you.

    • @AJWilcox
      @AJWilcox Рік тому

      Awesome Victoria! So glad you got out of it as it was intended :)

  • @wiktoriaborun1665
    @wiktoriaborun1665 6 місяців тому

    Thanks to you I was able to use excel. I cannot thank you enough

    • @AJWilcox
      @AJWilcox 6 місяців тому

      So glad these methods were helpful to you!!!

  • @harshitkhannaproductions1039
    @harshitkhannaproductions1039 Рік тому +2

    Wow man, this is really great!

    • @AJWilcox
      @AJWilcox Рік тому +1

      So glad you loved it!

  • @DanielHarrisCodes
    @DanielHarrisCodes Рік тому +1

    Nice video. Very straightforward. I guess we could pull in from google analytics how many of those clicks converted to a lead and from our internal tracking how many leads converted to a customer

    • @AJWilcox
      @AJWilcox Рік тому

      Thanks Daniel, and YES! This video shows you how to do that with CRM data: ua-cam.com/video/zhVdEYDcLsM/v-deo.html
      Similar principle with GA data if you're using utm parameters well.

  • @raghavendradeepakdupugunta4241
    @raghavendradeepakdupugunta4241 5 місяців тому

    informative.

  • @saramartinezmontero902
    @saramartinezmontero902 6 місяців тому +1

    How to add the conversion to the pivot table?

    • @AJWilcox
      @AJWilcox 6 місяців тому

      I pull the conversions fields into the Values section of the pivot table and it will add them. There's click through conversions, view through conversions, and then both of those add together to give you your "Conversions" column in LinkedIn's data. I tend to only pay attention to click-through conversions, so I bring in only that column, and then do my calculations based on that.

    • @saramartinezmontero902
      @saramartinezmontero902 6 місяців тому

      @@AJWilcox Thank you very much. I´ll try to do it. it would be nice, if you could do a video on that. I struggle a bit with the metrics. I learn a lot with your videos. Also, I mixed up lead and conversions