Ad Spend Tracking

Ad spend tracking in MerchantFlow automatically syncs advertising cost data from Meta, Google, TikTok, and Snapchat into a unified dashboard, giving you a complete picture of marketing costs and return on ad spend (ROAS) across all channels without manual data entry.

Supported Advertising Platforms

MerchantFlow tracks ad spend from the following platforms:

• Meta (Facebook and Instagram Ads)
• Google (Google Ads)
• TikTok (TikTok Ads)
• Snapchat (Snapchat Ads)

Each platform integration syncs the following data:

• Spend - total amount spent in your currency
• Currency - the currency of the ad account
• Impressions - number of times ads were shown
• Clicks - number of clicks on your ads
• Conversions - number of completed purchases or actions
• Cost per Conversion - average cost to generate one conversion

How to Access Ad Spend Data

Navigate to Dashboard > P&L to view your ad spend data.

Available views:

• By Platform - compare spend across Meta, Google, TikTok, and Snapchat
• By Campaign - drill into individual campaign performance
• By Date - view daily, weekly, or monthly spend trends

How Ad Spend Syncing Works

Automatic Sync

MerchantFlow syncs ad data from all connected ad platforms every 12 hours. This ensures your P&L calculations stay current without manual intervention.

What gets synced:

• Daily spend amounts
• Campaign-level performance metrics
• Impressions, clicks, and conversions
• Cost per conversion

Sync Coverage Tracking

MerchantFlow tracks the status of every sync attempt per provider and per date:

• Successful - data synced completely
• Partial - some data synced, but gaps exist
• Failed - sync did not complete (will retry)

You can check sync status at Dashboard > P&L to verify your ad data is up to date.

Deduplication

MerchantFlow includes built-in deduplication logic to prevent double-counting ad spend. If the same data is synced more than once (for example, due to a retry after a partial sync), duplicates are automatically detected and removed.

What Is ROAS and How Is It Calculated?

Return on Ad Spend (ROAS) measures how much revenue you generate for every dollar spent on advertising:

ROAS = Revenue / Ad Spend

Example:

• Revenue: $10,000
• Ad Spend: $2,500
• ROAS: 4x (every $1 spent generated $4 in revenue)

ROAS Benchmarks:

• 3x: Minimum for most e-commerce businesses
• 4-5x: Good performance
• 6x+: Excellent performance

ROAS is displayed per platform, per campaign, and across your entire ad portfolio.

How Ad Spend Feeds Into P&L Calculations

Ad spend feeds directly into your Profit & Loss calculations as part of total expenses:

Gross Profit = Revenue - COGS - Ad Spend

Net Profit = Revenue - COGS - Ad Spend - All Other Expenses

Why this matters: Even if a product has high revenue and low COGS, heavy ad spend can erode profitability. Tracking ad spend alongside other costs gives you the true picture.

How to Set Up Ad Spend Tracking

Step 1: Connect Ad Platforms

1. Go to Settings > Integrations on merchantflow.ai
2. Find the ad platform you want to connect (Meta, Google, TikTok, or Snapchat)
3. Click "Connect" and authorize access
4. Grant read permissions for ad account data

Step 2: Wait for Initial Sync

After connecting, MerchantFlow performs an initial sync of your ad data. This may take a few minutes depending on your account history.

Step 3: Verify Data

1. Navigate to Dashboard > P&L
2. Check that ad spend totals match your platform dashboards
3. Verify that all campaigns are listed

Best Practices for Ad Spend Tracking

1. Connect All Platforms

Connect every ad platform you use. Missing platforms mean incomplete P&L data and inaccurate profit calculations.

2. Monitor ROAS Weekly

Check ROAS at least weekly to catch underperforming campaigns early before they consume budget without adequate return.

3. Verify Sync Status

Periodically check that syncs are completing successfully. Failed syncs can lead to inaccurate P&L data. See Sync Status for monitoring guidance.

4. Pair with COGS Data

Ad spend analysis is most valuable when paired with accurate COGS. Together, they reveal true product profitability. See COGS Management.

Troubleshooting Ad Spend Issues

Ad spend shows $0

Possible causes:

• Ad platform not connected
• Initial sync still in progress
• No active campaigns during the selected date range

Solutions:

1. Check integration status at Settings > Integrations
2. Wait for sync to complete (up to 12 hours for first sync)
3. Adjust the date range to include active campaign periods

Data does not match platform dashboard

Possible causes:

• Sync timing difference (MerchantFlow syncs every 12 hours)
• Currency conversion differences
• Date range mismatch

Solutions:

1. Wait for the next sync cycle
2. Verify currency settings match your ad accounts
3. Ensure you are comparing the same date range

Missing campaigns

Possible causes:

• Campaigns created after last sync
• Insufficient permissions on ad platform

Solutions:

1. Wait for the next automatic sync
2. Re-authorize the integration with full ad account read permissions

Frequently Asked Questions

How often does MerchantFlow sync ad spend data?

Ad spend data syncs every 12 hours from all connected platforms. You can also trigger a manual sync to pull the latest data immediately.

Does MerchantFlow track ad spend from email and SMS platforms?

Not automatically. For channels like Klaviyo or Mailchimp, you can manually enter ad spend in the P&L section and attribute it to the correct channel.

Why does my MerchantFlow ROAS differ from my ad platform ROAS?

Ad platforms often use their own attribution models (such as view-through conversions or longer attribution windows), while MerchantFlow uses last-touch attribution based on order data. Small differences are normal and expected.

Can I see ad spend at the product level?

Ad spend is displayed at the platform and campaign level. Product-level ad spend attribution depends on your campaign structure and UTM tracking setup.

Related Topics

• P&L Overview - Complete profit tracking
• COGS Management - Manage product costs
• Profit Margins - Analyze profitability
• Expense Tracking - Track all business expenses
• Burn Rate & Runway - Cash flow analysis
• Attribution - Channel revenue attribution

Last updated: March 14, 2026