Quick Google Sheets Marketing Data Visualizations
Budget: $30 – $250 USD
I haver an excel file with 4 columns, "Campaign, Clicks, date, spend. Their is not much data (253 rows) which is data for one month.
I need the job done by 23:00 GMT 25/09/2022.
What is required is to use formulas in google sheets to give insight into the data, e.g derive the day of week from each date for each row of data (this can be done using the formula =switch(WEEKDAY(C3),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5, "Thursday",6,"Friday",7,"Saturday"), where C3 is the date. I want to visualize the data using the best marking visualization techniques.
THIS IS WHERE I NEED YOUR EXPERTIESE:
I am not sure of all the ways to best understand and display the data. I want to understand how to clearly identify what days and campaigns and trends give best and worst profit and clicks. I am going to give some examples of what I might want, but I am not sure if they are the best ways to go about it, I need you to advise me. The goal is to clearly understand the data to make improvements to how we operate. I am not sure but you need to give visualizations (graphs and charts) to know what campaigns what days give what click rate, spend rate, average spend per click, click rate per day, click rate per campaign, what days of the week and what campaign give what profit. This list is just an armature idea and I need you to come up with the best ways to understand the data. I need your help with this.
I also need a clear dashboard created in google sheets representing the data. This must be professional and clear and very understandable and useful for understanding the marketing data.
The data in google sheets must be clean and understandable along with the data visualizations.
You should have experience representing marketing data in google sheets and know what is important and what is not from the data. You need to complete this by 23:00 GMT 25/09/2022.
What I need to be delivered within 8 hours of this job being posted:
A google sheets document sent to me with the dashboard included and the data sorted in a clean manner, all formulas efficient and the simplest way of doing it to get the best results. As little clutter as possible.
I also require a word or pdf document explaining why you choose the methods of visualizing the data that you did, e.g. a pie chart was used in this case because it is more readable for the user compared to a bar chart and marketers usually use this type of chart for reasons x y z .
The document should give an overview of the formulas used in google sheets to represent the data and process it, and say why it was chosen.
I need to be able to understand your thinking and reasons, because I will have more work for you if you do a good job and give me confidence in your expertise. I am a novice so you need to clearly explain to me how you did it and why you did it the way you did it so I can know if I will hire you again. I will be getting your work checked by another expert.
I state again, the goal is to clearly understand the marketing data in depth so our methods can be updated based on the analysis.
I should be able to extract all of the graphs and charts from google sheets and save them on my computer.
Give me an overview of what you will do and why you are good for the job, and commit that you can complete it by the time specified, and I will give you the job if you are honest and clear with the skills.
I have attached the excel file that must be worked on in google sheets and sent to me in google sheets, and I need the word or pdf document explaining the reasons for the methods used in visualizing the data( why it was better than other methods), and the explanation of the formulas and layout of the data in google sheets. Also do not forget that I need a dashboard in google sheets representing the data too, so clear marketing methods can be implemented from the data.
I need the job done by 23:00 GMT 25/09/2022.
What is required is to use formulas in google sheets to give insight into the data, e.g derive the day of week from each date for each row of data (this can be done using the formula =switch(WEEKDAY(C3),1,"Sunday",2,"Monday",3,"Tuesday",4,"Wednesday",5, "Thursday",6,"Friday",7,"Saturday"), where C3 is the date. I want to visualize the data using the best marking visualization techniques.
THIS IS WHERE I NEED YOUR EXPERTIESE:
I am not sure of all the ways to best understand and display the data. I want to understand how to clearly identify what days and campaigns and trends give best and worst profit and clicks. I am going to give some examples of what I might want, but I am not sure if they are the best ways to go about it, I need you to advise me. The goal is to clearly understand the data to make improvements to how we operate. I am not sure but you need to give visualizations (graphs and charts) to know what campaigns what days give what click rate, spend rate, average spend per click, click rate per day, click rate per campaign, what days of the week and what campaign give what profit. This list is just an armature idea and I need you to come up with the best ways to understand the data. I need your help with this.
I also need a clear dashboard created in google sheets representing the data. This must be professional and clear and very understandable and useful for understanding the marketing data.
The data in google sheets must be clean and understandable along with the data visualizations.
You should have experience representing marketing data in google sheets and know what is important and what is not from the data. You need to complete this by 23:00 GMT 25/09/2022.
What I need to be delivered within 8 hours of this job being posted:
A google sheets document sent to me with the dashboard included and the data sorted in a clean manner, all formulas efficient and the simplest way of doing it to get the best results. As little clutter as possible.
I also require a word or pdf document explaining why you choose the methods of visualizing the data that you did, e.g. a pie chart was used in this case because it is more readable for the user compared to a bar chart and marketers usually use this type of chart for reasons x y z .
The document should give an overview of the formulas used in google sheets to represent the data and process it, and say why it was chosen.
I need to be able to understand your thinking and reasons, because I will have more work for you if you do a good job and give me confidence in your expertise. I am a novice so you need to clearly explain to me how you did it and why you did it the way you did it so I can know if I will hire you again. I will be getting your work checked by another expert.
I state again, the goal is to clearly understand the marketing data in depth so our methods can be updated based on the analysis.
I should be able to extract all of the graphs and charts from google sheets and save them on my computer.
Give me an overview of what you will do and why you are good for the job, and commit that you can complete it by the time specified, and I will give you the job if you are honest and clear with the skills.
I have attached the excel file that must be worked on in google sheets and sent to me in google sheets, and I need the word or pdf document explaining the reasons for the methods used in visualizing the data( why it was better than other methods), and the explanation of the formulas and layout of the data in google sheets. Also do not forget that I need a dashboard in google sheets representing the data too, so clear marketing methods can be implemented from the data.