Conversiones Offline - Google Ads

// Process Builder:
// Object: Lead
// Trigger: When a record is created or edited
// Criteria: Status EQUALS "Qualified" AND GCLID__c IS NOT NULL

// Action: Call HTTP Callout
POST https://tu-servidor.com/api/google-ads-conversion
{
  "gclid": "{!Lead.GCLID__c}",
  "conversion_name": "Lead Cualificado",
  "conversion_time": "{!Lead.StatusChangeDate}",
  "conversion_value": 100
}

// Script Python con simple-salesforce
from simple_salesforce import Salesforce
import csv
from datetime import datetime

# Conectar a Salesforce
sf = Salesforce(
    username='tu_usuario@empresa.com',
    password='tu_password',
    security_token='tu_token'
)

# Query SOQL para obtener leads cualificados
query = """
    SELECT GCLID__c, StatusChangeDate, Email
    FROM Lead
    WHERE Status = 'Qualified'
    AND GCLID__c != null
    AND StatusChangeDate = LAST_N_DAYS:7
"""

results = sf.query(query)

# Generar CSV para Google Ads
with open('google_ads_conversions.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['Google Click ID', 'Conversion Name', 'Conversion Time',
                     'Conversion Value', 'Conversion Currency'])
    
    for record in results['records']:
        gclid = record['GCLID__c']
        date = record['StatusChangeDate']
        
        # Formatear fecha
        dt = datetime.strptime(date, '%Y-%m-%dT%H:%M:%S.%f%z')
        formatted_date = dt.strftime('%Y-%m-%d %H:%M:%S%z')
        
        writer.writerow([
            gclid,
            'Lead Cualificado',
            formatted_date,
            100,
            'EUR'
        ])

print(f"CSV generado con {len(results['records'])} conversiones")

// Workflow en Zoho:
// Module: Leads
// Trigger: Field Update (Lead Status = Qualified)
// Condition: GCLID is not null

// Action: Webhook
URL: https://tu-servidor.com/api/google-ads-conversion
Method: POST
Body:
{
  "gclid": "${Leads.GCLID}",
  "conversion_name": "Lead Cualificado",
  "conversion_time": "${Leads.Modified_Time}",
  "conversion_value": 100
}

// Script Python con Zoho CRM API
import requests
import csv
from datetime import datetime

# Configuración
ZOHO_ACCESS_TOKEN = "tu_access_token"
ZOHO_API_URL = "https://www.zohoapis.eu/crm/v2/Leads"

# Headers
headers = {
    "Authorization": f"Bearer {ZOHO_ACCESS_TOKEN}"
}

# Parámetros de búsqueda
params = {
    "criteria": "(Lead_Status:equals:Qualified)and(GCLID:is_not_empty)",
    "fields": "GCLID,Modified_Time,Email",
    "per_page": 200
}

# Obtener leads
response = requests.get(ZOHO_API_URL, headers=headers, params=params)
leads = response.json()["data"]

# Generar CSV para Google Ads
with open('google_ads_conversions.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['Google Click ID', 'Conversion Name', 'Conversion Time',
                     'Conversion Value', 'Conversion Currency'])
    
    for lead in leads:
        gclid = lead.get("GCLID")
        date = lead.get("Modified_Time")
        
        if gclid and date:
            # Formatear fecha
            dt = datetime.fromisoformat(date.replace('Z', '+00:00'))
            formatted_date = dt.strftime('%Y-%m-%d %H:%M:%S%z')
            
            writer.writerow([
                gclid,
                'Lead Cualificado',
                formatted_date,
                100,
                'EUR'
            ])

print(f"CSV generado con {len(leads)} conversiones")