The formula and inputs for an Etsy Offsite Ads margin calculation
Last updated: 2026-07-30
Written and reviewed by Seller Profit Guard Editorial Team.
Add item price, buyer-paid shipping, gift wrap, separately charged paid personalization, and any tax that belongs in the applicable fee base. Multiply by the seller’s current 15% or 12% Offsite Ads rate, apply the $100 USD per-order cap in the correct currency, then subtract that fee, other Etsy fees, direct costs, and expected return loss.
attributed-order formula: scope and decision
This calculation starts with the attributed order, not a monthly ad budget. Etsy charges the Offsite Ads fee only when a qualifying click is followed by an order from the shop inside the current attribution window. The seller must verify that condition before applying a rate.
Separate the order-revenue total from the policy fee base. Item price, buyer-paid shipping, gift wrap, personalization, and some tax treatment can affect the base. Record each component and jurisdiction instead of assuming every displayed checkout total is chargeable in the same way.
Build the Offsite Ads contribution worksheet before acting
The calculator multiplies the documented base by the applicable 15 or 12 percent rate and then applies a seller-entered cap converted into the model currency. The published cap is $100 USD per attributed order; conversion evidence matters outside a USD model.
Contribution equals order revenue minus the applied Offsite Ads fee, other reconciled Etsy fees, product and direct labor, packaging, shipping label, other variable cost, and expected return loss. It is an operating estimate, not final accounting profit.
Confirm the attribution state first
Check the Offsite Ads dashboard and order evidence. A click without a purchase, a purchase outside the window, or a qualifying last click through Etsy Ads changes whether the Offsite Ads fee belongs in this order model.
For “Confirm the attribution state first,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Confirm the attribution state first” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Build the policy fee base
Record item revenue, buyer-paid shipping, gift wrap, and separately charged paid personalization in distinct rows, then add the precise tax treatment that applies to the seller and jurisdiction. Do not silently use payout or deposit as the fee base.
For “Build the policy fee base,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Build the policy fee base” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Select 15 percent or 12 percent
Use 15 percent only for the applicable under-threshold enrolled state and 12 percent only after the shop has met Etsy's threshold rule. Store the effective month and account evidence.
For “Select 15 percent or 12 percent,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Select 15 percent or 12 percent” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Apply the cap after the percentage
Calculate the uncapped fee, then compare it with the $100 USD per-order cap converted using documented currency evidence. A zero or arbitrary local-currency cap should block interpretation.
For “Apply the cap after the percentage,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Apply the cap after the percentage” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Enter other Etsy fees separately
Listing, transaction, payment processing, currency conversion, regulatory, and seller-service tax rows remain outside this focused advertising calculation. Bring in a reconciled subtotal without relabeling it as ad spend.
For “Enter other Etsy fees separately,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Enter other Etsy fees separately” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Subtract direct product and fulfillment cost
Use SKU bill of materials, direct labor, packaging, carrier label, insurance, and other order-variable evidence. Buyer-paid shipping is revenue; the shipping label is cost.
For “Subtract direct product and fulfillment cost,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Subtract direct product and fulfillment cost” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Add expected return loss explicitly
Model return probability and loss in a separate estimator or enter a reconciled expected amount. Do not claim an attributed sale is profitable while excluding a material return pattern.
For “Add expected return loss explicitly,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Add expected return loss explicitly” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Compare a seller-owned contribution target
Ready requires contribution at or above the target and no unresolved evidence conflict. Revise, Stop, and Block preserve distinct financial and evidence states.
For “Compare a seller-owned contribution target,” keep attribution, base, percentage, cap, other fees, direct costs, expected return loss, target, and currency as separate rows in the Offsite Ads contribution worksheet. Reproduce one $45 attributed order at 15 percent, then hold the same order without verified attribution until its evidence state is explicit. That separation produces retained contribution after the advertising fee without turning a conditional advertising fee into a universal marketplace rate.
Test “Compare a seller-owned contribution target” with a 15 percent case, a 12 percent case, a fee-cap case, and a declared-conflict case. The tests must preserve full-precision arithmetic, display rounding, cap behavior, target comparison, and Block precedence. For one $45 attributed order at 15 percent, attach the official rule and expected result. For the same order without verified attribution, require attribution evidence before applying any fee.
Verification, release, and statement feedback
Before changing price, shipping, promotion, participation assumptions, or calculator defaults, preserve the Offsite Ads contribution worksheet, official-source versions, account evidence pointer, current inputs, expected fixtures, tests, build, route state, and rollback identifier. Confirm the exact target environment and safe-stop on an unexpected account or production context.
After one bounded action, rerun one $45 attributed order at 15 percent, the same order without verified attribution, the cap fixture, and a declared-conflict fixture. Inspect full-precision and displayed amounts, mobile results, canonical, sources, original visuals, internal links, and the approved private statement observation. Restore the prior packet if a critical result cannot support retained contribution after the advertising fee.
Limits, privacy boundary, and next action
This guide and calculator use seller-entered summaries and synthetic fixtures. They do not retrieve Etsy data, authenticate attribution, choose a rate, convert the cap automatically, settle tax, reproduce every refund or payout, estimate incrementality, change advertising, or prove ranking, traffic, qualified intent, AdSense approval, income, or final profit.
Keep buyer names, emails, addresses, messages, order IDs, payment rows, bank details, tax identifiers, labels, tokens, OAuth material, credentials, and raw CSV outside the Offsite Ads contribution worksheet. Verify current Etsy sources and the seller's actual account, reconcile an approved privacy-safe sample, record closure or rollback, and obtain qualified accounting, tax, or legal advice when material.
Sources and further reading
- Etsy Help: How Offsite Ads Work: Current 30-day attribution, 15% and 12% fee rates, $100 USD per-order cap, enrollment, threshold, dashboard, and last-click boundary.
- Etsy Fees and Payments Policy: Controlling fee-base, attributed-order, 365-day sales test, tax, currency, cap, opt-out, and lifetime-participation policy language.
- Etsy Advertising and Marketing Policy: Current responsibilities and program terms for Etsy Ads and Offsite Ads.
- Etsy Help: Fees and Taxes for Selling: Current advertising-fee summary and the surrounding listing, transaction, processing, conversion, regulatory, and seller-fee tax boundaries.
- Etsy Help: How to Use Etsy Stats: Current traffic-source and Offsite Ads attribution observations available to a seller.
- Etsy Help: Manage Your Payment Account: Payment account, monthly statement, refund, credit, balance, reserve, shipping, and payout reconciliation context.
- Seller Profit Guard methodology: Local-first calculations, evidence hierarchy, privacy-safe fixtures, deterministic tests, bounded release, correction, and rollback.
Related Seller Profit Guard tools
- Open the Etsy Offsite Ads Margin Calculator: Model one attributed order under the current 15% or 12% rate and cap.
- Build the complete Etsy fee stack: Itemize every other marketplace fee before isolating the advertising consequence.
- Run the main Seller Profit Guard: Carry the reconciled ad fee into SKU-level cost, shipping, return, and target-profit analysis.
- Reconcile the Etsy Payment account: Compare modeled attribution and fees with actual statement rows, refunds, credits, and payouts.
- Read the Offsite Ads profit guide: Review the existing operating workflow for attributed orders and retained contribution.
- Read the local-first methodology: Keep buyer, order, payment, bank, contact, and credential data outside public pages and analytics.
- Etsy Offsite Ads 15% Fee: Worked Example: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Etsy Offsite Ads 12% Margin Scenario: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
- 12 Etsy Offsite Ads Margin Mistakes: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Reliable Etsy Offsite Ads Margin Data: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Etsy Offsite Ads Margin Decision Thresholds: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
Next step: Open the Etsy Offsite Ads Margin Calculator.
This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.