
Closed
Posted
Paid on delivery
Build an integration between: Website → Kommo CRM → [login to view URL] → Google Sheets → Google Ads The purpose of this integration is to track actual closed sales as Offline Conversions / Enhanced Conversions for Leads in Google Ads and attribute each completed sale to the original Google Ads click. Workflow 1. Capture Click Data from the Website When a visitor lands on the website through a Google Ads campaign, the website must capture and store: GCLID Customer information Phone number Email address, if available Lead creation date and time This information must be passed when the customer submits the website lead form. 2. Store Data in Kommo CRM When a Lead or Deal is created in Kommo, the following information must be stored: Lead / Deal ID GCLID Customer name Phone number Email address Lead creation date Lead source A custom field must be created in Kommo to store the GCLID and keep it linked to the deal until the deal is closed. 3. Phone Number Processing Before the phone number is used for Google Ads conversion data, the integration must normalize it according to Google Ads requirements. All phone numbers must be converted to the: E.164 format The required format is: +[Country Code][Phone Number] Example: +971501234567 The phone number must not contain: Spaces Hyphens Parentheses Unnecessary symbols The system must also ensure that the correct country code is added. For example, if the customer enters a local UAE number: 050 123 4567 It must be converted to: +971501234567 The phone number normalization process should be handled within [login to view URL] or at the appropriate stage before preparing the Google Ads conversion record. If hashed customer data is required for Google Ads Enhanced Conversions, the normalized phone number must be prepared using: SHA-256 according to Google Ads requirements. 4. Send Data to Google Sheets [login to view URL] should create or update a dedicated row for each Lead inside Google Sheets. Each record should contain: Kommo Lead ID Kommo Deal ID GCLID Customer name Original phone number Normalized phone number in E.164 format Email address Lead creation date Deal status Deal value Currency Conversion Date & Time Google Ads conversion upload status It is recommended to keep both the original phone number and the normalized phone number for troubleshooting and data validation purposes. 5. When the Deal Is Closed When a deal inside Kommo changes to: Won / Closed Won / Successful [login to view URL] should detect the status change and retrieve the following data: GCLID Phone number Email address, if available Deal value Currency Deal closing date and time Kommo Deal ID The corresponding row in Google Sheets must then be updated. 6. Prepare the Google Ads Conversion Data The system must prepare all required conversion data for Google Ads, including: GCLID Conversion Action Conversion Date & Time Conversion Value Currency Phone number in a Google Ads-compatible format Email address, if available Deal ID The: Conversion Date & Time must represent the actual date and time when the deal was closed or the sale occurred, not the date and time when the ad click happened. 7. Prevent Duplicate Conversions The system must include a mechanism to prevent the same deal from being sent to Google Ads more than once. The: Kommo Deal ID can be used as the unique deal identifier. A dedicated Google Sheets field such as: Conversion Sent can also be created. After a conversion is successfully sent to Google Ads, the value should be changed to: YES This will prevent duplicate conversion uploads. Final Data Flow The complete workflow should be: Google Ads Click ↓ Capture GCLID ↓ Website Lead Form ↓ Phone Number + Customer Data + GCLID ↓ Kommo CRM ↓ Store GCLID with the Lead / Deal ↓ [login to view URL] ↓ Normalize Phone Number to E.164 ↓ Google Sheets ↓ Wait for Deal Closure ↓ Kommo Deal = Won ↓ Deal Value + Sale Date & Time + Customer Data ↓ Google Ads ↓ Offline Conversion / Enhanced Conversion for Leads Expected Result The final objective is to allow Google Ads to identify which advertising click resulted in an actual completed sale. Google Ads should receive the real conversion value and the actual conversion date and time, allowing the advertising account to use real sales data for: Conversion tracking Revenue attribution Campaign optimization Smart Bidding ROAS optimization Important Technical Requirement The implementation must not simply send the phone number as entered by the customer. The developer must specifically implement: Normalize the phone number to E.164 format before preparing the Google Ads conversion record. The system should also retain and use the following customer identifiers whenever available: GCLID + Phone Number + Email Address This will provide stronger conversion matching and attribution than relying on GCLID alone.
Project ID: 40631991
168 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, As an experienced developer and the founder of A4Logic with 15+ years in the field, I have built numerous quality AI and automation solutions for various businesses. With a deep understanding of WordPress, Shopify, Laravel, React, Python, and more, I can confidently say that integrating your complex workflow from your website to Kommo CRM and [login to view URL] to Google Sheets and Google Ads is right up my alley. For your specific project needs like capturing GCLID, normalizing phone numbers in E.164 format, preparing data for Google Ads conversions, and preventing duplicate conversion uploads, I have the expertise to handle each step precisely and efficiently. My technology stack including Node.js, MySQL, [login to view URL] and others align well with your project requirements making me explicit choice for this task. I am also a strong advocate for clean coding and consistent communication; these principles guide my work ethic. Above all, I understand the importance of client satisfaction and believe in delivering not just a product but peace of mind. Together, we can build a seamless integration solution that fulfills all your business needs and brings you measurable results in terms of improved sales tracking through Google Ads campaign. Thanks!
$130 USD in 2 days
8.6
8.6
168 freelancers are bidding on average $154 USD for this job

