Process membership and academy exports, then sync directly to Constant Contact
Settings
Membership sync
Academy sync
Programs/Events sync
Management sync
Constant Contact authorization
Checking authorization...
Click Authorize to connect this tool to Constant Contact. You'll be taken to the CC login page in a new tab — once you approve, that tab closes automatically and the tool is ready. You only need to do this again if authorization expires.
Gmail authorization
Checking authorization...
Click Authorize Gmail to let the tool check Sent mail for prior outreach and create drafts on the Membership Sync tab. This uses a Google login separate from the Constant Contact connection above.
Membership list IDs
Pre-filled from the existing setup. Update if any change.
Saved
Academy list ID
Saved
Programs / Events list IDs
One Constant Contact list ID per subcategory. Create the lists in CC first, then paste their IDs here.
Saved
Weekly ActiveNet import (recommended)
Upload the raw weekly .xlsx export once — this fills in Step 1 below and updates the athlete roster that Athlete Recognition uses (Roster Import's old job). Prefer pasting instead? Skip this and use Step 1 directly.
Step 1 — ActiveNet export
Copy all data from your ActiveNet Excel export and paste below (include the header row), or use the uploader above.
Step 2 — Unsubscribe list (optional)
Export from CC → Contacts → Unsubscribed. These addresses will never be re-added.
Breakdown by membership type
Run this after a sync above. Checks Gmail Sent for prior outreach to each unsubscribed address, records the date, and creates a draft (not sent) for anyone with no recent contact.
Step 1 — Household export
Must include columns named P1 Email and/or P2 Email. Include a Zip Code column to carry zip codes to the master list.
Step 2 — Unsubscribe suppression
Unsubscribes will be fetched automatically from Constant Contact when you sync.
Step 1 — Select subcategory
Step 2 — Upload contacts
Paste a CSV or tab-separated export. Source will be auto-detected (ActiveNet, AudienceView, or manual spreadsheet).
Source detection
Detected: —
Step 1 — Google Workspace admin export
Copy your Google Admin user export (First Name, Last Name, Email Address columns, header row included) and paste below. Routed automatically by domain: @scboston.org → Club Management, @skatingacademy.org → Skating Academy Management.
Unsubscribed addresses are checked live against Constant Contact at sync time and excluded/removed automatically — no manual unsub paste needed for this tab.