SellFire Media — ROAS & Sales Dashboard

ROAS

—

Total Revenue

—

Website Revenue

—

Messenger Revenue

—

Lead Form Revenue

—

Total Ad Spend

—

Profit Estimate

—

Revenue vs Ad Spend

Revenue Breakdown

Recent Orders (GHL)

Customer	Campaign	Date	Amount	Status

Spend by Campaign

Campaign	Spend	Purchases	Revenue	ROAS

Meta Ad Spend

Synced automatically every 30–60 minutes from the Meta Marketing API.

Date	Campaign	Spend	Reach	Impr.	Clicks	Purchases	Purch. Value	ROAS

GoHighLevel Orders

Synced automatically every 10–15 minutes. Counted as Website Sales.

Order ID	Customer	Campaign	Date	Amount	Status

Messenger Sales (Manual)

Sales closed in Messenger — entered by staff.

Customer	Campaign	Date	Amount	Notes	Actions

Lead Form Sales (Manual)

Sales converted from lead forms — entered by staff.

Customer	Campaign	Date	Lead Source	Amount	Notes	Actions

f Meta Ads

Not connected

Meta Marketing API — syncs Spend, Reach, Impressions, Clicks, Purchases & Purchase Value.

Ad Account ID Access Token Sync frequency

Last sync: —

GHL GoHighLevel

Not connected

GHL API — syncs New Orders, Order Status, Customer Details, Revenue & Pipeline updates.

Location ID API Key Sync frequency

Last sync: —

How credentials are used: keys entered here are stored in your browser and forwarded once to your Google Apps Script backend (action=saveIntegrations), which keeps them in the protected Dashboard Settings sheet and runs the scheduled syncs server-side. The Meta Access Token and GHL API Key are never exposed to other dashboard users. If no backend URL is set in Settings, the dashboard simulates the connection with demo data so you can preview the full flow.

User Management

Name	Email	Role	Assigned Client	Status	Last Login

Activity Logs

Time	User	Action	Details

Backend Connection

Paste your Google Apps Script Web App URL. The dashboard talks to it via JSONP (no CORS issues). While empty, the dashboard runs on built-in demo data.

Apps Script Web App URL Profit margin used for Profit Estimate (%)

All amounts across the dashboard are shown in Sri Lankan Rupees (LKR).

ROAS & Sales Dashboard