What is your current level of experience in freelance work?
**Description:** We're launching a high-impact, multi-touch outreach campaign to convert enterprise leads into booked Zoom calls. This project involves sending QR-coded postcards, automating LinkedIn messaging, triggering Mailchimp email sequences, and driving traffic to a landing page built in WordPress. This system targets enterprise buyers. Our average deal size is $14M, so precision and professionalism are essential. --- **What We Need Built:** **1. Airtable CRM Setup** * Create a structured Airtable base with fields like Name, Email, LinkedIn URL, Company, Bitly Link, Outreach Status, QR Scan Status, Email Sequence Status, and Zoom Booking Status. * Set up views to track leads by pipeline stage: Not Contacted, Connected, Messaged, QR Scanned, Booked Call, Closed. **2. Zapier Automations** * When a new lead is added to Airtable, enrich the record using Apollo.io or Dropcontact. * Generate a unique Bitly URL for each contact. * Send leads into Expandi (or Phantombuster) to automate LinkedIn connections and messages. * Trigger email sequences in Mailchimp based on QR scans or message engagement. * Update Airtable automatically when actions are taken (message sent, reply received, QR scanned, form submitted, etc.). **3. QR Code Integration** * Create one QR code per lead, linked to a unique Bitly URL. * Export QR codes for printing (we will handle the actual print/mail). * Capture scan data and pipe that back into Airtable. **4. WordPress Landing Page** * Build a branded landing page using Elementor with a clean layout, strong headline, benefit bullets, embedded Zoom scheduler (Calendly or TidyCal), and optional testimonial or video. * UTM or Bitly links should carry through for attribution. **5. Mailchimp Email Sequence** * Create a short email drip campaign (3–5 emails) triggered by LinkedIn engagement or QR scan. * Personalize each email with merge fields. * Pause emails if a Zoom call is booked. **6. Live Campaign Dashboard** We need a real-time dashboard to monitor and share campaign performance with our internal team and partners. Requirements: - Build using Airtable Interface Designer (preferred) or Google Looker Studio - Must include visual KPIs for: - Total leads - LinkedIn connections made - QR code scans (tracked via Bitly) - Zoom calls booked (tracked via Calendly) - Mailchimp email opens and clicks - Closed deals and total revenue - Create filters for viewing: - Leads by stage (e.g., connected, messaged, booked, closed) - Campaign source (e.g., LinkedIn, email, QR) - Weekly/monthly performance - Dashboard must auto-update as new data flows in via Zapier or connected tools - Must be secure and easy to share with stakeholders (read-only or limited access) This dashboard is a core deliverable and must be deployed alongside the automation workflows. --- **Ideal Candidate:** * Proven experience with Zapier, Airtable, and Expandi or Phantombuster * Familiar with QR code + Bitly automation * Comfortable building Elementor pages and integrating Calendly * Able to build clean, error-proof workflows * Bonus if you’ve worked with Clay, OpenAI, or Apollo.io --- **Timeline:** * Start: 2-3 weeks * First version: 3-4 weeks * Final system tested and deployed within 5-6 weeks --- **To Apply:** Please include: 1. Examples of similar systems you've built 2. Your preferred tools for each part of this workflow 3. Your estimated hours and proposed process 4. Any additional suggestions based on your experience 5. Your favorite ice cream