Hi, I checked your "Kommo–Google Ads Integration Setup" project description, it looks like the focus is on delivering a clean, responsive website that works well across all devices. I prefer understanding the expected layout and user experience first, then building pages that closely match the design while keeping the code organized and easy to maintain. Feel free to share the design or current website, and I'll suggest the best implementation along with a realistic timeline. Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
$98 USD in 4 days
7.7
7.7

Hello, I can build this complete Google Ads offline conversion tracking system, connecting your website, Kommo CRM, n8n, Google Sheets, and Google Ads so every closed deal can be accurately attributed back to the original Google Ads click. I have hands-on experience with Kommo CRM, n8n automation, Google Ads integrations, APIs, webhooks, and lead tracking workflows. I can implement GCLID capture and persistence, store it against the correct Kommo Lead/Deal, detect when a deal becomes Won, normalize phone numbers to E.164 format, prepare customer identifiers with SHA-256 hashing where required, update Google Sheets, and upload the actual closed-sale conversion to Google Ads with the correct conversion value and sale date/time. I can deliver this as a reliable, production-ready workflow with clear tracking and troubleshooting visibility. Let’s get on a call to discuss the project in more detail. Best regards,
$250 USD in 7 days
6.6
6.6

Hi, I'm interested in your requirements. I have rich experience in web development using PHP, Python, JavaScript, jQuery & MySQL - Codeigniter & Laravel Let's have a chat for more details. Thanks!
$500 USD in 5 days
5.7
5.7

Hi, I can help you with this project. I have relevant experience with PHP, JavaScript, Software Architecture, MySQL and can handle the work from development to testing and delivery. I've reviewed your requirements and can provide a clean, reliable, and responsive solution. Let's discuss the details and get started. Best, Arslan Shahid
$30 USD in 7 days
5.9
5.9

Hello Dear! Good Day! Hope you are doing fine. This is Ruhul Ajom Sagor. I am an expert "Web Developer" with 10+ years of working experience in PHP, HTML5, CSS3, JavaScript, jQuery, Bootstrap, MySql and different Frameworks. I have completed my B.S.C Engineering in Computer Science and Engineering (CSE) from BUET. Hire me and you don't have to worry about your website problems again! I'll add value to your projects by creating astonishing designs and code with high impact and optimized user interaction that leads to bigger conversions. WHAT PROBLEMS CAN I HELP YOU SOLVE? • Custom Websites Using PHP and Frameworks • e-Commerce Websites (Woo-Commerce and Shopify) • Custom WordPress themes • On-Page and Off-Page SEO • WordPress themes Customization • Database Modeling/Development • WordPress migrations and upgrades • Responsive Coding (Make your website compatible with: smartphones, tablets, desktops) • Websites speed and loading time improvements • Cross-browser compatibility • PSD to HTML to WordPress conversion • HTML5/CSS3/jQuery websites based on Bootstrap I love challenges, talking to my clients, and meeting others’ standards as well as expectations. I will be discussing everything in detail, giving my full advice and delivering through best of my skills. You are cordially welcome to discuss your project. Thank You! Best Regards, Ruhul Ajom
$50 USD in 3 days
5.5
5.5

