Собрать базу предприятий по отрасли и сделать email рассылку

Translate 3 funnels (flows) into Hebrew, format them, and implement them on the website. Set up the system so that clients from Israel are automatically added to the mailing lists in Hebrew. Create a group (segment) for sending campaigns in Hebrew (including those who subscribed for a 10% discount and those who made a purchase).

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.