EXCEL написать формулу

Creation of a Telegram bot for an online course + payment integration Project description I need help launching my first online course. It is necessary to implement: create a Telegram bot for a 7-day course; set up automatic access after payment; integrate a payment system; make a simple landing page (1 page) with a course description and a "Buy" button; automatically redirect the user to the Telegram bot after payment; add the option to join a Telegram channel or support chat; preferably make it so that lessons open by days (1 lesson per day for 7 days).

For our agency Asianworker, we are looking for a person for telephone outreach to construction and logistics companies in Slovakia. Your tasks will include: Simple cold calling (telephone contact) with construction and logistics companies. Finding out if companies need workers (armored personnel, carpenters, concrete workers, welders, etc.) and presenting our services. Delivering completed contacts (warm leads) to us. No complicated recruitment – just pure communication and lead generation. Financial compensation: 10 EUR for each delivered and verified warm lead. 70 EUR for each successfully closed and signed contract with a client. Requirements: Excellent knowledge of the Slovak language (spoken and written). Communicative, pleasant voice, and willingness to work. Own phone/internet and computer. If you are interested, please send us a message and we will send you the details.

I'm looking for a attentive and systematic assistant to manage the client database of a small coffee business. I need help organizing a simple and clear client accounting system. At the initial stage, this could be a well-set-up Google Sheet, Notion, or an inexpensive CRM. I will consider your suggestions for the most convenient and budget-friendly solution. What needs to be considered for each client: name and contact details; source of inquiry, such as advertising, Instagram, recommendation; date of first contact; what the client purchased; which types and flavor profiles of coffee they liked; method of coffee preparation; history and approximate frequency of orders; date of next contact; comments and important details of correspondence. I'm primarily looking for a reasonable and economical solution for a small business, so expensive and complex CRMs are not being considered at this stage. At the first stage, the main focus is on systematizing information and reminders. Later, we can discuss the independent sending of agreed messages to clients.

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.

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