- 25
- 4 219
Marketing Analytics With Kisholoy
India
Registrace 3. 08. 2010
I share videos on marketing analytics and performance marketing. I want to help marketers by bridging the gap between advanced data analysis and marketing objectives.
How Agencies Can Predict Customer Churn | Framework for Founders & CMOs
I have created a step by step tutorial on the exact framework that I have used to predict agency client churn and ensure that I allocate resources more effectively.
Get in touch with me for the code and template:
www.linkedin.com/in/kishalaya-mukhopadhyay17/
Get in touch with me for the code and template:
www.linkedin.com/in/kishalaya-mukhopadhyay17/
zhlédnutí: 62
Video
How Many Creatives Should You Test Per Month on Meta? | Step By Step Framework
zhlédnutí 398Před 19 hodinami
In this video, I explain how you can create your own Meta Ads creative testing frequency calculator. There is basic math and some stat involved, but nothing that you cannot follow. Knowing how many creatives you should be testing per month will help you scale profitably. Don't leave creative testing to guesswork - use a mathematically sound approach and see the difference for yourself.
Find Your Next Winning Product Using Gower Distance | Advanced Product Segmentation
zhlédnutí 114Před dnem
How well you segment your products can go a long way in determining the performance of your marketing channels. For a beauty brand that we recently worked with at our agency, we used Gower Distance - a similarity score that helped us identify the next winning products based on their similarity to winning products with respect to certain features like product type, price band, seasonality elemen...
How to Scrape Websites for Free Using Python | Low-code & Free Scraping Technique
zhlédnutí 136Před 14 dny
Learn how to create your own web scraping system using Python code. You can scrape any website for free using this method and use the data/information extracted for data analysis or SEO or anything related to digital and performance marketing. There are plenty of web scraping tools out there but most of them do not have a free plan and if they do, they usually are free for a trial period. Using...
How to Make a Marketing Mix Model (MLR) Web App Using Streamlit
zhlédnutí 61Před 14 dny
Learn how to make use of Streamlit to make your own web-based data app that runs a multilinear regression model in a stepwise manner to carry out marketing mix modeling and gives you clear indications as to which channel you should spend more in so as to maximize your gross sales. The dataset can be uploaded by the user in the app interface that can run on any browser. Get in touch with me on L...
How to Use Streamlit for Creating Powerful Web Apps for Data Analysis
zhlédnutí 106Před 21 dnem
Streamlit is a Python-based framework for carrying out data analysis and visualizations using web applications. In this video, I show you how to get started with using Streamlit in Google Colab, which is a free online platform for writing Python code. The examples I use are that of a Quality Score Dashboard and handy campaign KPI dashboard, but in future videos, I will show more powerful applic...
How to Create a Dashboard for Quality Score Analysis in Google Sheets | Step by Step Tutorial
zhlédnutí 139Před měsícem
Watch me create a neat little Quality Score analysis dashboard in Google Sheets from scratch. Learn how to use aggregations using drop down menus, HLookups and Sumproducts and arrive at valuable analyses that can help take critical optimization decisions. A must for Performance Marketers working on Google Ads accounts with significant number of keywords and search campaigns. Here's the link to ...
Shopping Budget Depletion Looker Studio Report | Budget Pacing Tool
zhlédnutí 176Před měsícem
In this short video, I walk you through a neat little tool on Looker Studio that will help you greatly when it comes to pacing your Shopping and Performance Max campaigns' budgets. This is a free tool from Google, the link to which was shared with me by a Google Rep. It gives you the opportunity to view budget depletion by day, hour and week. Here is the report link: lookerstudio.google.com/rep...
Data Blending in Looker Studio from Multiple Google Sheets | How to Use Join Operator
zhlédnutí 100Před měsícem
Learn the use of the Data Blending process that will help combine and manipulate data from multiple sources. While you can use any third party tool like Supermetrics, for the purposes of this video, I have used the example of Google Sheets. I have also shown how to create calculated metrics and the potential problem you will face when summary rows get created. The use of different join operator...
How to Create Optimal Discounting Strategy Using Product Bundles
zhlédnutí 101Před měsícem
If you are into ecommerce or if you run ads for ecommerce businesses, you need to take your discounting strategy very seriously. What the optimal discount should be depends on a number of factors, including seasonality, AOV, past purchase behavior and last but not the least, the perceived value of the products in the mind of the consumer. In this video, I will walk you through a discounting tem...
Google Ads Conversion Tracking (Ecommerce Events) Using Server-Side Google Tag Manager Container
zhlédnutí 271Před měsícem
In this video, I show the exact step-by-step process of setting up server-side Google Ads conversion tracking for ecommerce events using Google Tag Manager. I show how you can use Stape domain as the tagging server URL. I have shown how you can start using Stape server even if you had initially opted for Automatic provisioning of Tagging Server URL (i.e. through Google Cloud). This is a practic...
Incrementality Lift Template - Multi-Channel/Multi-Linear Regression Version
zhlédnutí 172Před měsícem
In this video, I quick explain how you can use the incrementality/lift test template to check the combined effect of multiple variables, i.e. incrementality test in a multi-linear regression framework. This way you can still check how changing marketing spends in a particular channel will affect overall gross sales but you can do so while also seeing the combined impact of multiple variables on...
Performance Max Incrementality Test | How Much Incremental Impact PMax Campaigns Have on Revenue
zhlédnutí 283Před 2 měsíci
As a continuation of my series on incrementality testing, I have prepared a video walkthrough/tutorial on how to test the incremental impact of your Google Ads Performance Max campaigns on total and new customer revenue. The template used is in Google Sheets. You will learn how to calculate sample size as well as test duration to run the test. We compare the lift in revenue when we use PMax (wi...
How to Use Incrementality Testing to Establish Causal Impact of Google/Meta Ads
zhlédnutí 394Před 2 měsíci
In this video, I explain 3 types of AB testing or experimental approaches, all of which can be broadly called incrementality testing. However, following Google's definition, I show that pre-post analysis is strictly speaking, not a kind of incrementality testing. I give a walkthrough of 3 different incrementality testing templates and show how you can use statistical concepts like significance ...
How to Do Product Segmentation With K-Means Clustering in Excel
zhlédnutí 107Před 2 měsíci
In this video, I show how product segmentation can be done using metrics like ROAS, CTR, CPC and Price Index through K-Means Clustering in Excel. In previous videos I have shown the use of this algorithm in Google Sheets and Python code. This time I show how this can be done in Excel, with the help of some basic calculations, VlookUps and some Power Query. So naturally you will require an Excel...
How to use my 1 Click K Means Clustering Template in Google Sheets
zhlédnutí 77Před 2 měsíci
How to use my 1 Click K Means Clustering Template in Google Sheets
Google Ads Conversion Tracking Using Google Tag Manager & Shopify Customer Events
zhlédnutí 738Před 2 měsíci
Google Ads Conversion Tracking Using Google Tag Manager & Shopify Customer Events
How to Analyze the Impact of Promotions on Sales (Correctly) | Marketing Analytics Series
zhlédnutí 77Před 2 měsíci
How to Analyze the Impact of Promotions on Sales (Correctly) | Marketing Analytics Series
1 Click Search Theme Generator (Google Sheets template) from Product Title/Keyword/Queries
zhlédnutí 59Před 2 měsíci
1 Click Search Theme Generator (Google Sheets template) from Product Title/Keyword/Queries
Hierarchical Clustering - Clearly Explained
zhlédnutí 36Před 3 měsíci
Hierarchical Clustering - Clearly Explained
How to Export Google Ads Imported Data from BigQuery into Google Sheets for Analysis!
zhlédnutí 107Před 3 měsíci
How to Export Google Ads Imported Data from BigQuery into Google Sheets for Analysis!
RFM-LTV Analysis With Machine Learning (K-Means+XGBoost) - Clearly Explained!
zhlédnutí 209Před 3 měsíci
RFM-LTV Analysis With Machine Learning (K-Means XGBoost) - Clearly Explained!
How to Run Experiments on Google Ads - Clearly Explained
zhlédnutí 75Před 3 měsíci
How to Run Experiments on Google Ads - Clearly Explained
How to Set up Google Ads Custom Column - Expected Monthly Spend - Clearly Explained
zhlédnutí 102Před 3 měsíci
How to Set up Google Ads Custom Column - Expected Monthly Spend - Clearly Explained
Can you share the excel sheet, Kisholay?
template ؟
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
Please share the excel sheet in your description
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
Can you send your excel sheet to serve as a template?
hi pls connect with me on LinkedIn www.linkedin.com/in/kishalaya-mukhopadhyay17/
How do you convert {% if first_time_accessed %} into Customer Events to ensure we are not getting duplicate parameters?
太厉害了
Amazing stuff man! Love it !! Give me that code brother !
Sure, pls get in touch with me on my LinkedIn profile www.linkedin.com/in/kishalaya-mukhopadhyay17/
I think the original version is by Martin Röttgerding at Bloofusion, right?
That's a Google Ads Script. This is just Google Sheets
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
Thanks for sharing. Where's the code link
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!
Thanks Quint, yes I agree with your suggestions, still early days in my CZcams 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!
can you share the URL of the video you talked about (GA4 server side)
Superb! Can you share the template?
Thank you, sure, Here it is : topmate.io/kisholoy_mukherjee/1026070
@@kisholoymukherjee thank you so much!!
Thanks !!
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.
The problem statement is simple - how do you better segment your products so that you can plan your marketing campaigns more efficiently
amazing work dude! Thanks for sharing
Thanks so much
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?
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
Great content! Thanks for simplifying this complicated setup
Thank you
Super interesting, Thanks for sharing! Keep posting, your channel is full of interesting videos
Thank you so much, will surely keep sharing more.