4 Homework for macroeconomics

1. Choose a service 2. Configure the service 3. Create a template 4. Upload the database 5. Check functionality and deliverability (and avoid going to SPAM) 6. Send a one-time mailing to 1000+ subscribers please write your financial proposals and deadlines

We are looking for an effective Meta-targeting specialist who can work with complex projects and is responsible for the effectiveness of advertising, not just its launch. Project — recruitment for a vacancy. Direction: attracting quality targeted responses for an office vacancy in Kyiv. Tasks: • launching and managing advertising campaigns in Meta Ads • attracting quality targeted responses for an office vacancy in Kyiv • working with cold audiences and finding new sources of applications • testing creatives, audiences, and advertising combinations • scaling effective campaigns and disabling non-working ones • optimizing the cost of targeted responses and budget • controlling the quality of incoming applications (relevance of candidates, compliance with requirements) • adhering to moderation rules and finding stable solutions for working in complex advertising niches Important: • priority — quality targeted responses, not their quantity • irrelevant applications and non-target traffic are not considered results • systematic low quality of applications will result in termination of cooperation • looking for a specialist with practical experience who can bring quality candidates, not just test basic hypotheses at the expense of the advertising budget Requirements: • confident experience with Meta Ads • experience attracting candidates for vacancies through Meta Ads will be an advantage • ability to work with cold audiences and find new segments • focus on quality targeted responses, not on reach and clicks • experience optimizing advertising campaigns by cost and quality of applications • understanding the specifics of passing moderation and ability to create conversion advertising materials • analytical approach, independence, and responsibility for results Will be a big plus: • experience launching advertising campaigns in gray niches • successful experience attracting candidates for vacancies in Kyiv and the Kyiv region • having cases with quality responses at target cost • ability to quickly find and scale working advertising combinations Payment: • discussed individually

We are looking for a person who has time and is capable of analytical, structured thinking. It is necessary to manage and improve Notion and related documents (Google Docs) for a small marketing team, so that the knowledge base, processes, and important artifacts are not lost, ensuring structure and order. Employment for 2–3 months. It involves approximately 5 hours per week.

Description: We maintain a reporting system for trainings/courses, where each client has a separate Power BI report that retrieves course completion data via the Tovuti LMS API using Power Query (M). One of these reports has started returning a 429 Too Many Requests error, as the query reloads the entire data history each time, and the volume of this history has already exceeded the Tovuti API request limit. Requirements: Rewrite the Power Query so that only new/modified records are loaded during each refresh, using the timestampModifiedAfter parameter in the courseProgresses endpoint (this parameter has been confirmed to exist and work), instead of reloading the entire history. Add retry/backoff logic so that in case of a 429 error, the request pauses and continues working instead of failing with an error. Test the fixes on our actual Tovuti API and confirm that the updates are successful. Briefly document the changes (what and why was changed) so that we can maintain this in the future. Data model context: The report consists of 4 related tables: Teams, Courses, Users, and AssigmentsProgress (fact table pulled from the Tovuti courseProgresses endpoint, linked by teamId, courseId, userId). The AssigmentsProgress table hits the request limit as it grows every time someone starts, takes, or completes a course. Requirements: Confident practical experience with Power Query (M language) and incremental data refresh patterns in Power BI Experience with REST APIs (pagination, date filters, request limits, retry/backoff handling) Ability to read OpenAPI/schema documentation Clear communication in English Outcome: A working, tested Power Query fix integrated into the existing report, with a brief written explanation of the changes. Budget: Fixed price for this task (amount to be discussed based on the proposal)

It is necessary to quickly compile a database of contacts for cosmetologists and cosmetic clinics. Requirements for the result: Format: Excel or Google Sheets. Phone numbers must be in international format, as continuous digits WITHOUT plus signs, spaces, or hyphens (for example: 380**********). Structure: Column A — Clinic name / Name, Column B — Phone number. Volume: at least 200 fresh contacts, without duplicates and empty rows.