Engagement Metrics

interface Contact {
  engagementScore?: number;  // Composite score 0-100
  status: 'Subscribed' | 'Unsubscribed' | 'Bounced' | 'Pending';
  tags: string[];
  listIds?: string[];
}

const totalEmails = logs.length;
const opened = logs.filter(l => l.status === 'Opened' || l.status === 'Clicked').length;
const clicked = logs.filter(l => l.status === 'Clicked').length;
const openRate = totalEmails > 0 ? Math.round((opened / totalEmails) * 100) : 0;

db.analytics.trackConsumption({
  userId: 'u_member',
  assetId: 'content_123',
  assetName: 'Meditation Guide',
  assetType: 'video',
  tags: ['Meditación', 'Bienestar']
});

interface ContentInteraction {
  id: string;
  userId?: string;        // Optional for public content
  assetId: string;
  assetName: string;
  assetType: string;      // 'video' | 'audio' | 'document' | 'Article'
  tags: string[];
  timestamp: string;
}

interface UserActivity {
  id: string;
  type: 'Event' | 'Reading' | 'Donation' | 'Meditation';
  title: string;
  date: string;
  status: 'Completed' | 'Registered';
}

const contactsInList = contacts.filter(c => c.listIds?.includes(selectedMetricsList));
const contactIds = new Set(contactsInList.map(c => c.id));
const logsForList = allEmailLogs.filter(l => contactIds.has(l.contactId));

// Calculate list-specific rates
const openedCount = logsForList.filter(l => l.status === 'Opened' || l.status === 'Clicked').length;
const openRate = Math.round((openedCount / logsForList.length) * 100);

const effectivenessRate = totalContacts > 0 
  ? Math.round((subscribedContacts / totalContacts) * 100) 
  : 0;

contacts.forEach(c => {
  if (c.createdAt) {
    const m = new Date(c.createdAt).getMonth();
    contactsByMonth[m]++;
  }
});

interface QueueStatus {
  pending: number;          // Emails waiting to send
  sent: number;             // Successfully sent
  failed: number;           // Failed sends
  sentCountThisHour: number;// Rate limiting tracker
  limit: number;            // Hourly send limit (default 80)
}

const status = await db.emails.getQueueStatus();

// Get global email metrics
const metrics = db.emails.getMetrics();
// Returns: { totalSent, openRate, clickRate, bounceRate, history }

// Get logs for specific contact
const logs = db.emails.getLogs(contactId);

// Get all interactions
const interactions = db.analytics.getInteractions();

// Track new interaction
db.analytics.trackConsumption({
  userId: currentUser.id,
  assetId: 'article_123',
  assetName: 'Meditation Guide',
  assetType: 'Article',
  tags: ['Meditación']
});

// Get user's activity history
const history = db.user.getHistory();

// Add activity
db.user.addHistory({
  id: generateId(),
  type: 'Meditation',
  title: 'Morning meditation session',
  date: new Date().toISOString(),
  status: 'Completed'
});