One of our colleague has prepared this step to step guide on how to extract and automate the data from facebook ads to Google sheets using google app script. With his permission, I will share what he has shared with some extra comments. Steps we’ll go through in the process: Read more…
Before 2year back, we wrote a detailed guideline on how to extract data from Facebook not just in google sheet and excel but also in different marketing Datawarehouse like Bigquery, etc. Let’s go inside into a updated and straight forward option using a single and simple google sheet and excel Read more…
The PAST: On 2017 after an interview call with Zhao Hanbo(The first marketing guy in Supermetrics), I wrote the below in the summary email. Taking out the few lines from there Supermetrics started with vision of saving time for people to analyze in excel Then started using cloud sheets. Now it Read more…
Wondering how much it cost to really hire a digital marketing agency & advertising agency? Sharing here the pricing/cost of hiring a digital marketing agencies from own experience + some research data from ecosystem players. Things to remember hiring an marketing agency Hiring an agency partner to handle marketing of Read more…
1. Don’t be too late to realise what you are going after Don’t let the outsiders or your investor correct the mistake you have been doing so far in reporting. Sit, listen and understand from your team mates on how every number is tracked, what is not tracked, and what Read more…
Do you know what is Tools marketing? You built mini tools or call its a “micro product” which deliver value to the users. Why do clever startups use this hack? They do not want to go in the conventional model of building vast variety of contents or pour money into advertising Read more…
The purpose of sharing the contacts here in this is meant to help you but not use for spamming. so use it wisely. Name Linkedin Email Field focused on Company Comments Country Clovie https://www.linkedin.com/in/clovie-liu-73a669a6 Guess she moved to Thomson Reuters, you can still contact her singapore Kevin https://www.linkedin.com/in/kevin-xu-7948b034 singapore Daniel Read more…
“You integrate your product/services into a existing ecosystem or create new ecosystem which helps organic growth and stickiness of the product. “ Is it that simple? It’s not. Why is it important? Multiple reasons but let me the brief things here It helps the stickiness of a user into a same Read more…
Building a marketing data warehouse is not a simple project to do but if it’s done properly, there is a numerous business outcome. We will go through 3 things. Why we need marketing data warehouse and what’s so important? How should we build marketing data warehouse and different approaches ? Read more…
This guide is one of the extensive piece I have wrote taking few weeks to help out mid career professionals and students. I started with clarification of Growth Marketing vs Digital Marketing vs Analytics vs Data Engineering vs Data Science. Then went on explaining taking a different route in marketing. Read more…