How to Prioritize? This is a unclear question from many. Through the experience, I have clearly learned that the long list, detailed task planning at the start of the year(or month or day) doesn’t seem to be helping. I fall in love with 4 Quadrant matrix, that clears out every doubt and clarify my confusion.… Continue reading How to Prioritize Strategies, Tasks, Projects in your Marketing team
For the first time, I heard about the loss leader strategy in 2014. When I first heard when my colleagues were saying I thought it’s just as a fake attempt to manipulate the sales. But slowly after going through different experiments and observing what’s happening in the current industry trends, it is okay to follow… Continue reading On 1904, this strategy leads to acquiring 1,800,000 people
Last night, I stumbled upon our old Facebook ad account. I kept looking at for a while with a surprise that we seem to have done a better job of managing that client account. It’s a property industry. If the user converts, his house price would be minimum of USD100K. We are not allowed to… Continue reading A simple targeting strategy that brought 58k leads at less than $5 – Facebook Ad Campaign
Looking for a digital Marketing Agencies or consultants to grow your business? If you are clear on what exactly you want from the agencies, it’s going to be straightforward. If not, I am sharing my checklist which I will include in my review agenda when am in your situation. I have worked with International agencies… Continue reading WHY and HOW you should hire/screen a digital marketing agency? – 2020
Life is awesome when there are ready made ETL/ELT, Data Automation tools 🙂 Whether it is bulk dumping data transfer, or scheme based fetch jobs or even task based automation like zapier. Everything saves significant time in our life hahaha. Here is the list of all the tools I have collected so far. Am sure… Continue reading 20+ Cool ETL Tools and Data Automation for Marketers and Data Nerds
There are so many guides out there explaining about cohort analytics in a very intuitive way. They clearly explained the concept of analysis and examples with generic stories. I owe some of my colleague explaining with the real story of how I used in different use cases in different companies. Why cohort analysis is important?… Continue reading 10+ Examples on how to use cohort Analysis + template
Yo! Not all Data Nerds may be but the lazy crazy one who look for fewer steps to achieve something 🙂 Whatever let’s just quickly go through what it means for Marketer or Data guy. Days back we covered quickly about the love ❤️ between Google connected sheet and Supermetrics for BigQuery. Someone asked me… Continue reading What does the supermetrics for Bigquery Means for all DATA NERDS?
Google Connected sheet is a new type of spreadsheet that activates a special mode in your Google Sheet. This special connection overrides most of the limitation you have in normal Google sheet(like 10K rows). This is really an important feature for Analyst and Marketers who want to analyze bulk data sets in billion of rows.And… Continue reading What’s Google Connected Sheet? Supermetrics for BigQuery users?
Looking for ways to Load, Transfer and automate your Google Analytics data into Microsoft SQL Server, PostgreSQL, BigQuery, Redshift, Snowflake and other data warehouse? Last year I wrote this article on how to automate data transfer between facebook ads data into multiple destinations, it seems like that is on google first page and also received few… Continue reading 7 tools to Load, Transfer and Automate your Google Analytics data into Google Sheets, Bigquery, Redshift, SQL server, Tableau and Data studio
Looking for ways to automate your Linkedin ads and company pages data into Google sheet or Microsoft excel or bigquery or tableau or datastudio or another data warehouse? Last year I wrote this article on how to automate data transfer between facebook ads data into multiple destinations, it seems like that is on google first… Continue reading 6 tools to automate your Linkedin ads/leads/company pages data into Google Sheets, Bigquery, Tableau and Data studio