Table with formulas for calculation

Task It is necessary to conduct a comprehensive financial analysis of my online stores' activities over the last 3 months and develop a universal pricing model that takes into account all costs and the desired profit level. About the activities I work with several sales channels and suppliers: Prom.ua; Rozetka; dropshipping; own warehouse. It is necessary to analyze the activities of the online stores as a whole, determine the actual cost structure, and based on that, develop a correct markup system. What data I will provide I will provide all necessary information for the last 3 months, including: turnover; number of orders; cost of goods sold; marketplace commissions; advertising expenses; delivery costs; packaging costs; returns; cancellations; employee salaries; rent; taxes; other fixed and variable costs. If necessary, I will provide additional data. What needs to be done Conduct a detailed analysis of all financial indicators. Determine the actual percentage of total costs. Calculate the breakeven point. Determine the actual net profit. Analyze which expense items most affect profitability. Provide recommendations for cost optimization. Develop a clear pricing model. Determine the optimal markup level to achieve the desired profitability. Create a universal formula for calculating the price of goods, so in the future it will be enough to enter the purchase price and automatically receive the recommended selling price. Suggest recommendations for different pricing approaches (fixed markup, markup depending on the product category, minimum margin, competitor prices, etc.) and justify which option will be the most effective in my case. Expected result As a result, I want to receive: a detailed financial analysis; conclusions and recommendations; calculation of the optimal markup; a ready model in Excel or Google Sheets with formulas; the ability to change input parameters (purchase price, desired profit level, commissions, expenses, etc.) and automatically receive a new recommended selling price. Additionally After completing the analysis, an online consultation is required (30–60 minutes), during which the logic of the calculations needs to be explained, how to use the model shown, answer my questions, and provide recommendations for further use of this model. When submitting a proposal, please indicate the cost of the work; the deadline for completion; the cost of the consultation (if paid separately); experience in similar projects in the field of e-commerce, marketplaces, or online stores; examples of similar works (if available).

A specialist in Meta Ads (Facebook and Instagram) is needed to launch and manage an advertising campaign aimed at attracting candidates for a job vacancy in Poland. The work includes: * analyzing the job vacancy; * preparing the advertising campaign; * creating advertising creatives and texts; * setting up the ads; * optimizing the advertising campaigns throughout the month; * analyzing results and making necessary changes. The advertising budget is paid separately directly in the Meta advertising cabinet.

A market analysis of potential clients is required for a creative marketing agency that creates over 5,000 advertising creatives per month for Meta, TikTok, YouTube, AppLovin, and other advertising platforms. Project Goal To identify priority niches and specific companies that regularly need large volumes of advertising video content. The results of the research will be used to build the agency's sales strategy for the next six months. Main Tasks The contractor must: identify 10–15 most promising niches; explain why each niche requires a large number of advertising creatives; identify the main advertising platforms and formats for each niche; find specific companies that actively use performance advertising; justify the selection of each company; determine which services the agency should offer them; create a priority list of companies for contact. Examples of current clients and additional information about the agency will be provided to the selected contractor separately. Niche Analysis ( For each niche, it is necessary to specify (Niches should be divided into three categories: high, medium, and test priority.): main advertising platforms; need for vertical video, UGC, motion design, and AI creatives; frequency of ad updates; need for testing hooks, offers, and variations; Company Search For each priority niche, it is necessary to find companies that: actively run ads on Meta, TikTok, YouTube, or AppLovin; regularly update advertising creatives; operate in multiple countries or with several products; scale user acquisition; may need an external production partner. For each company, it is necessary to specify: website, country, niche, and main products; advertising platforms used; examples or confirmations of advertising activity; why the company needs a large volume of creatives; which service should be offered to them; approximate potential workload; contact priority; relevant decision-makers and links to LinkedIn. Sources The research should be based on current and verified sources: Meta Ads Library, TikTok Creative Center, Google Ads Transparency Center, App Store, Google Play, LinkedIn, company websites, job postings, investment databases, and industry reports. Priority geographies: USA, Canada, UK, Australia, Eastern Europe. Expected Outcome The contractor must provide: A brief analytical report with a ranking of niches. A table with 150–300 potential companies. A separate list of 30–50 companies for the first wave of contacts. Justification for the selection of each priority company. A recommended offer and personalized approach to contact. Recommendations for the order of testing niches over the next six months. The main result of the project is a clear understanding of which niches to develop, which companies to contact first, whom exactly to write to, and which services to offer them. We expect examples of similar research from you (without them, candidates will not be considered) and your wishes regarding the terms.

