Đã hoàn thành

Create Dashboard Google DataStudio

I need you to create a dashboard where we will bring KPIs to an overview of my business.

The main sources will be Google Analytics and Google Sheets.

Google Analytics is already set up and working, the data collection with Google Analytics you need to create so that it perfectly meets the integration with Google Data Studio.

Come on, I'm going to divide the project into modules, so we can discuss it in stages.

These controls must be filtered by day, week, month, quarter, semester, and yearly.


Using a spreadsheet, we will analyze the daily sales index of 3 products. The main objective is to monitor which product performs better by comparing the quantity sold and revenue for each product.

Products that should be considered:

-Sale of the product "Stickers da Coleção"

-Sale of the product "Stickers Corporativos" - (Here we must calculate if there was a commission for external seller)

-Sale of the product "Stickers Personalizados"

These controls must be filtered by day, week, month, quarter, semester, and yearly. They must contain the quantity sold and the total sales revenue for each product.

In this KPI, add up all sales and show total revenue.

In this KPI, show the average ticket



KPI that indicates the volume of products shipped by carrier, that is, it must compute how many units were shipped to each carrier.

Here we need to compute how many submissions had errors and needed to be resent and what the costs were for each resend.



Here we must show which seller is performing better and what the monthly commission amount was paid on the product "Stickers Corporativos ".

You will need a control to register sellers in Google sheets



We work with printing and would like to have an insight into printer consumption.

Factory equipment generates a CSV file showing various indicators.

Among these indicators from the CSV file, I would like to have a graphical view:

The reports must be categorized by "Support Type", this means which material is being used, for example: Adhesive, Holo, Transparent, Canvas and all materials that are registered by the equipment.

- Total spent in ml for each ink color and which ink is consuming the most

- Total spend in R$ for each color of paint and which paint is consuming the most

- What total area in M2 were printed with filter for each printer

- What is the total cost of the area?

- Total print time by day, week and month (Graph comparing other months)

Maybe this is module one that we need to explain better, show you every detail inside the CSV file and translate so that you understand. Once you understand it, it will be very easy to work with the data.


[ KPIs 05 - KEY ECOMMERCE INDICATORS Google Analytics ]

Here we will extract the data from Google Analytics

- Create dashboard design funnels:


Visits Product views

Visits Add to cart

Visits Start checkout

Visits Purchase

- Shopping Cart Abandonment Rate (CAR)

- Sales Made by Acquisition report, i.e. mapping which UTMs are bringing in the most sales

- Bounce rate

- Exit fee

This is an early project and one that we will improve over time, so we need someone who understands and can provide a long-term service. We understand that this is an early version and that we will improve a lot.

The Dashboard Layout Design should be clean and beautiful.

Kĩ năng: Google Analytics, Excel, Kiến trúc phần mềm, Google Data Studio, Google Sheets

Về khách hàng:
( 11 nhận xét ) Uberaba, Brazil

ID dự án: #33981282

Được trao cho:

(166 Đánh Giá)

26 freelancer chào giá trung bình$509 cho công việc này

(543 Nhận xét)
(203 Nhận xét)

"Sir, I am Excel Dashboard Advance Level Expert Having Experience of over 10 Years. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 year Thêm

$300 USD trong 1 ngày
(175 Nhận xét)
(77 Nhận xét)

Hi there, ★★★ Google Data Studio / APPs / Forms / VBA Expert ★★★ 6+ Years of Experience ★★★ I've read requirements and ready to create a dashboard. I am capable of developing both script-based and formula-based spread Thêm

$750 USD trong 7 ngày
(47 Nhận xét)
(10 Nhận xét)
(29 Nhận xét)
(20 Nhận xét)

Hi, dear employer. Thanks for posting ur project and ur attention, I read ur project carefully. I can carry out ur task with the lowest budgets than anybody. PHP/WordPress/Shopify/CI/Laravel/Python/Vue.js/Node.js/Angu Thêm

$500 USD trong 7 ngày
(29 Nhận xét)

Hi, I encourage you to please read this cover letter with a keen interest to give me a chance to help. I am Lukman, I have read your job details, requirements and the process and I am passionate about becoming a part o Thêm

$500 USD trong 2 ngày
(3 Nhận xét)
(2 Nhận xét)

Hi there, I'm "Salehin Mohammad F; I am an expert in professionalization in the Excel program and dissertations with skills including ✓Excel ✓VBA Excel✓ CSV✓ Macro ✓ Excel Sheet Guru with report Writing. Feel free to c Thêm

$250 USD trong 1 ngày
(3 Nhận xét)

I will analyze, transform, and visualize the data in Data Studio. Get data from any data source i.e. Excel, Google Sheet, SQL, GoogleBigQuery, Google Analytics, Adwords, Adsense, Instagram, Salesforce, Chargebee Fix Thêm

$500 USD trong 7 ngày
(1 Nhận xét)

I not only offer support, but a whole range of services to help you create, manage and build powerful web and mobile apps platforms' presence. Avail Splendid and Futuristic Solutions that help to expand your business Thêm

$289 USD trong 5 ngày
(0 Nhận xét)

Hi, I am Luc. A Software Engineer with 8+ years of experience in the field. I've gone through your project description regarding a KPI analytics platform to track your internal goals. I read your description and am in Thêm

$250 USD trong 2 ngày
(0 Nhận xét)

Hi there, I am Rashid, Hope you are doing great. Firstly about the Create Dashboard Google DataStudio that I have a great experience in it. I am very confident to pull it off once awarded. I am a Full stack developer w Thêm

$700 USD trong 15 ngày
(0 Nhận xét)

★★★ Scrapping / Python / Selenium Expert ★★★ 5+ Years of Experience ★★★ Hello .I hope you are fine? please feel free to contact me through chat to discuss about your project in detail. I have extensive knowledge of D Thêm

$503.8 USD trong 7 ngày
(0 Nhận xét)

Hello! I am more than interested to help you and ready to get started right away.I have over 8 years of experience working on websites! I will design, develop, secure, troubleshoot, and SEO empower your websites. I go Thêm

$700 USD trong 7 ngày
(0 Nhận xét)

Good evening My name is Benjamin Cerrone. I used to work at a digital marketing agency a while back. I was in charge running both Facebook and Google campaigns for ten clients I had under my watch. They were mostly eco Thêm

$500 USD trong 7 ngày
(0 Nhận xét)

I have adequate knowledge to do the job and willing to exert extra efforts to build proper profile on the platform

$300 USD trong 4 ngày
(0 Nhận xét)