Exporting data from Ahrefs for SEO keyword research

Continuation of the project. Redesign and relaunch of the Brovchak Family Dental Care clinic website 0680006609 http://brovchak-clinic.com.ua/ specifications from SEO expert https://docs.google.com/spreadsheets/d/17_WyPf3XVpzbuBjpJ7MNFs12QUL-aHv7iIbKudY-IEw/edit?gid=0#gid=0 https://miro.com/app/board/uXjVHXxFvIE=/About the project A complete redesign of the existing dental clinic website is required based on the ready prototype in Miro. The result should include: UI/UX design responsive layout WordPress integration SEO-safe relaunch technical optimization analytics setup the ability for easy self-editing of content It is critically important: the website must not only look modern but also improve business metrics and not lose current SEO positions.Business goals of the project The redesign is being carried out to: increase the number of inquiries from the website; improve the conversion of booking forms; enhance trust in the clinic; demonstrate the expertise of the doctors; present complex clinical cases; form a premium positioning; increase the number of inquiries for implants, orthopedics, and comprehensive treatment.Visual conceptPositioning Premium author dentistry. Not a chain clinic. Not a mass flow of patients. Individual approach, predictable results, and complex clinical solutions.The emotion the website should evoke "Here, not just dentists work. Here, a team of experts creates long-term and predictable solutions, paying attention to every detail."Style Workshop / Dental Atelier. Author's dentistry. Premium minimalism. Focus on: microscopy; navigational implantation; digital scanning; gnathology; complex rehabilitations. Use: large professional photos of doctors; photos of doctors at work; real patient cases; photos of the clinic. Minimize or completely exclude: stock photos; template dental images; typical design solutions of chain clinics.SEO and relaunch Critical requirement: The redesign must not lead to a significant drop in organic traffic. It is necessary to: preserve the SEO structure of the website; preserve or correctly transfer URLs; set up 301 redirects; transfer all meta tags; preserve page indexing; check robots.txt; check sitemap.xml; check canonical; check schema.org; perform an SEO audit before and after the launch.KPI SEO Permissible drop in organic traffic after launch: no more than 10%. Preference will be given to performers who have successful cases of SEO-safe migrations.UX and conversion The website must provide: quick access to booking a consultation; clear service structure; simple navigation; mobile convenience; quick contact with the clinic. Anticipate: CTA blocks; booking forms; quick call; messengers; trust blocks; video testimonials; treatment cases.Technical requirementsSpeed Google PageSpeed: Desktop — 90+ Mobile — 95+ Core Web Vitals must meet Google's recommendations.Optimization It is necessary to: optimize CSS; optimize JS; set up caching; optimize images; use WebP; minimize third-party scripts.Code quality Important: clean code; absence of unnecessary plugins; use of WordPress's built-in capabilities and theme; compatibility with future WordPress updates.AI assistant (agent) A solution for implementing an AI consultant needs to be proposed. Desired functionality: answers to typical questions; booking a consultation; integration with Telegram; integration with Instagram Direct; integration with Facebook Messenger; integration with Viber; transfer leads to CRM or administrators, or to a Telegram bot Please describe the proposed solution separately.Work result The output should include: New website design. Responsive layout. SEO-safe launch. Optimized code. Configured analytics. Administrator instructions. Warranty support after launch. Implementation of AI Search and AI output Within the project, a separate set of works is required to prepare the website for Google AI Overviews, AI Mode, ChatGPT, Gemini, Perplexity, Copilot, and other AI search engines. The work includes: Designing the entity map of the clinic: organization, branches, doctors, services, cases, articles, FAQ, videos, and prices. Creating logical connections between: doctors and services; services and cases; services and FAQ; articles and authors; branches and available treatment directions. Implementing structured data JSON-LD: Organization; MedicalClinic / Dentist; LocalBusiness; Person; ProfilePage; Service; MedicalProcedure — where semantically correct; Article / BlogPosting; VideoObject; FAQPage; BreadcrumbList; WebSite; WebPage; ImageObject. Creating structured content types in WordPress: services; doctors; cases; articles; FAQ; videos; branches; prices. Implementing ACF connections between content types and automatic generation of schema.org from approved fields. Building FAQ in three levels: FAQ on service pages; separate expert decision-guide pages; general patient question center. Ensuring the accessibility of main content in HTML without dependence on client-side JavaScript, images, or PDF. Implementing authorship of medical content: author; medical reviewer; publication date; update date; link to the doctor's profile. Adding transcripts to expert videos and linking videos with services, doctors, and cases. Checking robots.txt, sitemap.xml, canonical, noindex, snippet controls, and site accessibility for search and AI crawlers. Setting up tracking of AI traffic: separate channel group in GA4; referrer sources ChatGPT, Perplexity, Gemini, Copilot, Claude; transferring the source to CRM and Telegram applications; report in Looker Studio; accounting for self-reported attribution from patients. Creating a basic set of queries for regular monitoring of the clinic's visibility in AI output. Checking structured data through Rich Results Test and Schema Markup Validator. Preparing instructions for the administrator: how to add FAQ; how to create a case; how to specify the author; how to update the medical review date; how to add video and transcript; how to link material with service and doctor. other.