The key is to preserve attribution from the original form submission and upload each won deal only once. I would map GCLID and customer fields into Kommo, normalise phone numbers with an explicit country rule, then use Make to update the sheet and submit the closed-sale timestamp/value. Upload status would be recorded only after confirmation, with retries and a deal-ID deduplication check. My quote covers one website form, one Kommo pipeline and one conversion action, assuming the necessary account/API access. I would also check consent and identifier handling before uploads. Which form system and Google Ads connection are already configured?
$300 USD in 7 days
4.7
4.7

Hello, I have thoroughly reviewed the project description for the Kommo–Google Ads Integration Setup. My approach will involve capturing click data from the website, storing information in Kommo CRM, normalizing phone numbers to the E.164 format, sending data to Google Sheets, and preparing Google Ads conversion data. I will ensure smooth communication during United Kingdom's time for effective collaboration. For this project, my expertise in API Integration, MySQL, and PHP will be crucial in implementing the required workflows seamlessly. I will focus on root-cause fixes, safe implementation, and thorough testing to ensure the integration works flawlessly. Deliverables will include a fully integrated system that accurately tracks closed sales as Offline Conversions in Google Ads. I am confident in delivering a solution that meets your objectives effectively. Best regards, Jamila
$140 USD in 4 days
3.6
3.6

Hello, The primary goal of the Kommo-Google Ads Integration Setup is to accurately track closed sales as Offline Conversions for Leads in Google Ads, attributing each sale to the original Google Ads click. To achieve this, the workflow involves capturing click data from the website, storing information in Kommo CRM, normalizing phone numbers to E.164 format, sending data to Google Sheets, and preparing Google Ads conversion data. Notably, the system must prevent duplicate conversions and ensure accurate conversion data is provided to Google Ads. In approaching this project, I would begin by reviewing the existing systems and data flow to understand the integration points and potential challenges. Implementing a staged environment for changes and validations would be crucial to maintaining system stability. Previous experience with similar CRM integrations and data normalization processes will be beneficial for ensuring a smooth implementation. A few questions: - Are there any specific requirements or restrictions regarding the Google Ads account setup? - Do you have any preferences for the tools or technologies to be used for this integration? Best regards,
$100 USD in 2 days
3.8
3.8

Hello, Your workflow and requirements are well structured, and I can help implement an end-to-end solution that accurately attributes closed sales back to the original Google Ads click. I have experience with Google Ads, GA4, GTM, Enhanced Conversions, offline conversion tracking, Google Sheets, and marketing automation, ensuring GCLIDs, customer identifiers, and conversion data are captured, validated, and transmitted correctly for reliable attribution and Smart Bidding optimization. I'll build the integration to store GCLIDs within Kommo, normalize phone numbers to E.164 format, prepare customer identifiers for Enhanced Conversions, prevent duplicate uploads, and ensure Google Ads receives the correct conversion value and actual sale date. I'll also thoroughly test the workflow and provide a reliable implementation with clear documentation. Best regards, Aklima Khatun
$90 USD in 7 days
3.5
3.5

Hello, Hope you’re doing well. I’m Rajkumari, a Google Ads Specialist at GClickWebTech, helping businesses increase leads, sales, and ROI through full-service Google Ads management. Full Google Ads Services- ▪️ Campaign setup: Search, Display, Shopping, YouTube, PMax ▪️ Keyword research & strategy for high-intent terms ▪️ Engaging ad copy & creatives to drive conversions ▪️ Bid management & optimization for efficient spend ▪️ Conversion tracking with GA4 & GTM ▪️ Performance analysis and actionable reports Why Choose GClickWebTech- We focus on data-driven campaigns, ethical practices, and measurable results, ensuring your ad budget works effectively for your business goals. Let’s connect via chat to discuss a customized Google Ads strategy for your business. Regards, Rajkumari Google Ads Specialist, GClickWebTech
$30 USD in 30 days
2.8
2.8

