How to import data from AHREF SEO ads into Google Sheet, DataStudio and Excel?

Do you want the data imported from Ahref to Google Sheet or Datastudio? And also automate this data transfer daily or hourly? Let me share few options based on different scenario. Let’s go inside into a updated and straight forward option using a single and simple google sheet and excel plugin called Supermetrics : (Website Link)… Continue reading How to import data from AHREF SEO ads into Google Sheet, DataStudio and Excel?

Difference between Digital Marketing vs Data Analytics

Note: The Data Analytics am focusing here is fully on marketing focused thing. (like web, app user behaviour, etc) There used to be and still there is different role for data analyst and digital marketing in companies. Big companies wanted to separate it out, small companies may not be able to afford to. Also as… Continue reading Difference between Digital Marketing vs Data Analytics

Difference between Digital Marketing vs Growth Marketing

Now let’s take a look on what is the difference between digital marketing and growth marketing. This above image is from GrowthTribe updated pirate funnel of Dave McClure(500 Startups) explaining how the thoughts of growth team and marketing team differs. There is profession/career/job for you if you have studied digital marketing. The only thing I… Continue reading Difference between Digital Marketing vs Growth Marketing

Fundamentals of marketing

Every wondered the fundamentals of digital marketing, the basics things to think about. Funnel Everything you do in marketing whether it is metrics or strategy or team allocation or tool buying or budget planning or anything you plan, think from funnel perspective. It is not because industry is following but because it shapes your thinking, planning… Continue reading Fundamentals of marketing

Difference between Data Analytics vs Data Engineering vs Data Science

This is something still in the grey area which I believe it all overlaps together in different places (digital marketing + data analytics + Data Engineering + Data science). More than a few fields, I believe data science has been heavily applied in personalisation and improving the user experience of a visitor on a website… Continue reading Difference between Data Analytics vs Data Engineering vs Data Science

7 Tools to Automatically Export Shopify into Google Sheets

You might want to connect Shopify to Google sheets for import, export, sync, schedule and automate for different business needs. Sharing here the list of tools that you can help you to achieve this automation. There are 3 different approaches to automate Shopify into Google sheet. Hence, the tools would be fundamentally different for each… Continue reading 7 Tools to Automatically Export Shopify into Google Sheets

12 Alternatives to Funnel.io – Similar and Competitors

Looking for an alternative to Funnel.io? If you are looking for the Google Sheet and Bigquery as a destination. This below could be worth considering. Whether you want simple tools like zapier automation or bulk data ETL pipeline, here you can find. If you are a marketer, the best funnel alternative is Supermetrics. Supermetrics has agnostic… Continue reading 12 Alternatives to Funnel.io – Similar and Competitors

15+ Chrome extensions & Google Sheet Add on that really helps me everyday, time & energy.

Sometime I wondered how people who have lot of responsibilities managed their task, time and focused on right things. Mindset, Tools, System(process), Strategy and Data. Am a big believer of everything we do, can be improved by using mix of this things.  You would have seen in your job requirements and also some advices like… Continue reading 15+ Chrome extensions & Google Sheet Add on that really helps me everyday, time & energy.