For around 100 biggest grossing gaming companies listed in attached file (not all companies are there yet, I will update today), and for about 300 of the biggest grossing apps attached in the second file, do the following:
Fill out the example attached files with complete information for the quarters 2019-Q1 and 2019-Q2. Hence, only for two quarters!
In the file "parent company - subsidiary companies" , fill in info about company hierarchies.
In the file "revenue_table", fill info about revenue, ua (user acquisition), net profit, etc.
In the file "shared apps table", fill info about how much of each apps revenue is shared with other companies.
First you always have to go to each company's website and search for the required information there, usually most of the information can be found in the corresponding quarterly report and/or presentation. For example, quartly revenue is easy to find in the quarterly reports.
Hence, you have to read/browse through 2019-Q1 and 2019-Q2 reports/presentation for each company to search for the required information.
Always store evidence of the numbers inserted into the tables such as the revenue, ua, apps revenue shared percentage, company hierarchy, etc. The evidence is usually the company's quarterly report, or an email from the company's investor relations.
If you don't find all required information in the corresponding quarterly reports/presentation, email each company's investor relations (email usually found on the homepage of the company) and ask for the info, hence each company IR usually needs to be sent a couple of emails to make sure the info is correct.
IMPORTANT: Never refer to this project when sending emails to company's IR departments. You don't need to specify why you ask questions.
First part of the project is to show that you can fetch all the information for one company (i.e. fill out all three google sheets for two companies). This is to show that you have understood the project requirements and you have completed the sample correctly.
When this is completed in a satisfactory way the second part is to do the same for all companies.
Here are the three files (they will most likely be updated over time with some additional columns)
Quarterly revenues can be found in the quarterly reports.
The quarterly reports can be found in the IR section of each company's home page.
This task will be probably return each quarter, hence new compensation will be payed every quarter.
Once you complete workd for one gaming company, it is quite easy for you to do the rest.
Just enter NA (Not Available) when companies don't provide some information.
Remember to always save the evidence from where you get the data (that you insert to the google sheets tables) so it can be traced to be correct.
47 freelancers are bidding on average $457 for this job
Greetings! I am an Equity Research analyst and have experience working on similar mandates in the past. I am keen to help you here. Look forward to hear from you. Thanks, RRC
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards Relevant Skills and Experience Data entryexcel
Hello Mr I have good knowledge of data entry and web researches, I can work this sheet within days with perfect accuracy, I already worked with similar projects which asked for contact info Thanks
Hi Sir I am interrested in this project. My name is Faiz and im an Actuary and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis.
I have a good understanding f the project and l can deliver according to requirements and within the specifications. deliver within the deadline and quality work.