Creating letters in the UNICEF office

Task: Invitation of contacts to the Viber group There is a database of contacts in Google Sheets. It is necessary to organize the addition/invitation of these people to our Viber group. What needs to be done: Gain access to the Google Sheet with contacts. Check the database: remove duplicates, incorrect numbers, and empty rows. Prepare the contacts for work in the correct number format. Set up or check the Viber group: name, avatar, description, invitation link, administrator rights. Organize the invitation of contacts to the group in such a way that there is no risk of blocking or negative consequences for our Viber group. It is preferable not to add everyone at once, but to work step by step. After completion, provide a report: how many contacts were in the database, how many were processed, how many were invited/added, how many people joined the group. Main condition: It is necessary not just to process the database, but to do it as carefully as possible so that the Viber group remains active and without blocks.

I am looking for an experienced Klaviyo specialist who can conduct an audit of my account and develop a long-term email marketing strategy. I need not just a performer who knows how to create newsletters and automations. I am looking for a strategic-level specialist who understands well: • CRM marketing in eCommerce • customer lifecycle • customer retention • repeat sales • increasing LTV • audience segmentation • personalization • revenue growth through email marketing About the Company Earth Lab is a small brand of handmade natural cosmetics. Sales are conducted through Shopify. All email marketing operates through Klaviyo. My goal is to turn Klaviyo into one of the main channels for business growth.What Needs to Be Done1. Comprehensive Klaviyo Account Audit Conduct a full audit of the account and provide a detailed report. It is necessary to evaluate: • audience segmentation; • existing lists and segments; • automations; • email flows; • performance metrics; • email deliverability; • sending settings; • analytics system; • strengths of the account; • weaknesses; • missed opportunities. Based on the audit, a list of all identified issues, recommendations for their resolution, and prioritization of implementing changes must be provided.2. Analysis of Existing Automations For each existing Flow, it is necessary to provide: • what works well; • what works insufficiently effectively; • what opportunities are missed; • what needs to be changed; • recommendations for improvement; If there are any important automations missing, it should be indicated what should be created and why.3. Identifying Growth Opportunities Identify all potential areas for development. For example: • increasing repeat purchases; • increasing average order value; • increasing customer lifetime value (LTV); • increasing the number of reviews; • enhancing customer engagement; • reducing churn; • increasing conversion; 4. 12-Month Klaviyo Development Plan Develop a detailed roadmap for account development. For each month, it is necessary to define: • tasks; • necessary improvements; • new automations; • new segments; I want to receive a clear step-by-step development plan for the next 12 months.5. Annual Email Marketing Calendar Develop a mailing calendar for the entire year. It should include: • regular weekly campaigns; • seasonal promotions; • public holidays; • marketing events; • educational content; • brand letters; • ingredient letters; • product letters; • customer reviews; • promotional campaigns; • new product launches.6. Subscriber Growth Strategy Analyze existing methods of attracting subscribers and propose new ideas. 7. Implementation of Strategy and Support In addition to conducting the audit and developing the strategy, I am interested in long-term cooperation. I am considering the possibility of working together over the next 12 months to implement the developed strategy. Responsibilities may include: • implementing recommendations prepared during the audit; • creating and optimizing automations; • developing and launching email campaigns; • implementing the annual mailing calendar; • optimizing segmentation; • enhancing personalization; • monthly analysis of results; • adjusting the strategy based on the data obtained; • finding new growth opportunities. It is important for me to find a specialist who can not only develop a strategy but also help implement it consistently in practice.

A system for migrating users from the existing database to a single closed Telegram group needs to be implemented. I already have a user database that contains the following variable data: Telegram username; Telegram ID. Important: I understand that Telegram may not allow forcibly adding a user to the group solely by username or Telegram ID. Therefore, a technically correct migration scenario needs to be implemented: through an invite link, join request, verification bot, or another reliable mechanism that does not violate Telegram's restrictions.

Hello! I need to do an email newsletter for the existing email database. I also need help with the design of the letter, possibly advice on its formatting. In your bid, please indicate the cost of your work for a certain number of sent letters, as well as for the design of the letter.

It is necessary to set up a connection of tools for automated (or semi-automated) client search on Instagram, database collection, and initial contact. Target audience (TA): Commercial Instagram profiles in Ukraine (niches: clothing, textiles, bedding, manufacturers) that do not have a link to their own website in the profile header (or only have links to messengers/Linktree).️ TECHNICAL REQUIREMENTS FOR IMPLEMENTATIONStage 1. Parsing and database formation (Contact collection) It is necessary to collect a database of active Instagram accounts based on specified criteria. Sources/Geo: Ukraine (search by keywords in bio: bedding, textiles, clothing, manufacturer, robes, etc.). Filtering criteria (Mandatory): The account is active (there are stories or posts in the last 7 days). Absence of a website: the website field is empty or has a link to lead forms/messengers. Accounts with ready-made online stores (on domains .ua, .com.ua, shopify, etc.) should be automatically filtered out. Export format: Google Sheets table with fields: Account link, Name, Number of subscribers, Keyword, Contacts (if available in the description).Stage 2. Automation of messaging (Security blocks and AI) Since Instagram strictly blocks for spam, direct mass messaging is not suitable. It is necessary to implement a two-step system ("Greeting ➡️ Client response ➡️ Offer"). Working algorithm: System of working accounts: Set up work through 2–3 additional technical profiles (donors/satellites), using quality mobile proxies to avoid compromising the main brand. Step 1 (First touch): Send a simple, safe request without links (for example: "Good day! Could you please tell me, do you accept orders?" or "Good day! Do you have your own production?"). Text randomization: Set up a list of synonyms and delays (pauses) between messages so that actions appear human-like. Limit — up to 25 "cold" messages per day from one account. Step 2 (AI/Script integration): Once the client responds to Step 1, the dialogue becomes "warm". It is necessary to set up a tool (via ManyChat, related services, or API) that will automatically send a short structured offer with a link to our portfolio. The offer should adapt to the client's niche (for example, for a textile manufacturer — one text, for a clothing store — another).Stage 3. Lead notifications When the client shows interest (asks for price, terms, or agrees to a call), the system should immediately send a notification to me in the Telegram channel/bot with a link to the dialogue so that I can quickly connect and close the deal on the call.