Bases in SQL format to formatting under the Google Email Template CSV Segment

I'm looking for an experienced email marketer with experience in Klaviyo for long-term collaboration. In the future, I need a specialist who can conduct a deep audit of the Klaviyo account, develop a CRM/email strategy for 6 months, and, if necessary, support the project. However, before entrusting a large task, I want to assess the specialist's approach to analysis and recommendations development. Therefore, I propose a small paid test assignment. About the project Earth Lab is a boutique brand of natural cosmetics and handmade natural deodorants. Sales are conducted through Shopify. Currently, the brand has a small subscriber base, so the test assignment will not require a large volume of work. Test assignment A quick audit of my Klaviyo account is needed, along with a brief document summarizing the findings. The result of the work should include: the strengths of the current account; main problems and growth points; 5–10 most important recommendations; priorities: what needs to be done first and why; a brief plan for the first steps in developing email marketing. I value not the volume of the report, but the depth of analysis, the logic of recommendations, and strategic thinking. This test assignment is the first stage of selecting a specialist. If the quality of work and approach suit me, the next stage will be a full audit of Klaviyo, the development of a CRM/email strategy for 6 months, and possibly further long-term collaboration.

I am looking for a specialist in B2B email lead generation / cold outreach who deeply understands the outbound sales system to conduct an audit of the email campaigns carried out. Field: architectural visualization services for developers in Canada and Australia. Work format: An audit + consultation is needed. I will provide examples of emails, campaign statistics, contact databases/structure, and all necessary information. Before providing the output files, an NDA will need to be signed. Analysis needed: — email message templates used in the mailings; — structure of the emails, subjects, CTAs, personalization, tone of communication; — contact databases to which the mailing was sent; — possible mistakes that could have led to low open rates, reply rates, or weak conversions; — overall outreach strategy for B2B clients in the real estate and development sector. I expect the specialist to: — indicate what was done well and what needs to be changed; — find weaknesses in the email templates and contact databases; — provide specific recommendations for improving responses and attracting new clients; — suggest how to better build communication with development companies; — help formulate an improved email template or structure for a new campaign; — give recommendations on choosing and setting up infrastructure for future email campaigns to prevent emails from going to spam; Requirements: — experience working with the markets of Canada, the USA, and Australia; — experience and understanding of the specifics of the creative B2B services market in architecture and development; In your response, please briefly write: - whether you have relevant cases - the cost of the audit - the cost of the consultation I am looking for not just general advice, but an experienced specialist who can thoroughly analyze the conducted campaigns and provide practical steps to improve the reply rate and attract new B2B clients.

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.

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.