Task: Development of a marketing strategy for a recreation and wellness complex Goal Increase the number of bookings and profits of the complex by building a comprehensive marketing system. What needs to be done 1. Analysis * analysis of the complex * competitor analysis * target audience analysis * SWOT analysis * identification of strengths and weaknesses 2. Marketing strategy Develop a promotion strategy for: * Google Search * Google Performance Max * Google Display * Facebook * Instagram * TikTok * YouTube * Telegram * Email marketing * SEO * affiliate programs * travel catalogs * OTA (Booking.com etc.) * PR and other customer acquisition channels. For each channel, it is necessary to determine: * goal * budget * expected result * KPI * launch timelines. 3. Content strategy Develop: * content plan for the website; * content plan for Facebook; * content plan for Instagram; * content plan for TikTok; * content plan for YouTube. Determine: * publication frequency; * categories; * topics; * seasonality; * video content; * articles; * photographs; * Reels; * Stories. 4. Website development strategy Determine: * which pages need to be created; * which articles to write; * which categories need to be developed; * SEO strategy; * internal linking; * improving website conversion. 5. Sales funnel Describe the customer journey: * first contact; * introduction to the brand; * interaction; * booking; * repeat booking; * recommendations. 6. Advertising For each advertising channel, it is necessary to determine: * budget; * target audience; * creatives; * offers; * expected cost per lead; * expected cost per booking; * forecast of results. 7. Analytics Set up or describe: * Google Analytics 4; * Google Tag Manager; * Meta Pixel; * call tracking; * booking tracking; * UTM tags; * cross-channel analytics. 8. Financial model Calculate: * CAC (customer acquisition cost); * CPL; * CPA; * ROAS; * ROI; * ROMI; * average check; * LTV; * break-even point of advertising; * acceptable cost per booking. 9. Work plan Build a step-by-step plan for: * 3 months; * 6 months; * 12 months. With indications of: * priorities; * budget; * executors; * KPI. Expected result: Upon completion of the work, a document should be provided that contains: * complete marketing strategy; * step-by-step implementation plan; * financial calculations; * calendar of marketing activities; * return on investment forecast; * recommendations for the team; * recommendations for the advertising budget.

Hello! We are launching a new marketplace and are looking for an experienced team (agency or a cohesive team of freelancers) to take on the full cycle of marketing from scratch: from pre-launch strategy to a stable flow of customers. The tasks are divided into two key areas:1. B2C Direction (Attracting Buyers) Goal: Bring active buyer traffic to our marketplace. Tools: SMM, targeting (Meta/TikTok), contextual advertising (Google Ads), and other effective sources.2. B2B Direction (Attracting Sellers) Goal: Attract sellers (merchants) who will purchase tariffs for trading on our platform. Tools: Google Ads, LinkedIn, Meta Ads, lead generation. Payment Terms for B2B: For this direction, we want to build the work based on PPC / Pay per Client (payment for results). Each tariff successfully purchased by a seller = fixed bonus or % for your team.What needs to be done at the start (Stage 0): Pre-launch Strategy: Plan a marketing strategy to warm up the audience and gather a base (leads) even before the official opening of the platform. Budget Planning: Calculate the necessary marketing budgets and projected customer acquisition cost (CAC/CPL) for both directions. Marketing Moves: Propose creative mechanics for a quick start (promotions, referral programs, special offers for the first sellers).Who we are looking for: A team with experience in promoting marketplaces, E-commerce, or complex B2B/B2C projects. Specialists who can calculate numbers (ROI, ROMI, CPA, CAC) and work with analytics (Google Analytics 4). Those who are ready to work based on KPIs and a results-based payment model (for the B2B segment). Please indicate in your response: Cases in the field of marketplaces or E-commerce (if any). Your working conditions (fixed fee for B2C direction + vision of Pay per Client conditions for B2B). What would you start with in preparation for the Pre-launch stage? We look forward to your proposals!