GameCo's - an Excel project
GameCo’s marketing strategy operates under the assumptions of where their biggest markets are, and that the trend for sales stays similar over time. Stakeholders want to use data to inform on the development of new games, as well as their strategy for the upcoming sales season.
Key assumptions:
​
-
North America is the biggest market for sales, with 44% of return in revenue, compared to the EU (33%) and Japan (12%).
-
This trend of sales stays similar over time.
Key insights found:
-
In NA, there seems to be a drop of 9% in the quantity of units sold every 3.5 years (on average).
-
Sales for the EU Region also decreased. However, there is a clear trend of increase of 9% in their share of global sales, throughout this period.
-
JP’s Market also presents a continuous decline in sales, but it maintains a constant average of 12% in the share of global sales, with a surge of 7% more sales in 2016.
Key suggestions:
-
For the upcoming sales season, budget for marketing campaigns should focus on the top sellers for each region.
-
Our assumptions should be revaluated at a minimum of two years to ensure maximum return of investment.
-
Consider comparing quarters within the year – and previous years – to check impact of marketing campaign, and whether seasonality affect sales.
For a PowerPoint presentation, please click here.