Databases & SQL · Data Processing
59
0
4 581
Data Processing · Text Editing & Proofreading
120
0
5.0
3 429
Hi, I'm Vira, and there's a good chance I can help you.
I have extensive experience in education (NOT preschool or school), and working with different information systems.
Skills: data processing (spreadsheets editing and other) transcribing, adding and revising captions products uploading (Excel) and troubleshooting of uploading process to marketplaces: Amazon, Allegro, Empik, eMAG, Leroy Merlin (Mirakl / Adeo), CDiscount (Octopia) formatting of articles / reports / docs in MS Word according to guidelines or templates creation of presentations for training, workshops, webinars, lections etc…
0
495
Uploading products to the Epicenter marketplace (Excel files)
Data Processing
Adaptation of files from product suppliers to the requirements of the marketplace, uploading to the marketplace.
Project:
https://freelancehunt.com/project/dobavit-tovaryi-na-epicentr-cherez-excel/1444766.html
0
623
Organizational chart in Google Sheets
Data Processing
Using Google Charts diagrams inside Google Sheets instead of standard charts.
Project: https://freelancehunt.com/project/stvorennya-organizatsiynoyi-strukturu-google-sheets/1435422.html
0
434
Corrections in the CSV file for the marketplace Allegro.PL
Data Processing
Resolved the client's issues with uploading the product list via CSV file to the Allegro.PL marketplace.
0
319
Work with Google My Maps
Data Processing
Data processing for an article on the website
https://maidan.org.ua/2022/12/what-does-it-mean-to-live-in-piatykhatky-during-the-war/
Data Processing · Databases & SQL
117
0
2 113
Content Management · Data Processing
133
0
5.0
2 078
Data Processing · Lead Generation & Sales
90
0
5.0
1 491
0
618
Analysis of any complexity
Data Processing
Basic settings of GA (Google Analytics)
GTM (Google Tag Manager)
Basic settings of Yandex Metrica
Basic settings for Facebook Analytics
Installation and configuration of the Facebook Pixel
Implementation of Advanced E-Commerce in GA
Basic E-…
480 USD
0
638
Implementation of Extended E-Commerce
Data Processing
Adjusted events:
Products in the catalogue
Click on the goods
Viewing the goods cards
Adding goods to the basket
Steps of ordering
The perfect purchases
Removing goods from the basket
240 USD
1
608
Implementation of Dynamic Remarketing on Facebook
Data Processing
The tasks.
Create and download goods feed to Facebook Business Manager
Installing events on the site (see the product, add to the basket, purchase)
Set up a advertising campaign with the aim of "Sales from the catalogue of goods"
0
447
Sales for the online store
Data Processing
The task. Develop an effective tool for analyzing the activity of the online store
The decision.
A summary table is developed that reflects the turn of sales (transitions to the site - calls - ordered - ordered) in each advertising channel…
60 USD
0
383
Importation of expenses to Google Analytics
Data Processing
Import of advertising campaign costs to Google Analytics for the online store
The task. Calculate the profitability of investment in advertising channels.
Advertising channels .
Targeted Advertising on Facebook
Targeted Advertising on…
Client Management & CRM · Data Processing
77
0
5.0
1 285
Work experience
✔️ Implementation of CRM systems for over 7 years
✔️ In Internet marketing for over 20 years
✔️ In Data science for over 5 years
✔️ Worked in b2b and b2c sectors
✔️ Launched online stores, projects for the sale of goods and services
✔️ Teaching activity since 2005
Technologies ⚒️
✔️ Python
✔️ SQL
✔️ Google Cloud Platform, AWS
✔️ API (webhooks, API connectors)
✔️ Data visualization tools: Looker Studio (Google Data Studio), MS Power BI
SERVICES
ETL, API connectors
✔️ Webhooks
✔️ API connectors (Google Analytics; Google Search Console; Google Ads; Facebook Ads; Tik-tok Ads;…
344 USD
0
618
API connector for storing data from the NetHunt system
Data Processing
Project goal: create a data model for more detailed sales analysis
- creating a connector
- saving data in BigQuery
- data model + Power BI visualization
402 USD
0
581
API connector for save weather data
Data Processing
Project goal: to analyze the impact of weather on sales in a retail network
- creating a connector
- data storage in Google Bigqery
- visualization in Power BI
179 USD
0
578
Facebook API Integration
Data Processing
Download data from the Facebook Ads advertising office
Storage in Google BigQuery
Power BI visualization
Consulting · Data Processing
102
0
5.0
1 242
Data Processing · Databases & SQL
43
0
5.0
1 160
0
817
WEB interface for downloading files based on Google tables
Data Processing
Scenario of work:
The interface receives xlsx files and csv files.
If the file is successfully downloaded, the information message about the successful completion of the script will be displayed / if failure, the error code will be displayed.
The…
0
1 037
Dashboard survey analysis
Data Processing
What was done?
Adaptation and modification of data structure (preparation for reporting)
- Extraction of key indicators (heat map, pie charts, histogram, filters)
Design of the project
0
1 066
CRM based on Google Sheets for the mattress factory
Data Processing
The implementation of the project was done using Google App Script, Formula and SQL.
What was implemented:
Formation and modification of orders
Tracker of orders
Chatbot (Statistics of Order)
Delivery of Production Orders
Control of Payment
0
883
Table and Dashboard for the restaurant
Data Processing
Project for restaurant business.
What was done?
A set of tables that includes:
Imported by R-Keeper
- Storage with an automatic product list (the complexity of the magazine consisted in the fact that one product consists of several under…
0
832
API integration of Binotel with Google tables and Google Data Studio
Data Processing
- API integration of Binotel with Google Sheets
Creating Dashboards in Google Data Studio
Data Processing · Project Management
27
1
4.9
1 051
0
282
Analysis of email mailings
Data Processing
This dashboard is designed for monitoring the effectiveness of email campaigns and allows the marketing team to quickly evaluate the results of mailings, identify trends, and make informed decisions regarding further communication strategy.
Data Processing
72
0
5.0
1 021