Mailchimp Extraction & Cutover Command Center
Audience Size (Jacob Amaral)
8,799
7,991 Subscribed ยท 11 in Local DB
Extracted Past Campaigns
22
20 Sent Issues + 2 Scheduled Resends
Welcome Journey (ID 1214)
66.9%
Day 0 Open Rate ยท 3,996 Completed
Estimated Monthly Savings
~$145/mo
AWS SES cost: ~$0.80 per 8,000 emails
โš ๏ธ Critical Hover DNS Discovery on jacobamaral.com:
Your Hover control panel displays: "This domain is using third-party nameservers. DNS records added here won't have an effect."
Live DNS queries show jacobamaral.com is using ns1.systemdns.com, ns2.systemdns.com, ns3.systemdns.com, while wetradelabs.com uses dns1.namecheaphosting.com / dns2.namecheaphosting.com. Follow the DNS Cutover Table below when repointing codingtips.jacobamaral.com!

Step-by-Step Mailchimp Extraction Status

Component Source Local Backup Location Status
Static Images & Social Icons (6 files) mcusercontent.com/b1ab418a8baaff3cc1dfcd700 static/assets/portrait.png, og-image.png, favicon.png โœ“ Extracted & Self-Hosted
Lead Magnet Funnel (/join) codingtips.jacobamaral.com/join (Form 0041ade6f0) GET /join + data/mailchimp_backup/landing_page_config.json โœ“ Live at /join
20 Past Newsletter Broadcasts us18.campaign-archive.com (id=af0547392e) data/mailchimp_backup/campaigns/*.html + SQLite DB โœ“ 20/20 Archived
Welcome Automation Flow (ID 1214) Welcome Jacob Amaral New Subs Journey Day 0 Free Trading Algo + Day 1 Follow-up Worker โœ“ Active in MailBotAI
Full 8,799 Contact List (CSV/ZIP or API) Audience af0547392e (7,991 Subscribed, ~808 Suppressed) data/mailbot.db (subscribers table) Ready for ZIP Upload or API Key

DNS Cutover Reference (Hover `jacobamaral.com` & Namecheap `wetradelabs.com`)

1. In Hover โ†’ Nameservers for jacobamaral.com, switch from ns1-ns3.systemdns.com to ns1.hover.com & ns2.hover.com (or edit at your systemdns.com provider).
2. Replace the Mailchimp CNAME and SPF/DKIM records with the records below:

Domain Type Host Current Mailchimp Value (Remove) New Self-Hosted Value (Add)
jacobamaral.com CNAME or A codingtips us18-c9d8d5de-b1ab418a8baaff3cc1dfcd700.pages.mailchi.mp Point to your server IP / Cloudflare Tunnel hosting MailBotAI
jacobamaral.com TXT @ v=spf1 include:servers.mcsv.net ?all v=spf1 include:amazonses.com include:_spf.hostedemail.com ~all
wetradelabs.com TXT @ v=spf1 +a +mx ... ~all Add include:amazonses.com (or include:_spf.resend.com) before ~all
both domains CNAME k2._domainkey dkim2.mcsv.net Replace with your 3 AWS SES / Resend DKIM _domainkey CNAMEs

All Campaigns (Jacob Amaral Audience)

Includes all 20 imported Mailchimp broadcasts and scheduled Non-Opener resends
Campaign Name & Subject Status Segment Recipients Opens Clicks Actions
โฌ‡๏ธ Export Audience CSV
Email Address First Name Last Name Email Marketing Source Rating Opt-in / Updated Actions

Welcome Jacob Amaral New Subs Journey (Flow ID: 1214)

Automatically enrolls every new signup from /join or /api/v1/subscribe
โ— Active Background Worker
Trigger
Contact signs up to Jacob Amaral Audience
Matches both codingtips.jacobamaral.com/join and API signups

Recent Journey Enrollments & Queue

Subscriber Current Step Status Enrolled At Next Scheduled Send

Self-Hosted Funnel (`/join`)

โ†— Open Full Page

Exact self-hosted replacement for https://codingtips.jacobamaral.com/join. All 3 images from mcusercontent.com are now served locally from /static/assets/.

Teachable / External API Webhook

Your Mailchimp contact list shows contacts arriving with Source: API (such as your Teachable school at codealgotrading.com). Point your Teachable webhook or checkout script to:

POST https://codingtips.jacobamaral.com/api/v1/subscribe
{
  "email": "student@example.com",
  "first_name": "Alex",
  "last_name": "Trader",
  "source": "API",
  "tags": ["Teachable", "Coding Great Trading Bots"]
}

Note: This endpoint also accepts standard Mailchimp form-urlencoded EMAIL and FNAME fields for drop-in compatibility.

Email Transport Provider (ESP) & Deliverability Configuration

Local Outbox Audit Log (`data/outbox/`)

Every email dispatched (in both Sandbox and Live modes) is logged below so you can inspect the exact rendered HTML and headers.

File Size Action