Looking for an experienced specialist who has real successful experience in promoting books on Amazon, preferably in the Cookbooks / Food & Drink category. Main Task Develop and implement a promotion strategy for cookbooks to increase: organic sales; positions in Amazon search results; the number of quality reviews (only by legal methods); overall visibility of books on Amazon. Experience Required When responding, please indicate: experience specifically with Amazon KDP; examples of successfully promoted books; categories you have worked with; what results you have achieved (sales growth, BSR, number of reviews, keyword positions, etc.); what tools you used. Necessary Competencies The specialist must have a good understanding of: Amazon ranking algorithms; SEO for Amazon; selection and analysis of high-converting keywords; optimization of book listings; Amazon categories; Amazon Ads (Sponsored Products); external traffic; ARC campaigns; legal ways to obtain reviews; competitor analysis; working with analytical services (Helium 10, Publisher Rocket, DataDive, KDSPY, Book Bolt, etc.). Desirable Experience working with: cookbooks; healthy eating books; recipes; diet cookbook; Mediterranean Diet; Air Fryer Cookbook; Anti-Inflammatory Cookbook. Tasks That May Be Included in the Work full book audit; competitor analysis; development of a promotion strategy; keyword optimization; metadata optimization; cover recommendations; A+ Content recommendations; setting up and managing Amazon Ads campaigns; external promotion recommendations; effectiveness analysis and strategy adjustment. Important Only interested in promotion using white hat methods that fully comply with Amazon's rules. Proposals related to: buying reviews; manipulating ratings; artificially increasing sales; any other methods that violate Amazon's rules will not be considered. Please Indicate in Your Response Your experience in promoting books on Amazon. Which categories you promoted. What results you can confirm. What tools you use. What you would do to promote a new cookbook. Your service fees. Work format (one-time consultation, audit, support, advertising management, comprehensive promotion). Preference will be given to specialists who can show real cases with measurable results.

Types of Terms of Reference. (For details, please contact personally) Stage 1: Initial Audit and Analysis Competitor Analysis: Identifying niche leaders, analyzing their structure and traffic sources. Technical Site Audit: Finding indexing errors, duplicates, checking loading speed. Current Visibility Analysis: Determining the keywords by which the site is already found. Stage 2: Semantic Core and Structure Semantic Collection: Clustering high-, medium-, and low-frequency queries. Structure Expansion: Creating a map of new landing pages (categories, services, tags). Linking Design: Setting up internal links between pages for weight distribution. Stage 3: Internal (On-Page) Optimization Meta Tags: Writing unique Title, Description, and H1-H3 headings for all pages. Content Plan: Creating a Terms of Reference for the copywriter to write SEO texts and blog articles. Image Optimization: Compressing files, filling in Alt attributes. Stage 4: Technical Optimization Site Speed: Optimizing Core Web Vitals metrics (LCP, INP, CLS). Responsiveness: Checking the correctness of display on mobile devices. Configuration Files: Adjusting robots.txt, generating an up-to-date sitemap.xml. Microdata: Implementing Schema.org (Product, Article, LocalBusiness, FAQ). Stage 5: External (Off-Page) Optimization

Comprehensive content filling and promotion of the website https://www.bouwmaster.nl/en is required according to the technical specifications. The website is currently in the final stages of development and requires highly competent optimization, content filling, and promotion, in full coordination with the programmer. Please describe the results I will achieve as a result of your work (monthly) for the next 3 months and the cost of this work.

There was a SEO optimization of the website (we will discuss in more detail what exactly was done) I am looking for a person who will be engaged in promoting the website in the SEO search engine results