Completed

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.

[ KPI 01 - SALES CONTROL MODULE BY PRODUCT ]

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 02 - TRANSPORTED VOLUME CONTROL MODULE]

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.

----------

[ KPI 03 - COMMISSION VISION MODULE FOR VENDORS]

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

----------

KPI 04 - PRODUCTION MODULE]

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

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.

Skills: Google Analytics, Excel, Software Architecture, Google Data Studio, Google Sheets

About the Client:
( 11 reviews ) Uberaba, Brazil

Project ID: #33981282

Awarded to:

(166 Reviews)
6.4

26 freelancers are bidding on average $509 for this job

(543 Reviews)
8.5
(203 Reviews)
6.8
AccountantArman

"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 More

$300 USD in 1 day
(175 Reviews)
6.6
(77 Reviews)
6.3
techplusintl

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 More

$750 USD in 7 days
(47 Reviews)
6.6
(10 Reviews)
6.6
(29 Reviews)
4.6
(20 Reviews)
4.4
nbprince

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 More

$500 USD in 7 days
(29 Reviews)
4.6
Lukwence

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 More

$500 USD in 2 days
(3 Reviews)
3.5
(2 Reviews)
3.5
salehinfaijus360

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 More

$250 USD in 1 day
(3 Reviews)
2.8
omemajawaid

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 More

$500 USD in 7 days
(1 Review)
2.2
datasclancer

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 More

$289 USD in 5 days
(0 Reviews)
0.0
lucamennr

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 More

$250 USD in 2 days
(0 Reviews)
0.0
rashidamjad

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 More

$700 USD in 15 days
(0 Reviews)
0.0
paradoxoxymoron5

★★★ 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 More

$503.8 USD in 7 days
(0 Reviews)
0.0
mwwaqas246

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 More

$700 USD in 7 days
(0 Reviews)
0.0
bcerrone

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 More

$500 USD in 7 days
(0 Reviews)
0.0
Mkhayzoran

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

$300 USD in 4 days
(0 Reviews)
0.0