Jan 5, 2021Markov Chain in Multi-Channel Attribution Modeling (Python code with real world case study)What’s the best channel for your marketing efforts? An analytical, data-driven approach to developing marketing strategy and optimizing budget allocation. As a marketer for any businesses, we’re constantly asking these questions: “What channel is the most powerful?” “How can I know the impact of each channel on overall conversion?” …Markov Chains5 min read
Published in Analytics Vidhya·Dec 2, 2020Analyze Trip Advisor Hotel Reviews: LDA Topic ModelingWhat makes a hotel good/bad? What matters to the travelers? Let’s find out. Hotels play a crucial role in traveling and with the increased access to information, new pathways of selecting the best ones emerged. With this dataset, consisting of 20k reviews crawled from Trip advisor, I will apply LDA to…Naturallanguageprocessing5 min read
Nov 24, 2020LeetCode Diary (daily update)A LeetCode a day, keep unemployment away ;) Starting today, I will be solving 5 LeetCode problems per day for at least one month. In this article, I will be documenting the problems that I solve to keep myself motivated. I’ll also be putting down the solutions as well as…Coding6 min read
Nov 22, 2020Initial Exploratory Data Analysis On Japan Console Game Sales with SQL & TableauJapan’s video game market overview from 1980–2015Sql3 min read
Published in Analytics Vidhya·Sep 17, 2020Customer Demographics & Segmentation Analysis with Simple PythonSimple approach to understanding your customers better What is Customer Segmentation Customer Segmentation involves dividing a customer base into groups of individuals based on certain traits they share. Segmentation helps with a company’s customer relationship management and overall marketing performance. By segmenting your customer base, it allows companies to tailor marketing efforts to target…Marketing Analytics10 min read
Aug 17, 2020Build Powerful Influencer Marketing Strategies in 2020 for your brandCommon mistakes made by businesses & how to avoid them in influencer marketing (from a marketer&influencer point of view) Over the past decade, social media use has skyrocketed. It became closely integrated in our lives, and has proven to transform our society as a whole. …Influencer Marketing6 min read
Jul 5, 2020SQL (vs. Excel) in Digital MarketingWhy and How you can leverage your marketing tool for better productivity Scroll down to find out how I learn SQL in 5 days as a newbie with absolutely 0 coding/programming experience! What is SQL? SQL stands for Structured Query Language. …Sql5 min read
Jan 6, 20205 Steps to Building Effective Social Media Marketing StrategyA step-by-step guide to building your own social media strategy Social media is a powerful way for all businesses to not only reach prospects and customers, but to engage, and build relationships with them. Today, social has also become the bridge that actively connects businesses with target audiences. …Social Media4 min read
Dec 12, 2019The Big 3 behind Instagram Algorithm (How the algorithm works)Grow your Instagram followers organically in 2020 點我進中文版 Click Here to read this in Mandarin Before we dive into the major factors that control the algorithm, we have to understand what algorithm really is, and the purpose behind all this. In terms of algorithm, you can think of it as…Social Media7 min read
Dec 11, 2019Instagram 網紅經營秘訣：演算法大公開 2020 IG紛絲追蹤輕鬆破萬攻略別再任由Instagram算計你！搞懂IG如何決定誰紅誰不紅2020你就是網紅 點我進英文版 Click here to read this in English Instagram到底 在了解如何經營IG之前，我們必須先搞懂Instagram的最終目標和他的運營的手法。和Facebook一樣，Instagram同以付費廣告賺錢。而為了讓公司願意在Instagram上打廣告，Instagram必須討好用戶 — 打造一個能聚集眾多使用者，同時取悅並誘使用戶停留的平台。 為了達成這樣的目的，IG寫出了一套讓你離不開他的演算法！ 什麼是演算法？演算法是一套電腦數學運算模式，用來處理資訊並做出決策。IG依據演算法去決定用戶在他的個人頁面(Feed)裡看到的貼文和貼文的順序。根據特定的規則，對貼文進行優先排序，並為選擇性為某些貼文提供最大的曝光度。 因此，而若能了解控制演算法的3大要素，並做到以下說明的幾點，IG就會不惜上天下海來幫助你！成為網紅，粉絲追蹤輕鬆破萬絕對不是問題！Instagram7 min read
