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.
