-- phpMyAdmin SQL Dump
-- version 4.9.5deb2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 22, 2025 at 01:14 PM
-- Server version: 8.0.42-0ubuntu0.20.04.1
-- PHP Version: 8.2.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `dohrx_medical_billing`
--

-- --------------------------------------------------------

--
-- Table structure for table `crm_api_response`
--

CREATE TABLE `crm_api_response` (
  `id` int NOT NULL,
  `lead_id` varchar(100) DEFAULT NULL,
  `api_request` text NOT NULL,
  `api_response` text NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `attachment_response` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `crm_api_response`
--

INSERT INTO `crm_api_response` (`id`, `lead_id`, `api_request`, `api_response`, `attachment`, `attachment_response`, `created_at`) VALUES
(3, '', '{\"data\":[{\"First_Name\":\"Staging \",\"Last_Name\":\"Test\",\"Company\":\"Unknown\",\"Email\":\"amuratech@amuratech.com\",\"Phone\":\"8787878787\",\"Description\":\"Date Selection: 2025-12-11\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002423005\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-02 10:32:12'),
(4, '6335611000002427001', '{\"data\":[{\"First_Name\":\"Staging \",\"Last_Name\":\"Test\",\"Company\":\"Unknown\",\"Email\":\"amuratech@amuratech.com\",\"Phone\":\"8787878767\",\"Description\":\"Date Selection: 2025-12-11\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002427001', NULL, NULL, '2025-12-02 10:32:57'),
(5, '6335611000002427006', '{\"data\":[{\"First_Name\":\"Xyz \",\"Last_Name\":\"Test\",\"Company\":\"Unknown\",\"Email\":\"amura@tech.com\",\"Phone\":\"4545349394\",\"Description\":\"Date Selection: 2025-12-26\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cps\",\"UTM_Campaign\":\"sale\",\"UTM_Term\":\"hello\",\"UTM_Content\":\"test\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cps&utm_campaign=sale&utm_term=hello&utm_content=test\"}]}', 'Lead created successfully - 6335611000002427006', NULL, NULL, '2025-12-02 10:45:05'),
(6, '6335611000002439002', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"6676866666\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002439002', NULL, NULL, '2025-12-04 10:13:38'),
(7, '6335611000002440001', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"5675756757\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002440001', NULL, NULL, '2025-12-04 10:15:35'),
(8, '6335611000002441001', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"5675765675\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002441001', NULL, NULL, '2025-12-04 10:16:31'),
(9, '', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"9876543210\",\"Description\":\"Date Selection: 05-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"desktop\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=desktop&utm_campaign=test\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002413001\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-04 11:04:01'),
(10, '', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"9876543210\",\"Description\":\"Date Selection: 05-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"desktop\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=desktop&utm_campaign=test\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002413001\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-04 11:04:09'),
(11, '6335611000002445001', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"Test Mobile \",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"8978645451\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"mobile\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=mobile&utm_campaign=test\"}]}', 'Lead created successfully - 6335611000002445001', NULL, NULL, '2025-12-04 11:04:26'),
(12, '', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"9876543210\",\"Description\":\"Date Selection: 05-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"desktop\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=desktop&utm_campaign=test\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002413001\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-04 11:04:38'),
(13, '', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"9876543210\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"desktop\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=desktop&utm_campaign=test\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002413001\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-04 11:04:54'),
(14, '6335611000002448001', '{\"data\":[{\"First_Name\":\"Shubham \",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"7865746876\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google \",\"UTM_Medium\":\"desktop\",\"UTM_Campaign\":\"test\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google+&utm_medium=desktop&utm_campaign=test\"}]}', 'Lead created successfully - 6335611000002448001', NULL, NULL, '2025-12-04 11:05:46'),
(15, '6335611000002450003', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"6567868767\",\"Description\":\"Date Selection: 04-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002450003', NULL, NULL, '2025-12-04 12:20:22'),
(16, '6335611000002451001', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"7886868686\",\"Description\":\"Date Selection: 23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002451001', NULL, NULL, '2025-12-04 12:45:21'),
(17, '6335611000002509002', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6789012334\",\"Description\":\"Date Selection: 23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002509002', NULL, NULL, '2025-12-15 10:53:27'),
(18, '6335611000002510001', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6574683726\",\"Description\":\"Date Selection: 16-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1765796218665\"}]}', 'Lead created successfully - 6335611000002510001', NULL, NULL, '2025-12-15 10:57:46'),
(19, '6335611000002518002', '{\"data\":[{\"First_Name\":\"shubham \",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6767678768\",\"Description\":\"Date Selection: 16-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?first_name=&last_name=&email=&phone=&date_selection=&utm_campaign=&utm_content=&lead_source=Website&utm_medium=&utm_source=&utm_term=&page_url=\"}]}', 'Lead created successfully - 6335611000002518002', NULL, NULL, '2025-12-16 07:58:29'),
(20, '6335611000002519001', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"6576867868\",\"Description\":\"Date Selection: 17-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?first_name=&last_name=&email=&phone=&date_selection=&utm_campaign=&utm_content=&lead_source=Website&utm_medium=&utm_source=&utm_term=&page_url=\"}]}', 'Lead created successfully - 6335611000002519001', NULL, NULL, '2025-12-16 07:59:20'),
(21, '6335611000002521002', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@test.com\",\"Phone\":\"6887867985\",\"Description\":\"Date Selection: 17-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002521002', NULL, NULL, '2025-12-16 08:03:19'),
(22, '6335611000002522002', '{\"data\":[{\"First_Name\":\"Shubham\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"shubham.boralkar@amuratech.com\",\"Phone\":\"7676786876\",\"Description\":\"Date Selection: 16-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002522002', NULL, NULL, '2025-12-16 10:03:15'),
(23, '6335611000002531002', '{\"data\":[{\"First_Name\":\"Test\",\"Last_Name\":\"Test\",\"Company\":\"Unknown\",\"Email\":\"soham.patil@amuratech.com\",\"Phone\":\"9999999999\",\"Description\":\"Date Selection: 17-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002531002', NULL, NULL, '2025-12-17 06:12:24'),
(24, '6335611000002534002', '{\"data\":[{\"First_Name\":\"Test\",\"Last_Name\":\"sushant\",\"Company\":\"Unknown\",\"Email\":\"sushant.p@amuratech.com\",\"Phone\":\"9876987698\",\"Description\":\"Date Selection: 30-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/power-of-doh\\/\"}]}', 'Lead created successfully - 6335611000002534002', NULL, NULL, '2025-12-17 07:30:15'),
(25, '6335611000002535002', '{\"data\":[{\"First_Name\":\"Name\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"rohit123@gmail.com\",\"Phone\":\"8458458555\",\"Date Selection\":\"24-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002535002', NULL, NULL, '2025-12-17 08:39:05'),
(26, '6335611000002536001', '{\"data\":[{\"First_Name\":\"Name\",\"Last_Name\":\"Rohit test\",\"Company\":\"Unknown\",\"Email\":\"rohit123@gmail.com\",\"Phone\":\"6456456456\",\"Date Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002536001', NULL, NULL, '2025-12-17 08:47:00'),
(27, '6335611000002538002', '{\"data\":[{\"First_Name\":\"test Hrushabh\",\"Last_Name\":\"hrushabh\",\"Company\":\"Unknown\",\"Email\":\"45435@gmail.com\",\"Phone\":\"6767567656\",\"Date_Selection\":\"31-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002538002', NULL, NULL, '2025-12-17 10:04:37'),
(28, '6335611000002539001', '{\"data\":[{\"First_Name\":\"utm Test\",\"Last_Name\":\"Utm\",\"Company\":\"Unknown\",\"Email\":\"erer@gffdg.com\",\"Phone\":\"6565657657\",\"Date_Selection\":\"18-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002539001', NULL, NULL, '2025-12-17 10:05:49'),
(29, '6335611000002534007', '{\"data\":[{\"First_Name\":\"Hrushabh\",\"Last_Name\":\"Test Parameter\",\"Company\":\"Unknown\",\"Email\":\"parameter@gmail.com\",\"Phone\":\"7657657657\",\"Date_Selection\":\"24-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002534007', NULL, NULL, '2025-12-17 10:08:10'),
(30, '6335611000002541001', '{\"data\":[{\"First_Name\":\"Test Sushant\",\"Last_Name\":\"Pawar\",\"Company\":\"Unknown\",\"Email\":\"test@sushant.com\",\"Phone\":\"6576576585\",\"Date_Selection\":\"30-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"test_source\",\"UTM_Medium\":\"test_medium\",\"UTM_Campaign\":\"test_campaign\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/power-of-doh\\/?utm_source=test_source&utm_medium=test_medium&utm_campaign=test_campaign\"}]}', 'Lead created successfully - 6335611000002541001', NULL, NULL, '2025-12-17 10:36:08'),
(31, '6335611000002547002', '{\"data\":[{\"First_Name\":\"Test first name\",\"Last_Name\":\"Test Last name\",\"Company\":\"Unknown\",\"Email\":\"test2@email.co\",\"Phone\":\"8686868686\",\"Date_Selection\":\"18-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"source\",\"UTM_Medium\":\"google\",\"UTM_Campaign\":\"test_campaign_mobile\",\"UTM_Term\":\"campaign_term\",\"UTM_Content\":\"campaign_content\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=source&utm_medium=google&utm_campaign=test_campaign_mobile&utm_id=campaign&utm_term=campaign_term&utm_content=campaign_content\"}]}', 'Lead created successfully - 6335611000002547002', NULL, NULL, '2025-12-17 13:16:24'),
(32, '6335611000002548001', '{\"data\":[{\"First_Name\":\"Test Name one\",\"Last_Name\":\"test last name one\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"9422207133\",\"Date_Selection\":\"17-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"source\",\"UTM_Medium\":\"google\",\"UTM_Campaign\":\"test_campaign\",\"UTM_Term\":\"campaign_term\",\"UTM_Content\":\"campaign_content\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=source&utm_medium=google&utm_campaign=test_campaign&utm_id=campaign&utm_term=campaign_term&utm_content=campaign_content\"}]}', 'Lead created successfully - 6335611000002548001', NULL, NULL, '2025-12-17 13:17:01'),
(33, '6335611000002534012', '{\"data\":[{\"First_Name\":\"Test Sushrut\",\"Last_Name\":\"Test Parab\",\"Company\":\"Unknown\",\"Email\":\"sushrut.parab@amuratech.com\",\"Phone\":\"8668502239\",\"Date_Selection\":\"18-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"source\",\"UTM_Medium\":\"google\",\"UTM_Campaign\":\"test_campaign_mobile\",\"UTM_Term\":\"campaign_term\",\"UTM_Content\":\"campaign_content\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=source&utm_medium=google&utm_campaign=test_campaign_mobile&utm_id=campaign&utm_term=campaign_term&utm_content=campaign_content\"}]}', 'Lead created successfully - 6335611000002534012', NULL, NULL, '2025-12-17 13:32:40'),
(34, '6335611000002568002', '{\"data\":[{\"First_Name\":\"Dr jon\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"ytee@gmail.com\",\"Phone\":\"9876566987\",\"Date_Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"source\",\"UTM_Medium\":\"medium\",\"UTM_Campaign\":\"campaign_name\",\"UTM_Term\":\"keyword\",\"UTM_Content\":\"content\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-a\\/?utm_source=source&utm_medium=medium&utm_campaign=campaign_name&utm_term=keyword&utm_content=content\"}]}', 'Lead created successfully - 6335611000002568002', NULL, NULL, '2025-12-19 10:02:23'),
(35, '6335611000002570001', '{\"data\":[{\"First_Name\":\"TestAbhilasha\",\"Last_Name\":\"Patil\",\"Company\":\"Unknown\",\"Email\":\"abhilasha.patil@amuratech.com\",\"Phone\":\"6362164804\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-a\\/\"}]}', 'Lead created successfully - 6335611000002570001', NULL, NULL, '2025-12-19 10:24:19'),
(36, '6335611000002571001', '{\"data\":[{\"First_Name\":\"TestAbhi\",\"Last_Name\":\"Patilll\",\"Company\":\"Unknown\",\"Email\":\"abhilasha.patill@gmail.com\",\"Phone\":\"8776655667\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google_souerch\",\"UTM_Medium\":\"Google_medium\",\"UTM_Campaign\":\"Campaign_name\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-a\\/?utm_source=Google_souerch&utm_medium=Google_medium&utm_campaign=Campaign_name&utm_id=Google_campaign\"}]}', 'Lead created successfully - 6335611000002571001', NULL, NULL, '2025-12-19 10:27:15'),
(37, '6335611000002572001', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6545435653\",\"Date_Selection\":\"19-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766141225015\"}]}', 'Lead created successfully - 6335611000002572001', NULL, NULL, '2025-12-19 10:47:41'),
(38, '6335611000002574002', '{\"data\":[{\"First_Name\":\"test demo\",\"Last_Name\":\"hello\",\"Company\":\"Unknown\",\"Email\":\"tete@gmail.com\",\"Phone\":\"6534463535\",\"Date_Selection\":\"31-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002574002', NULL, NULL, '2025-12-19 11:00:26'),
(39, '6335611000002568007', '{\"data\":[{\"First_Name\":\"tes helli\",\"Last_Name\":\"helli\",\"Company\":\"Unknown\",\"Email\":\"hey@gmail.comn\",\"Phone\":\"6445646456\",\"Date_Selection\":\"19-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766143728435\"}]}', 'Lead created successfully - 6335611000002568007', NULL, NULL, '2025-12-19 11:34:30'),
(40, '', '{\"data\":[{\"First_Name\":\"test xyz\",\"Last_Name\":\"helle\",\"Company\":\"Unknown\",\"Email\":\"helelo@gmail.com\",\"Phone\":\"9988776655\",\"Date_Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', '{\"data\":[{\"code\":\"DUPLICATE_DATA\",\"details\":{\"api_name\":\"Phone\",\"id\":\"6335611000002576001\"},\"message\":\"duplicate data\",\"status\":\"error\"}]}', NULL, NULL, '2025-12-19 11:38:40'),
(41, '6335611000002574007', '{\"data\":[{\"First_Name\":\"test xyz\",\"Last_Name\":\"helle\",\"Company\":\"Unknown\",\"Email\":\"helelo@gmail.com\",\"Phone\":\"9988776434\",\"Date_Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/\"}]}', 'Lead created successfully - 6335611000002574007', NULL, NULL, '2025-12-19 11:39:21'),
(42, '6335611000002578001', '{\"data\":[{\"First_Name\":\"Name\",\"Last_Name\":\"hrushabh\",\"Company\":\"Unknown\",\"Email\":\"yets@gmail.com\",\"Phone\":\"6456664646\",\"Date_Selection\":\"24-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002578001', NULL, NULL, '2025-12-19 11:40:20'),
(43, '6335611000002579001', '{\"data\":[{\"First_Name\":\"yahs test two \",\"Last_Name\":\"sjhdh\",\"Company\":\"Unknown\",\"Email\":\"happy@gmail.com\",\"Phone\":\"6565654637\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766144471132\"}]}', 'Lead created successfully - 6335611000002579001', NULL, NULL, '2025-12-19 11:41:45'),
(44, '6335611000002570006', '{\"data\":[{\"First_Name\":\"siddhi\",\"Last_Name\":\"velapure\",\"Company\":\"Unknown\",\"Email\":\"rushabhillode@gmail.com\",\"Phone\":\"8798987890\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002570006', NULL, NULL, '2025-12-19 11:43:02'),
(45, '6335611000002580001', '{\"data\":[{\"First_Name\":\"lojimi\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"rohit123@gmail.com\",\"Phone\":\"9988456543\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002580001', NULL, NULL, '2025-12-19 11:47:48'),
(46, '6335611000002582002', '{\"data\":[{\"First_Name\":\"test \",\"Last_Name\":\"hsgh\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6756474732\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766145823758\"}]}', 'Lead created successfully - 6335611000002582002', NULL, NULL, '2025-12-19 12:04:36'),
(47, '6335611000002574012', '{\"data\":[{\"First_Name\":\"hello \",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"rohit123@gmail.com\",\"Phone\":\"9988123456\",\"Date_Selection\":\"30-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002574012', NULL, NULL, '2025-12-19 12:08:13'),
(48, '6335611000002580006', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6445646778\",\"Date_Selection\":\"24-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766146201014\"}]}', 'Lead created successfully - 6335611000002580006', NULL, NULL, '2025-12-19 12:11:47'),
(49, '6335611000002570011', '{\"data\":[{\"First_Name\":\"Name\",\"Last_Name\":\"hrushabh\",\"Company\":\"Unknown\",\"Email\":\"you@gmail.com\",\"Phone\":\"7645353523\",\"Date_Selection\":\"31-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002570011', NULL, NULL, '2025-12-19 12:15:06'),
(50, '6335611000002568012', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"helli\",\"Company\":\"Unknown\",\"Email\":\"syash8811@gmail.com\",\"Phone\":\"8758558588\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766146201014\"}]}', 'Lead created successfully - 6335611000002568012', NULL, NULL, '2025-12-19 12:15:56'),
(51, '6335611000002579006', '{\"data\":[{\"First_Name\":\"Rohit\",\"Last_Name\":\"Rohit Sharma\",\"Company\":\"Unknown\",\"Email\":\"rohit123@gmail.com\",\"Phone\":\"9988776889\",\"Date_Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002579006', NULL, NULL, '2025-12-19 12:19:38'),
(52, '6335611000002584001', '{\"data\":[{\"First_Name\":\"Rohit\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"4545ee@gmail.com\",\"Phone\":\"9988732425\",\"Date_Selection\":\"30-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"google\",\"UTM_Medium\":\"cpc\",\"UTM_Campaign\":\"medical_billing_test\",\"UTM_Term\":\"medical billing services\",\"UTM_Content\":\"ad_variant_1\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=google&utm_medium=cpc&utm_campaign=medical_billing_test&utm_term=medical+billing+services&utm_content=ad_variant_1\"}]}', 'Lead created successfully - 6335611000002584001', NULL, NULL, '2025-12-19 12:28:42'),
(53, '6335611000002580011', '{\"data\":[{\"First_Name\":\"hghd\",\"Last_Name\":\"sgfhdg\",\"Company\":\"Unknown\",\"Email\":\"hey@gmail.comn\",\"Phone\":\"7564763872\",\"Date_Selection\":\"29-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766147749186\"}]}', 'Lead created successfully - 6335611000002580011', NULL, NULL, '2025-12-19 12:36:27'),
(54, '6335611000002586001', '{\"data\":[{\"First_Name\":\"testhfgf\",\"Last_Name\":\"gshsh\",\"Company\":\"Unknown\",\"Email\":\"happy@gmail.com\",\"Phone\":\"6756474798\",\"Date_Selection\":\"22-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766147959334\"}]}', 'Lead created successfully - 6335611000002586001', NULL, NULL, '2025-12-19 12:39:43'),
(55, '6335611000002588002', '{\"data\":[{\"First_Name\":\"TestAbhilashaaa\",\"Last_Name\":\"Patilll\",\"Company\":\"Unknown\",\"Email\":\"abhi@gmail.com\",\"Phone\":\"8778865667\",\"Date_Selection\":\"20-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google_souerchh\",\"UTM_Medium\":\"Google_mediumm\",\"UTM_Campaign\":\"Campaign_namee\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-b\\/?utm_source=Google_souerchh&utm_medium=Google_mediumm&utm_campaign=Campaign_namee&utm_id=Google_campaignn\"}]}', 'Lead created successfully - 6335611000002588002', NULL, NULL, '2025-12-19 13:36:56'),
(56, '6335611000002599002', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"gdhh\",\"Company\":\"Unknown\",\"Email\":\"lp@gmail.com\",\"Phone\":\"7564738347\",\"Date_Selection\":\"29-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766388864600\"}]}', 'Lead created successfully - 6335611000002599002', NULL, NULL, '2025-12-22 07:35:02'),
(57, '6335611000002600001', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"6565654637\",\"Date_Selection\":\"25-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"linkedin\",\"UTM_Medium\":\"cpm\",\"UTM_Campaign\":\"AM_linkedin_Campaign_Nov25\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=linkedin&utm_medium=cpm&utm_campaign=AM_linkedin_Campaign_Nov25&gtm_debug=1766389419699\"}]}', 'Lead created successfully - 6335611000002600001', NULL, NULL, '2025-12-22 07:44:44'),
(58, '6335611000002601002', '{\"data\":[{\"First_Name\":\"test\",\"Last_Name\":\"test \",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"9089098909\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google\",\"UTM_Medium\":\"CPC_test1\",\"UTM_Campaign\":\"AM_Google_Search_C_test1\",\"UTM_Term\":\"test2025\",\"UTM_Content\":\"test_ads2025\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/medical-billing\\/?utm_source=Google&utm_medium=CPC_test1&utm_campaign=AM_Google_Search_C_test1&utm_id=testCampaingnmar25&utm_term=test2025&utm_content=test_ads2025&gtm_debug=1766396310129\"}]}', 'Lead created successfully - 6335611000002601002', NULL, NULL, '2025-12-22 09:46:25'),
(59, '6335611000002603002', '{\"data\":[{\"First_Name\":\"test aparna\",\"Last_Name\":\"test qa \",\"Company\":\"Unknown\",\"Email\":\"testg@gmail.com\",\"Phone\":\"8978908228\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google\",\"UTM_Medium\":\"CPC_test1\",\"UTM_Campaign\":\"AM_Google_Search_C_test1\",\"UTM_Term\":\"test2025\",\"UTM_Content\":\"test_ads2025\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-a\\/?utm_source=Google&utm_medium=CPC_test1&utm_campaign=AM_Google_Search_C_test1&utm_id=testCampaingnmar25&utm_term=test2025&utm_content=test_ads2025&gtm_debug=1766397291707\"}]}', 'Lead created successfully - 6335611000002603002', NULL, NULL, '2025-12-22 10:04:23'),
(60, '6335611000002603007', '{\"data\":[{\"First_Name\":\"test aparna\",\"Last_Name\":\"joshi\",\"Company\":\"Unknown\",\"Email\":\"testg@gmail.com\",\"Phone\":\"9090909098\",\"Date_Selection\":\"30-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google\",\"UTM_Medium\":\"CPC_test1\",\"UTM_Campaign\":\"AM_Google_Search_C_test1\",\"UTM_Term\":\"test2025\",\"UTM_Content\":\"test_ads2025\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/dohrx-variant-b\\/?utm_source=Google&utm_medium=CPC_test1&utm_campaign=AM_Google_Search_C_test1&utm_id=testCampaingnmar25&utm_term=test2025&utm_content=test_ads2025&gtm_debug=1766398071277\"}]}', 'Lead created successfully - 6335611000002603007', NULL, NULL, '2025-12-22 10:10:24'),
(61, '6335611000002604001', '{\"data\":[{\"First_Name\":\"test aparna\",\"Last_Name\":\"rest\",\"Company\":\"Unknown\",\"Email\":\"aparna.j@amuratech.com\",\"Phone\":\"9098909890\",\"Date_Selection\":\"31-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google\",\"UTM_Medium\":\"CPC_test1\",\"UTM_Campaign\":\"AM_Google_Search_C_test1\",\"UTM_Term\":\"test2025\",\"UTM_Content\":\"test_ads2025\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/power-of-doh\\/?utm_source=Google&utm_medium=CPC_test1&utm_campaign=AM_Google_Search_C_test1&utm_id=testCampaingnmar25&utm_term=test2025&utm_content=test_ads2025&gtm_debug=1766398372496\"}]}', 'Lead created successfully - 6335611000002604001', NULL, NULL, '2025-12-22 10:16:18'),
(62, '6335611000002607001', '{\"data\":[{\"First_Name\":\"test aparna\",\"Last_Name\":\"test qa\",\"Company\":\"Unknown\",\"Email\":\"test@gmail.com\",\"Phone\":\"8978989898\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"Google\",\"UTM_Medium\":\"CPC_test1\",\"UTM_Campaign\":\"AM_Google_Search_C_test1\",\"UTM_Term\":\"test2025\",\"UTM_Content\":\"test_ads2025\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/power-of-doh\\/?utm_source=Google&utm_medium=CPC_test1&utm_campaign=AM_Google_Search_C_test1&utm_id=testCampaingnmar25&utm_term=test2025&utm_content=test_ads2025&gtm_debug=1766398699837\"}]}', 'Lead created successfully - 6335611000002607001', NULL, NULL, '2025-12-22 10:19:34'),
(63, '6335611000002612012', '{\"data\":[{\"First_Name\":\"soham\",\"Last_Name\":\"patil\",\"Company\":\"Unknown\",\"Email\":\"sohampariltest@gmail.com\",\"Phone\":\"9879876598\",\"Date_Selection\":\"23-12-2025\",\"Lead_Source\":\"Website\",\"UTM_Source\":\"\",\"UTM_Medium\":\"\",\"UTM_Campaign\":\"\",\"UTM_Term\":\"\",\"UTM_Content\":\"\",\"Page_URL\":\"https:\\/\\/dohrx.wpstaging.amura.in\\/end-to-end-medical-billing-solution\\/\"}]}', 'Lead created successfully - 6335611000002612012', NULL, NULL, '2025-12-22 12:31:16');

-- --------------------------------------------------------

--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` int NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `date_selection` date NOT NULL,
  `company` varchar(255) DEFAULT 'Unknown',
  `lead_source` varchar(100) DEFAULT 'Website',
  `utm_source` varchar(255) DEFAULT NULL,
  `utm_medium` varchar(255) DEFAULT NULL,
  `utm_campaign` varchar(255) DEFAULT NULL,
  `utm_term` varchar(255) DEFAULT NULL,
  `utm_content` varchar(255) DEFAULT NULL,
  `page_url` text,
  `zoho_lead_id` varchar(100) DEFAULT NULL,
  `status` enum('pending','submitted','failed') DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `leads`
--

INSERT INTO `leads` (`id`, `first_name`, `last_name`, `email`, `phone`, `date_selection`, `company`, `lead_source`, `utm_source`, `utm_medium`, `utm_campaign`, `utm_term`, `utm_content`, `page_url`, `zoho_lead_id`, `status`, `created_at`) VALUES
(4, 'Staging ', 'Test', 'amuratech@amuratech.com', '8787878787', '2025-12-11', 'Unknown', 'Website', '', '', '', '', '', 'https://dohrx.wpstaging.amura.in/medical-billing/', '', 'failed', '2025-12-02 10:32:10'),
(5, 'Staging ', 'Test', 'amuratech@amuratech.com', '8787878767', '2025-12-11', 'Unknown', 'Website', '', '', '', '', '', 'https://dohrx.wpstaging.amura.in/medical-billing/', '6335611000002427001', 'submitted', '2025-12-02 10:32:55'),
(6, 'Xyz ', 'Test', 'amura@tech.com', '4545349394', '2025-12-26', 'Unknown', 'Website', 'google', 'cps', 'sale', 'hello', 'test', 'https://dohrx.wpstaging.amura.in/medical-billing/?utm_source=google&utm_medium=cps&utm_campaign=sale&utm_term=hello&utm_content=test', '6335611000002427006', 'submitted', '2025-12-02 10:45:03');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `crm_api_response`
--
ALTER TABLE `crm_api_response`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_lead_id` (`lead_id`),
  ADD KEY `idx_created_at` (`created_at`);

--
-- Indexes for table `leads`
--
ALTER TABLE `leads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_email` (`email`),
  ADD KEY `idx_phone` (`phone`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_status` (`status`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `crm_api_response`
--
ALTER TABLE `crm_api_response`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `leads`
--
ALTER TABLE `leads`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
