data analysis project
Budget: ₹600 – ₹1,500 INR
've attached an excel file to the email that contains data of two marketing campaigns, Google Ads, and a listing site. Go through the dataset, and deliver the following:
- Create a combined report with all key metrics (esp: Spends and Returns) in a weekly and monthly format. Decide the number of data fields you would like to showcase here.
- Which is the most profitable channel
- Which category/keyword is the most profitable
- Look for insights by analysing data points on time series graphs
- Analyse the Impact of geography
Feel free to creatively bring in additional insights from the data set. Kindly attach all the data, graphs, and pivot tables in a presentation format or on Google Data Studio. Also, share your base excel file (or Google Sheet) that has been used in the analysis.
- Create a combined report with all key metrics (esp: Spends and Returns) in a weekly and monthly format. Decide the number of data fields you would like to showcase here.
- Which is the most profitable channel
- Which category/keyword is the most profitable
- Look for insights by analysing data points on time series graphs
- Analyse the Impact of geography
Feel free to creatively bring in additional insights from the data set. Kindly attach all the data, graphs, and pivot tables in a presentation format or on Google Data Studio. Also, share your base excel file (or Google Sheet) that has been used in the analysis.