Пікірлер
@MThoufik 4 күн бұрын
Sir please share this excel sheet sir ❤
@rivella5 6 күн бұрын
This is very useful, thank you so much! Would you be able to share the code by any chance?
@kisholoymukherjee 2 күн бұрын
Sure, please get in touch with me here www.linkedin.com/in/kishalaya-mukhopadhyay17/
@Inambehindthecam 8 күн бұрын
Hello, sir can you please add the code in description or in reply here? Thanks!
@scuffedguitartabs 9 күн бұрын
I don't understand. Shouldn't the optimal ROAS be calculated based on 1) conversions per cpc. If additional conversions rise significantly compared to cpc, then we have a new sweetspot. And 2) RPL - CPA, which can be calculated based on that cpc. This sweetspot is dynamic and will change based on competition & search volume To me, it doesnt make sense to model optimal roas with ad spent. Ad spent will vary even though cpc/sis remain the same, due to search volume and things like this. In your sheet example, who is to say that your period data isn't heavily influenced by external factors?
@kisholoymukherjee 9 күн бұрын
I think you are confusing between optimal ROAS, which I believe is breakeven ROAS. The current approach talks about incremental ROAS, the point at which profit is maximized. This is NOT a ROAS vs ad spend model by any means. It simply helps give direction for increasing/reducing ad spend on the basis of a metric that involves percentage changes. There is a HUGE difference between absolute values you seem to be referring to and % differences. Think marginal. Now that the "model" definition is clear, I would say it makes sense to do this because it is based on d(profits) (ROAS is profit/ad spend in this case) on one hand, which is a proxy for incrementality, and d(ad spend), which is a proxy for a lot of intermediate metrics but particularly cpc and impression share. As for external factors, they are ALWAYS there aren't they? If you really want to factor in unpredictable external influences, you can consider including an error term but that would complicate the calculations.
@scuffedguitartabs 9 күн бұрын
@@kisholoymukherjee Why do you believe optimal ROAS is breakeven ROAS? To me, optimal ROAS is the target where you net the most profit. Moreover, I don't necessarily agree with using ad spend, as opposed to CPC and SIS. You would always want to factor in these external factors, to make the model as accurate as possible. Or, at the bare minimum, to explain what's happening. I don't think it's as easy as taking period 1 with ROAS to ad spend, period 2, period 3, etc. But rather, finding correlation between CPC and conversions, and finding a 'sweet spot' where net profit is the highest (when competition remains the same)
@kisholoymukherjee 9 күн бұрын
@@scuffedguitartabs Can you please share how you propose to use only CPC and SIS? Because I can't see how that is practical. The idea is to arrive at something actionable. What specific action can you take? Perhaps change bid strategies, but certainly change budgets right? And I am not sure I am getting the idea of "External factors"? How do you propose to handle external factors any better when using cpc and SIS? Do you have any formula or document or anything so that I can better understand your argument / alternative proposal?
@saadsiddiqui4930 19 күн бұрын
Smjh nhi aya sir
@wabimasabi 20 күн бұрын
What happens when you are looking at different channel? Do you use the F-statistic, then compare each channel incrementality versus the total to get, which channels are high and low performers?
@PrathameshBhosale268 27 күн бұрын
Waiting to complete this one. Just started.
@shubhamprasad1200 27 күн бұрын
Great Explaination!
@kisholoymukherjee 21 күн бұрын
glad you liked it
@PrathameshBhosale268 Ай бұрын
Something new.. good but will have to watch a couple of times
@tanuj.mp4 Ай бұрын
Genuis!
@PrathameshBhosale268 Ай бұрын
Lovely video sir... Thank you so much
@kisholoymukherjee Ай бұрын
Glad you found it useful
@siddharthakar9369 2 ай бұрын
not so clear at 17:00
@kisholoymukherjee Ай бұрын
In that part, I was referring to the values of the Linest output and said that I wasn't going deep into what each of those meant, because that would have taken a long time to explain in this video.
@UbedfromTagembed 2 ай бұрын
Share the scripts links too.... it will be better and easy to implement
@PrathameshBhosale268 2 ай бұрын
best hai
@PrathameshBhosale268 2 ай бұрын
Love it bro. You're literally saving my career
@kisholoymukherjee 2 ай бұрын
😇
@MThoufik 2 ай бұрын
It's very useful thank you so much❤
@kisholoymukherjee 2 ай бұрын
glad you liked it
@AmitRoyScorpio 3 ай бұрын
Can you share the excel sheet, Kisholay?
@khaledmokhtar1 3 ай бұрын
template ؟
@kisholoymukherjee 3 ай бұрын
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
@MThoufik 3 ай бұрын
Please share the excel sheet in your description
@kisholoymukherjee 3 ай бұрын
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
@seunolanrewaju9188 3 ай бұрын
Can you send your excel sheet to serve as a template?
@kisholoymukherjee 3 ай бұрын
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
@shopifythemesolutions.9190 3 ай бұрын
How do you convert {% if first_time_accessed %} into Customer Events to ensure we are not getting duplicate parameters?
@魏杰-c4z 3 ай бұрын
太厉害了
@stu-ep6361 3 ай бұрын
Amazing stuff man! Love it !! Give me that code brother !
@kisholoymukherjee 3 ай бұрын
Sure, pls get in touch with me on my LinkedIn profile www.linkedin.com/in/kishalaya-mukhopadhyay17/
@erithnuerithnu3219 4 ай бұрын
I think the original version is by Martin Röttgerding at Bloofusion, right?
@kisholoymukherjee 4 ай бұрын
That's a Google Ads Script. This is just Google Sheets
@kisholoymukherjee 4 ай бұрын
also the purpose of this video is to teach people to build one by themselves, not just share a template. That of course is being shared by several others. Martin's work is superb
@C60MD-pl5ys 4 ай бұрын
Thanks for sharing. Where's the code link
@QuintvanderMeer-r9x 4 ай бұрын
Thanks for sharing! If I can give you some suggestions to optimize yout next video. Make annotations in the video, so people can easily see where they have to go for which part. Also, I think it's even better if you literally set it up and explaining why or how you do it. Now everything is already filled in, which makes it a little harder to understand. But thanks helped me out!
@kisholoymukherjee 4 ай бұрын
Thanks Quint, yes I agree with your suggestions, still early days in my KZbin journey, hopefully will get better over time. As for the literal set up, that is actually because of some apprehensions regarding accidentally revealing brand names, as I am not supposed to (yet anyway). I know there are ways to blur or smartly edit but I haven't had the time yet. I know I must optimize more. Thanks again for watching and your valuable feedback. Really glad it helped you!
@subhandar1206 4 ай бұрын
can you share the URL of the video you talked about (GA4 server side)
@yashganjoor9397 4 ай бұрын
Superb! Can you share the template?
@kisholoymukherjee 4 ай бұрын
Thank you, sure, Here it is : topmate.io/kisholoy_mukherjee/1026070
@yashganjoor9397 4 ай бұрын
@@kisholoymukherjee thank you so much!!
@stu-ep6361 4 ай бұрын
Thanks !!
@varunkonathala1044 5 ай бұрын
I didn't get the final result of this, like, if you could tell the problem statement that we are solving with this analysis is being solved finally - It would have more clear than this.
@kisholoymukherjee 5 ай бұрын
The problem statement is simple - how do you better segment your products so that you can plan your marketing campaigns more efficiently
@javi_digital_zone 5 ай бұрын
amazing work dude! Thanks for sharing
@kisholoymukherjee 5 ай бұрын
Thanks so much
@ClickCraft-rd2io 5 ай бұрын
Hey Kisholoy, Quick question. I went through all the steps, but when I open the tag assistant I get the notification that the Google tag: gtm-xxxx was not found. Do I have to add the GTM tag in the theme file for this?
@kisholoymukherjee 5 ай бұрын
Hi in the video I have discussed how the debug/preview mode does not work when using the Shopify customer events. You can use the Tag Assistant extension or the browser console to verify the tracking
@EuanAdam 5 ай бұрын
Great content! Thanks for simplifying this complicated setup
@kisholoymukherjee 5 ай бұрын
Thank you
@alvise_corba 6 ай бұрын
Super interesting, Thanks for sharing! Keep posting, your channel is full of interesting videos
@kisholoymukherjee 6 ай бұрын
Thank you so much, will surely keep sharing more.