ActiveCampaign shows you opens and clicks. It stops short of connecting those campaigns to the revenue they earned, unless your store sits on a supported platform and the sale closes inside a fixed seven-day window. Sendlens closes that gap. Once your account is synced, you bring your conversion data in one of two ways, and Sendlens attributes every purchase back to the campaigns that drove it.
Connect ActiveCampaign first. Under DataSources choose Add source, pick ActiveCampaign, and paste your account URL and API key. Sendlens then syncs your campaigns, automations, opens, and clicks on its own. Everything below adds the conversion side on top of that, so the two meet inside one report.
Both paths end in the same place: revenue attributed to the campaigns that earned it. Pick the one that matches where your order data lives.
Sendlens pulls every order for you and keeps the data current. No files, no upkeep. Best when your store runs on a platform Sendlens can connect to.
Export your orders, drop them in, done. Works with any ecommerce store, even the most custom checkout, with no connection, API, or engineering.
When your store is on a platform Sendlens can talk to, this is the whole job: connect it once. From then on every order flows in on its own and the attribution stays live without you touching a spreadsheet again.
Go to DataSources. This is where every connected account lives, from your ESP to your store.
Press Add source and pick your store from the platform list.
Approve the connection so Sendlens can read your orders. Sendlens confirms it worked before saving.
Orders start flowing in and refresh on a schedule. Sendlens matches each buyer to your contacts and lines the purchases up against the campaigns they received.
This is the path that fits everyone. A one-off Shopify export, a Stripe report, a query against your own database, a hand-built sheet from a marketplace: if you can get it into five columns, Sendlens can attribute it. No connection, no API, no engineering ticket.
Go to DataConversions.
Press Download template to get a CSV with the exact headers Sendlens expects.
One row per conversion. Match the five columns below. Leave revenue and order id blank for events that carry no money.
Drag the file onto the upload area, or click to browse. Sendlens reads it, removes duplicates, and shows a summary of what imported.
This is the whole template. Two columns identify the conversion, one carries the money, one keeps things deduplicated, and one labels the event.
| Column | Required | What it holds | Example |
|---|---|---|---|
email | Required | The customer email, matched to your contacts | [email protected] |
order_date | Required | When the conversion happened (YYYY-MM-DD) | 2026-06-15 |
revenue | Purchases | Order value, numbers only, blank for non-sales | 79.99 |
order_id | Optional | Your store reference, used to remove duplicates | ORD-1001 |
conversion_type | Required | A label such as purchase or signup | purchase |
email,order_date,revenue,order_id,conversion_type
[email protected],2026-06-15,79.99,ORD-1001,purchase
[email protected],2026-06-16,,,signupHowever the data got in, it lands in the same reports. The main one is the attribution view, where every campaign gets its conversions and its revenue, split by whether an open or a click earned it.
| Campaign | Conversions | Open-attr. | Click-attr. | Rev (opens) | Rev (clicks) |
|---|---|---|---|---|---|
Spring sale announcement | 13 | 13 | 6 | € 1.462 | € 704 |
Weekly newsletter, June | 8 | 8 | 0 | € 350 | - |
New arrivals, premium tier | 7 | 7 | 1 | € 597 | € 30 |
Restock reminder | 5 | 5 | 2 | € 375 | € 136 |
Conversions and revenue per campaign, split into open-attributed and click-attributed. Change the window between 1, 3, 7, 14, and 30 days and press Recompute.
Conversion rate and open-to-conversion trended over time, right next to open rate and click rate, so you see the whole funnel move together.
Pull everything as a clean CSV: campaigns, conversions, and the attribution behind them, ready for your own sheet or BI tool.
The mechanism is simple to reason about. For every conversion you bring in, Sendlens finds the contact by email address, then looks back across your attribution window for ActiveCampaign campaigns that contact opened or clicked before the conversion happened. Those campaigns get the credit.
Credit is reported two ways at once. Open-attributed revenue covers conversions where the contact opened the campaign first. Click-attributed revenue covers the ones who clicked. Keeping them apart matters, because opens and clicks often tell different stories about different parts of your list. A campaign can pull strong open-driven revenue and almost no click-driven revenue, and that is worth knowing.
The attribution window is yours to set. Seven days is the default because it is what most operators expect, but it is one of five. A product launch, a considered purchase, or a longer business-to-business cycle rarely closes in a week, so widen the window to 14 or 30 days and press Recompute. The revenue and conversion numbers recalculate for the window you chose. It is a display choice, so you can move it as often as the question changes.
This is also the difference from what ActiveCampaign can do on its own. Its revenue reporting is fixed at seven days, limited to a handful of supported ecommerce platforms, and reported inside a separate dashboard. Sendlens takes your data from any store, across a window you control, and reports it next to the opens and clicks for the same campaigns. For the full picture of what ActiveCampaign reports and where the gaps are, read ActiveCampaign analytics and reporting limitations.
Sendlens syncs your ActiveCampaign campaigns, opens, and clicks automatically over the API. Conversions and revenue are different. ActiveCampaign only ties revenue to campaigns through Deep Data, inside a fixed 7-day window, and only for a handful of supported ecommerce platforms. So in Sendlens you supply the conversion data yourself, either by connecting your store or by uploading a CSV, and Sendlens does the attribution.
You connect your store under Data then Sources with Add source. Once connected, Sendlens pulls every order automatically and keeps the data current, so you never touch a spreadsheet. If your store is custom or your revenue lives in a system without a direct connection, use the CSV upload instead. It reaches the same attribution.
Five columns: email, order_date, revenue, order_id, and conversion_type. Email and order_date identify who converted and when. Revenue is the order value for purchases. Order_id is your store's reference and is used to remove duplicates. Conversion_type is a label such as purchase or signup. For events that carry no money, like a signup, you can leave revenue and order_id blank. Download the ready-made template inside Data then Conversions.
No, and it never will. Sendlens does not store the personal data of the people who receive, open, or click your campaigns, and it handles your ecommerce buyers and their orders exactly the same way. Identifiers such as email addresses are put through heavy one-way hashing the moment they arrive, before anything is saved. A hash lets Sendlens line a conversion up with the contact who earned it, because the same input always produces the same hash, yet it cannot be turned back into the original address. The readable personal details are never written to disk and cannot be retrieved from Sendlens by anyone, us included. You keep the attribution, and your subscribers and buyers keep their privacy.
Re-uploading is safe. Sendlens matches rows it has already seen on order_id and on the email plus date pair, counts them as duplicates, and skips them. After each upload you see a summary with rows read, imported, skipped, and duplicates, so you always know exactly what landed.
For each conversion, Sendlens finds the contact by email and looks back across your attribution window for ActiveCampaign campaigns that contact opened or clicked before the conversion. Credit is split into open-attributed and click-attributed, and revenue is reported both ways, so you can see whether opens or clicks are driving the money.
Yes. On the Insights then Attribution page you pick a window of 1, 3, 7, 14, or 30 days and press Recompute. The conversion counts and revenue recalculate for the window you chose. Set it to match your real sales cycle rather than being capped at a fixed number.
Three places. Insights then Attribution lists conversions and revenue per campaign with the open and click split. Insights then Timeline trends conversion rate and open-to-conversion over time next to your open and click rates. Data then Exports lets you download everything as a clean CSV for your own analysis.
No. Sendlens is not an email sender. You keep ActiveCampaign as your sender, automation canvas, and deliverability layer. Sendlens connects with an API key, syncs your campaigns, takes in your conversion data, and adds the attribution and reporting layer on top.
Connect an ESP. Let Sendlens do the rest. See the design patterns behind your best campaigns in under 10 minutes.