Hello, ✔️ I understand that integrating your website with Kommo CRM and Google Ads is crucial for accurately tracking offline conversions and attributing sales effectively. Ensuring that GCLID and customer data flow seamlessly through this process can be complex and prone to errors if not handled carefully. My approach involves a meticulous setup that captures click data, normalizes phone numbers, and efficiently updates Google Sheets while preventing duplicate conversions. By implementing these processes, we can ensure that Google Ads receives accurate conversion data tied to your advertising efforts, enhancing your campaign's optimization and overall ROI. With a strong track record of 5-star ratings, I prioritize clear communication and fast response times, aiming for long-term partnerships that drive results. What specific features or outcomes are you most interested in discussing further? Best, Kurt
$100 USD in 7 days
1.6
1.6

Hi, I read your project carefully and I can deliver exactly what you need. I can start immediately and show you the first preview in a few hours. Let’s discuss the details.
$67 USD in 7 days
0.6
0.6

I am excited to propose my services for the Kommo–Google Ads Integration Setup. With extensive experience in similar projects, I have successfully integrated systems to track conversions and enhance data accuracy. My recent work involved creating seamless workflows between CRMs and advertising platforms, ensuring all required data is captured and formatted correctly. I am confident that my skills in data normalization and conversion tracking will provide you with a robust solution. Thank you for considering my proposal. Best, Tegan
$200 USD in 7 days
0.7
0.7

Hello, I read through your project description for the Kommo-Google Ads Integration Setup and I am excited about the opportunity to work on this project. My name is Nathan Wilkins, and I have over 10 years of experience in PHP, JavaScript, and MySQL, which align well with the requirements of this integration. To complete this project, I plan to first capture the necessary click data from the website and store it in the Kommo CRM. I will then ensure the phone numbers are normalized to the E.164 format before sending the data to Google Sheets. Once a deal is closed in Kommo, I will prepare the Google Ads conversion data and prevent duplicate conversions using unique identifiers. I would love to discuss the project details further with you. Please feel free to reach out so we can review the scope and determine the next steps. Regards, Nathan Wilkins
$250 USD in 7 days
0.0
0.0

We recently helped a business achieve a similar goal, and the results exceeded their expectations. I'd love to help you do the same. I'll build a solution that's reliable, professional, and designed to help your business grow. Your project stood out because you're focused on creating a seamless integration for tracking closed sales as Offline Conversions in Google Ads. This is exactly the kind of work I excel at. With 75+ 5-star reviews on similar projects, I rank in the top 1% among 75 million users! I will ensure the integration captures all necessary data, normalizes phone numbers, and prevents duplicate conversions while maintaining data integrity throughout the process. I'd be happy to share a few ideas for your project and answer any questions you have. Regards, VutomiM1
$150 USD in 7 days
0.0
0.0

We've recently helped a similar service business streamline their data tracking and improve their conversion attribution. I can assist you in building a seamless integration that captures and processes leads effectively. Your project emphasizes the importance of clean, professional, user-friendly systems that ensure accurate conversion tracking and data normalization. Our expertise includes CRM integrations, data management, and automated workflows. Although we are still building our portfolio on freelancer.com, we have numerous 5-star reviews on similar projects on other platforms. It would be our privilege to help with your project. Choosing us is a decision you won’t regret. There's no pressure at all. Best case, we create something great together. Worst case, you get a free consultation and a clearer direction for your project. Regards, Henco Burger.
$100 USD in 7 days
0.0
0.0

