Create a formula in Google Sheets

It is necessary to set up a CRM system and end-to-end analytics for a service company specializing in appliance repair (Appliance Repair, USA).Current Situation Company website SEO Google Ads Google Business Profile (Google Maps) Facebook / Instagram Ads Ringostat Google Analytics 4 CRM Workiz External online booking system Setmore.com Important: we are not looking for an advertising or SEO specialist. All advertising channels are already operational. It is essential to correctly link all systems together.What Needs to Be Done Analyze the current operation scheme of Workiz and existing integrations. Set up or suggest a CRM (if Workiz does not allow for the necessary functionality). Set up end-to-end analytics between advertising sources, Ringostat, CRM, and Google Analytics. Set up automatic lead creation in CRM from all possible sources. Transfer the source of the inquiry to CRM (Google Ads, Organic, Google Maps, Facebook/Instagram, Direct, Referral, etc.). Check the possibility of integrating the external booking system Setmore.com with CRM. Set up reports or a dashboard where you can see: the number of leads from each source; the status of each lead; conversions; the effectiveness of each advertising channel.Expected Result Ultimately, we want to see a complete picture for each inquiry: where the client came from; through which advertising source; whether a lead was automatically created in CRM; the further status of the lead; statistics and conversions for each channel. If Workiz is not suitable for implementing these tasks, we are open to considering a transition to another CRM if the contractor can offer a more suitable solution and carry out its implementation.When Responding, Please Indicate experience in setting up Workiz (or similar CRMs); experience in implementing end-to-end analytics; experience in integrating Ringostat, Google Analytics, Google Ads, and CRM; which CRMs you would recommend for this task (if not Workiz); estimated cost and time for completion.

There is a table with a database (company name, full name of the manager, mobile phone). A total of 750 entries. You need to conduct phone calls with a brief proposal for recruitment services for the specialists they need. A script (or even 2) will be provided to the selected person. Next, update the statuses in the table for each call, and in case of any positive responses, simply inform them that our manager will contact them and explain everything in detail. Please use your own regular Ukrainian mobile number; online telephony is not provided. Call recordings are not needed at this time.

Hello I need to gather contacts of companies in 5 French-speaking regions of Switzerland (Geneva, Vaud, Neuchâtel, Jura, Valais Details - - manufacturing companies and service providers - focus on local companies or international companies that have business in the country - large and medium enterprises or small businesses that have several offices-stores-garages-etc. (any chains) Details 1. manufacturing - any enterprises in the 5 regions of the country (including food products (chocolate, cheese, dairy, and others) 2. services - - transport companies, - cleaning companies (for cleaning - transport (buses, trams, metro), airports, business centers, stores, universities, and other educational places (schools, kindergartens), customs, police - medical institutions (excluding hospitals), - car dealership chains, - sports clubs, - restaurant chains (individual restaurants are not needed), - distributors of cleaning products for businesses or local municipalities, - car wash chains, - hotel chains in this country (one hotel is not needed), - companies that conduct cleaning-washing of yachts on Lake Geneva, The result of the work will be - a table with contacts of the above-mentioned companies (region name, industry, company name, company website, email, phone number, address, company LinkedIn link, 2-3 contacts from the purchasing department (for large and medium companies) and management for small enterprises (including chains) with name, position, email, phone, and LinkedIn links (if available) Evaluation - a minimum of 300 companies for which there is a budget of 3,000 UAH or 10 UAH for each contact I am ready to answer all questions Thank you

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