📘 Conversiones Offline - Meta Ads

from simple_salesforce import Salesforce
import csv
import hashlib
from datetime import datetime

# Función para hashear datos
def hash_data(data):
    if not data:
        return ""
    return hashlib.sha256(str(data).lower().strip().encode()).hexdigest()

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

# Query SOQL
query = """
    SELECT FBCLID__c, StatusChangeDate, Email, Phone, FirstName, LastName, 
           City, State, Country
    FROM Lead
    WHERE Status = 'Qualified'
    AND FBCLID__c != null
    AND StatusChangeDate = LAST_N_DAYS:7
"""

results = sf.query(query)

# Generar CSV para Meta Ads
with open('meta_ads_conversions.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['event_name', 'event_time', 'fbclid', 'value', 'currency',
                     'email', 'phone', 'fn', 'ln', 'ct', 'st', 'country'])
    
    for record in results['records']:
        fbclid = record['FBCLID__c']
        date = record['StatusChangeDate']
        
        # Convertir fecha a Unix timestamp
        dt = datetime.strptime(date, '%Y-%m-%dT%H:%M:%S.%f%z')
        timestamp = int(dt.timestamp())
        
        # Hashear datos personales
        email = hash_data(record.get('Email'))
        phone = hash_data(record.get('Phone', '').replace('+', '').replace(' ', ''))
        fn = hash_data(record.get('FirstName'))
        ln = hash_data(record.get('LastName'))
        ct = hash_data(record.get('City'))
        st = hash_data(record.get('State'))
        country = hash_data(record.get('Country'))
        
        writer.writerow([
            'LeadQualified',
            timestamp,
            fbclid,
            100,
            'EUR',
            email,
            phone,
            fn,
            ln,
            ct,
            st,
            country
        ])

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

import requests
import csv
import hashlib
from datetime import datetime

# Función para hashear datos
def hash_data(data):
    if not data:
        return ""
    return hashlib.sha256(str(data).lower().strip().encode()).hexdigest()

# 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(FBCLID:is_not_empty)",
    "fields": "FBCLID,Modified_Time,Email,Phone,First_Name,Last_Name,City,State,Country",
    "per_page": 200
}

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

# Generar CSV para Meta Ads
with open('meta_ads_conversions.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['event_name', 'event_time', 'fbclid', 'value', 'currency',
                     'email', 'phone', 'fn', 'ln', 'ct', 'st', 'country'])
    
    for lead in leads:
        fbclid = lead.get("FBCLID")
        date = lead.get("Modified_Time")
        
        if fbclid and date:
            # Convertir fecha a Unix timestamp
            dt = datetime.fromisoformat(date.replace('Z', '+00:00'))
            timestamp = int(dt.timestamp())
            
            # Hashear datos personales
            email = hash_data(lead.get("Email"))
            phone = hash_data(lead.get("Phone", "").replace("+", "").replace(" ", ""))
            fn = hash_data(lead.get("First_Name"))
            ln = hash_data(lead.get("Last_Name"))
            ct = hash_data(lead.get("City"))
            st = hash_data(lead.get("State"))
            country = hash_data(lead.get("Country"))
            
            writer.writerow([
                'LeadQualified',
                timestamp,
                fbclid,
                100,
                'EUR',
                email,
                phone,
                fn,
                ln,
                ct,
                st,
                country
            ])

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