Create Dashboard Google DataStudio

완료 등록 시간: 1년 전 착불
완료 착불

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.

구글 웹 로그 분석 엑셀 소프트웨어 아키텍처 Google Data Studio Google Sheets

프로젝트 ID: #33981282

프로젝트 소개

24 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 1년 전

수상자:

(169건의 리뷰)
6.5

이 일자리에 대한 프리랜서 24 명의 평균 입찰가: $512

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 기타

$300 USD (1일 이내)
(191 리뷰)
6.7
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 기타

$750 USD (7일 이내)
(51 리뷰)
6.6
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 기타

$500 USD (7일 이내)
(29 리뷰)
4.6
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 기타

$700 USD (15일 이내)
(5 리뷰)
4.2
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 기타

$250 USD (1일 이내)
(3 리뷰)
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 기타

$500 USD (7일 이내)
(1 리뷰)
2.2
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 기타

$700 USD (7일 이내)
(0 리뷰)
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 기타

$500 USD (7일 이내)
(0 리뷰)
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 (4일 이내)
(0 리뷰)
0.0
rahildevelopment

Hello, I have came up with your requirement, I'm a Full stack web developer with more than 5 years of experience working with PHP, Laravel, WordPress, Shopify, Joomla, WooCommerce, and Custom Development. I have a fe 기타

$500 USD (7일 이내)
(0 리뷰)
0.0
bathiniraja5

Hello, My name is Rajasekhar. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 3+ years of experiences in this field that make 기타

$500 USD (7일 이내)
(0 리뷰)
0.0