Creating a dashboard in Goolge Data Studio
124 USD The dashboard will be divided into two parts.1) Marketing indicators
2) Total sales
1) In the marketing indicators shall enter the following metrics:
Costs
Revenue
Impression
Clicks
Orders (by advertising)
CPS (click cost)
CAC (Customer Attraction Cost)
CTR (Conversion of Advertisements)
CR (Conversion of Sales Channels)
by ACOS
ROI (Rentability of Advertising)
ARPS (the average check)
It will be divided into two sales channels, Etsy and Amazon.But in Etsy there will be a further division in 6 stores, each has different indicators.But it will be the Etsy board of everything (where all these 6 stores are counted together) as it looks like now - I'll add the table.
https://docs.google.com/spreadsheets/d/1JeOeCJPov6sy80B1IrK9vXSzFaOWs6Woenc03ds5jHE/edit#gid=0
Here I would like to see the graphs by the main metrics:
CAC (Customer Attraction Cost)
CR (Conversion of Sales Channels)
by ACOS
The other axis is the date.The main tasks: must be the filter by date, the filter by sales channel.The opportunity to compare periods.to see how the indicators have been reflected after the changes in the marketing activity.The main task is visual understanding, it should not be the accumulation of information.2) total sales - here will be the following indicators:
Visits (the number of visits)
Number of orders (the number of orders)
CR (conversion) = orders / arrivals
Revenue ( Revenue )
It will also be separated by Amazon and Etsy.The criteria are heavier, the filter by period, the filter by sales channel.Here I would like to see the schedule of sales, the axis of revenue and the date.A revenue diagram, where it is visible in the percentage ratio of how much each channel of sales brings.Examples of merketing and sales graphs are attached.
Applications 3
Client's review of cooperation with Anastasiia Klimovych
Creating a dashboard in Goolge Data StudioA good specialist. It was pleasant and easy to work, the task was completed in the shortest time possible, all at the height!
Freelancer's review of cooperation with Artem Kornieiev
Creating a dashboard in Goolge Data StudioRequirements are clear, adjustments adequate, always in contact. I recommend !
-
Winning proposal3 days124 USD
655 4 0 Winning proposal3 days124 USD
The task is understandable. In the form of the table to enter the data you will enter, I’ll suggest you another option to be able to work correctly with the dates range. And all the calculations will be done not in the table, but in the data studio.
Current freelance projects in the category Data Processing
Testing a Google Sheets template as a first-time user + written report (in English)I'm looking for a detail-oriented person to test my Google Sheets template (tracker/planner) from the perspective of a new user. WHAT NEEDS TO BE DONE: - Open the template, make your own copy - Try to fill it out as a regular buyer, without hints - Check if all formulas,… Data Processing ∙ 7 hours 33 seconds back ∙ 8 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 1 day 18 hours back ∙ 19 proposals |
Analytics Setup
225 USD
We have GTM and Conversion API connected to Meta. Currently, it is not working correctly everywhere. We need to fix the issues and further develop the amount of analytics on the product. Data Processing ∙ 2 days 12 hours back ∙ 18 proposals |
Integration of HubSpot with lead generation sources (Perspective, WordPress, Meta Ads)
90 USD
Good day! Project goal: To build end-to-end automation for lead collection from a multi-platform ecosystem into HubSpot CRM. It is necessary to ensure the creation/updating of contacts and the automatic opening of deals while preserving the full attribution chain of traffic… Content Management Systems, Data Processing ∙ 4 days 1 hour back ∙ 18 proposals |
Creation of an Excel file for uploading products to the website.It is necessary to create an Excel file and fill it with the data we provide, making the file such that it can be uploaded to the website. Similar to Rozetka, WordPress, Prom, and so on. About 100 items. Data Processing, Technical Documentation ∙ 6 days 21 hours back ∙ 41 proposals |
Kyiv