Oleksandr Timchenko
Offer Oleksandr work on your next project.
Rating
Language proficiency level
Portfolio
-
Processing advertising data in Excel with automatic metric calculations
Accounting ServicesTask: Conducted data analysis from 5 advertising campaigns.
What has been done:
• Collected and structured data: dates, impressions, clicks, CTR, CPC, expenses, conversions, CPA, ROI.
… • Calculated key metrics for each campaign:
- CTR (click-through rate)
- CPC (cost per click)
- CPA (cost per conversion with a fixed payout of $50 per conversion)
- ROI (return on investment)
• Calculated summary values:
- Total expenses: $1361.96
- Total profit: $1998.04
- Net ROI: 146.0%
Tools used:
• Microsoft Excel: formulas, pivot tables, conditional formatting, automatic calculations.
Result: The client received a clear table with analytics showing which campaigns were profitable and which needed optimization.
Ready to perform similar tasks: data parsing, advertising analysis (Facebook, Google Ads, TikTok, etc.), calculation of ROI/CPA/ROMI, creation of reports and dashboards in Excel.