Analyzing Digital Marketing Campaigns with Data Science
Posted: Thu Dec 05, 2024 5:46 am
Harve's Data Science course was my first contact with the data science area and the project was also my first. The initial idea of the final Data Science project was to create a Marketing Mix Modeling where the MMM's function is to understand and evaluate the performance of the campaigns and understand how much more effective each one was during the period of time in which it was carried out.
So the objective of the project is to identify and understand which advertising channel is bringing the greatest return on investment (ROI), thus being able to more assertively optimize the campaign budget and, at the same time, saudi arabia number data create an increasingly appropriate and effective strategy.Project execution:
So the chosen database is a database found on GitHub, which contains campaign information from a company in Hong Kong, China, such as demand, sales, advertising expense data, investment in SMS, newspaper, radio, TV, internet and gross audience points (GRP) of each channel invested in, thus making it possible to calculate the effectiveness of the campaigns.
Follow the steps of the project carried out at Colab
1st Importing the libraries and extracting the .xlsx file from the drive where it was locatedAs we can see, the linear regression did not present a satisfactory result, so by going deeper and researching other factors to better understand what may have happened, a macroeconomic factor was identified that may have helped this happen. Hong Kong, a former British colony, was returned to China in 1997 and has since been considered a place with two systems. In 2014, a white paper was published detailing the practices of a place with two systems. The document calls for a full and accurate understanding of the meaning of the policy, stating that “Hong Kong’s high degree of autonomy is not an inherent power, but rather one that comes only from the authorization of the central leadership.” This issue explained above may be a factor that has hindered the company’s performance over the years.
So the objective of the project is to identify and understand which advertising channel is bringing the greatest return on investment (ROI), thus being able to more assertively optimize the campaign budget and, at the same time, saudi arabia number data create an increasingly appropriate and effective strategy.Project execution:
So the chosen database is a database found on GitHub, which contains campaign information from a company in Hong Kong, China, such as demand, sales, advertising expense data, investment in SMS, newspaper, radio, TV, internet and gross audience points (GRP) of each channel invested in, thus making it possible to calculate the effectiveness of the campaigns.
Follow the steps of the project carried out at Colab
1st Importing the libraries and extracting the .xlsx file from the drive where it was locatedAs we can see, the linear regression did not present a satisfactory result, so by going deeper and researching other factors to better understand what may have happened, a macroeconomic factor was identified that may have helped this happen. Hong Kong, a former British colony, was returned to China in 1997 and has since been considered a place with two systems. In 2014, a white paper was published detailing the practices of a place with two systems. The document calls for a full and accurate understanding of the meaning of the policy, stating that “Hong Kong’s high degree of autonomy is not an inherent power, but rather one that comes only from the authorization of the central leadership.” This issue explained above may be a factor that has hindered the company’s performance over the years.