Iryna Kylivnyk
Offer Iryna work on your next project.
Private message 
Offer work 
Kyiv,
Ukraine
6 months 20 days back
available for hire
on the service 7 months 19 days
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Русский: advanced
English: intermediate
Skills and abilities
Programming
Services
Portfolio
-
E-Commerce Funnel Dashboard (GA4 + BigQuery)
Created an interactive dashboard for analyzing the sales funnel of an online store, which allows marketing teams to quickly assess key metrics and analyze user behavior.
What has been implemented:
- KPI: Sessions, Orders, Purchases, Conversion Rate
- 7-step funnel - from website visit to purchase
… - Segmentation by traffic source, device, language, OS, landing page
- Cleaned and standardized filters → built readable names instead of raw GA4 values
- Added the parameter “Selected Event” to change the key event and analyze conversions to it
- 5+ interactive charts, drill-downs, and time filters
What this means for the business:
- see where users drop out of the funnel
- assess the effectiveness of different traffic sources
- identify problems in UX or payment processes
- make data-driven decisions
SQL query:
https://lnkd.in/gGc3kSG2
-
Project for sales analysis and dashboard creation in Excel.
Processed a raw dataset (≈50,000 rows), conducted cleaning, aggregation, and built an interactive analytical dashboard for an e-commerce clothing store.
What was done:
Structured the data and created several pivot tables.
Built an interactive Sales Analytics Dashboard, which includes:
… - sales and profit dynamics;
- analysis of product model profitability;
- sales distribution by country;
- sales analysis by colors;
- payment structure (cash / credit card / check).
Added filters by product category, date, country, and buyer gender.
Aligned data formats, derived key metrics, built charts and the dashboard in a unified style.
Result: The dashboard allows for a quick assessment of sales effectiveness, model profitability, identification of peak periods, and key profit drivers.
-
Analysis of user behavior in the mobile application in Google Sheets
Databases & SQLCompleted a full cycle of analysis of user data from the mobile application: data cleaning, metric calculation (DAU, WAU, Stickiness, ARPPU, CR to Paid), cohort analysis, and activity forecasting using the FORECAST function. Developed 4 visualizations to display user activity dynamics. Tools: Google Sheets (SUMIF, COUNTIF, VLOOKUP, PIVOT, CHARTS, FORECAST).
-
Comprehensive sales analysis in Google Sheets
Databases & SQL
The project covered the full cycle of sales data analysis (over 20,000 transactions) to assess profitability, dynamics, and customer activity:
- Collection and integration of data from heterogeneous sources (Excel, CSV, GitHub, Wikipedia, other Google Sheets).
- Conducted Data Profiling, removal of duplicates and gaps. Created new analytical columns. Merged customer and transaction data into one table.
- Created Pivot Tables for analysis. Built charts for visualization.
… - Created a final interactive report, set up for dynamic filtering using Slicers, to support quick business decisions.
-
E-commerce analytics in BigQuery and GA4 GitHub #2
Databases & SQLTechnologies: BigQuery, SQL, GA4, GCP
• Building a conversion funnel from session to purchase
• Analyzing the effectiveness of pages and marketing campaigns
• Using arrays, JOIN, and window functions
…
Link No. 2 https://github.com/IrinaKS/ecommerce-analytics-ga4-bigquery/commit/74551bcae43f7e669604f43f791ca9f32c5731df
-
Dashboard in Google Looker Studio: evaluation of advertising campaigns
Databases & SQL
Tools: Looker Studio, SQL, PostgreSQL
• Visualization of key metrics: Ad Spend, CPC, CPM, CTR, ROMI
• Combined charts, heat maps, filters by campaign and date
• Result - assessment of the profitability of marketing activities.
-
Analysis of revenues by products and locations
Databases & SQLTool: Tableau
An interactive dashboard has been created for analyzing revenue by products and locations.
Calculated fields: Total Revenue, Paid Users Count, ARPPU
Global filters: date, location, product
… Charts: revenue dynamics by month; comparison of revenue by products and regions; ARPPU; box plot of transactions.
Result: analytical dashboard for tracking monetization effectiveness and identifying key revenue drivers.
-
Revenue Growth & Cohort Analysis Dashboard
Databases & SQLTool: Tableau
Goal — monitoring the financial dynamics of the subscription business: MRR, revenue changes, cohort analysis of users.
Key elements:
• New MRR Over Time — dynamics of new recurring revenue
… • Total Revenue and Change vs First Month — revenue changes relative to the first month
• Cohort Analysis of User Revenue — cohort analysis of revenue after the first payment
Calculated fields: MRR, Total Revenue, % Change
Global filters: date, payment location
Result: the ability to track revenue trends, user retention, and the effectiveness of the subscription model.
Activity
| Latest proposals 4 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Presentation of data in the form of a report - Google Sheets, Loop, Forms
27 USD
|
|||||
|
Google Maps specialist for the New Year project WOW Christmas Tree
90 USD
|
|||||
|
Transfer of analytics and accounting of business indicators from Google Sheets
45 USD
|
|||||
|
Organization of dynamic linking in Excel between sheets
16 USD
|
