Project translated automatically. Log in or register, to view the original You need to create a convenient dashboard based on data that will be entered into the Google table daily.I would like to do this in Goolge Data Studio (if there are alternatives - ready to consider) 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.

Proposals 2

Anastasiia Klimovych

Winning proposal

4 0

Projects 4
Rating -
Rating 655

Budget: 5500 UAH Deadline: 3 days

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.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Current freelance projects in the category Data Processing

Determination of the automotive connector by the photo of the connection location

Information Gathering 7 proposals 4 August

16 USD
ML (computer vision ) engineering project

AI & Machine Learning 21 proposals 4 August

Not specified
Uploading products to the Maudau marketplace

Online Stores & E-commerce 23 proposals 4 August

Not specified
Email newsletter

Information Gathering 7 proposals 4 August

Not specified
Find audio

Information Gathering 17 proposals 2 August

Not specified

Artem Kornieiev
Kyiv, Ukraine
ThehrdwoodLTD

Projects 18
Rating -
Rating 492

Artem Kornieiev

Anastasiia Klimovych

Anastasiia Klimovych

Proposals are currently absent

Current freelance projects in the category Data Processing

Determination of the automotive connector by the photo of the connection location

ML (computer vision ) engineering project

Uploading products to the Maudau marketplace

Email newsletter

Find audio