⚠️ **IF YOU’RE NOT HAPPY, YOU DON’T PAY.** ⚠️ I have successfully assisted clients in creating seamless integrations between CRM systems and Google Ads, ensuring accurate tracking of conversions and effective data management. I can help you build this robust integration, capturing GCLID, customer information, and normalizing phone numbers to E.164 format for accurate conversion tracking. My focus is on delivering a clean, user-friendly, and automated workflow that meets your specific needs. I understand the importance of ensuring data integrity and preventing duplicate conversions, which is key to your project's success. If you'd like to see examples of my previous work in CRM and Google Ads integrations, please feel free to message me. Looking forward to discussing your project in detail! Regards, Daniel
$150 USD in 7 days
0.0
0.0

The integration you're looking to build is crucial for accurately tracking conversions from your Google Ads campaigns. By capturing essential data from your website and integrating it effectively with Kommo, you can streamline your sales attribution process, allowing for precise revenue tracking and campaign optimization. I noticed your focus on normalizing phone numbers to the E.164 format and preventing duplicate conversions. These steps are vital for ensuring data integrity and compliance with Google Ads requirements. I understand the nuances involved in maintaining accurate records throughout the entire flow from GCLID capture to conversion reporting. We have 75+ 5-star reviews on similar projects and rank in the top 1% among more than 75 million Freelancer users. My experience with CRM integrations and Google Ads systems positions me well to assist with this project. I’m here to share insights or strategies that could enhance your integration. I look forward to discussing your vision further. Regards, Stephen
$200 USD in 7 days
0.0
0.0

I help businesses streamline operations, eliminate repetitive tasks, and build digital solutions that improve efficiency, productivity, and customer experience. I am excited to propose a comprehensive solution for the **Kommo–Google Ads Integration Setup**. This integration will enable your business to accurately track offline conversions and improve revenue attribution from Google Ads. **My Services** ✔️ Custom Web Development ✔️ API Integrations ✔️ Business Process Automation ✔️ Data Entry & Web Research With over 7 years of experience in operations management and technology, I possess the skills necessary to implement this integration seamlessly. I will ensure that every step—from capturing GCLID data on your website to normalizing phone numbers in E.164 format—is executed meticulously. **Why Clients Hire Me** ⭐ Proven expertise in managing over 100 automated workflows ⭐ 99% data accuracy and meticulous attention to detail ⭐ Strong communication skills with 5,000+ customer interactions successfully managed ⭐ Fast response times and dependable delivery In this project, I will establish a robust data flow that captures lead information, stores it in Kommo CRM, normalizes phone numbers, and updates Google Sheets accordingly. By preventing duplicate conversions and ensuring data integrity, your advertising account will benefit from real sales data for optimized campaign performance. If you’re looking for a proactive freelancer committed to enhancing your business's efficiency, let's discuss how we can achieve your goals together. I invite you to view my portfolio for examples of similar integrations successfully delivered. Let’s build something that makes your business more efficient.
$150 USD in 7 days
0.0
0.0

OVERWHELMED with all the Ai Generated proposals. Give me a few seconds to show you why I am different. I've built integrations for service businesses that streamline data flow between multiple platforms. Your project requires precise tracking of offline conversions and proper normalization of phone numbers, which is crucial for accurate attribution in Google Ads. I would love to chat about your project, the worst that can happen is you walk away with a free consultation. Regards, Clinton.
$100 USD in 7 days
0.0
0.0

London, United Kingdom
Payment method verified
Member since Jun 30, 2018
$30-250 USD
$30-250 USD
$30-250 USD
$30-250 USD
$250-750 USD
₹1500-12500 INR
₹12500-37500 INR
$10-300 USD
$30-250 USD
₹600-1500 INR
$250-750 USD
₹400-750 INR / hour
£1500-3000 GBP
₹600-1500 INR
₹12500-37500 INR
₹12500-37500 INR
$15-25 USD / hour
$250-750 USD
$10-30 USD
₹12500-37500 INR
₹12500-37500 INR
₹1500-12500 INR
₹12500-37500 INR
₹1500-12500 INR
$2-8 USD / hour