Methodical — Ad Spend & COD Order Tracking

COD Orders

Orders Sent

—orders

—

Orders Delivered

—orders

—

Payments Received

—orders

—

Payments Pending (delivered, unpaid)

—orders

—

Products Returns

—orders

—

Advertising & Reimbursement

Total Ad Spend

—

Total Reimbursed

—

Outstanding Balance (Spend − Reimbursed)

—

Daily Ad Spend

Order Pipeline

Revenue by Product

Sum of order value per product — price only, delivery fee excluded.

Total (all products)

—

Product	Orders	Price Total (excl. delivery)	Delivery Total	% of revenue

Payment Summary

Unmatched Records

0

Ref No	From Upload	Details	When

f Meta Ad Account

Demo mode

Account Name

—

Account ID

—

Currency

—

Status

—

Showing ads matching your product names: Methodical, Dashboard only.

Spend (selected period)

—

Rolling Total (all time)

—

This Month

—

Last Month

—

Campaign Breakdown

Campaign	Spend	% of total

Monthly Summary

Month	Spend	Reimbursed	Outstanding

Spend History (daily, per ad)

Date	Campaign	Campaign ID	Ad Set	Ad Name	Spend (LKR)	Last Sync

Total Ad Spend (synced + previous)

—

Total Reimbursed

—

Outstanding Balance

—

Previous Ad Spend (opening)

—

Previous / Opening Ad Spend

Ad spend from earlier months that is not in the Meta sync (e.g. amounts already payable before this dashboard started). This is added to the synced spend to give the true Total Ad Spend and Outstanding Balance. It is never overwritten by a Meta sync.

Amount (LKR)

Reimbursements from Methodical

Recorded manually by the Accounts Executive.

Date	Amount (LKR)	Notes	Entered By	Actions

Orders Master

Ref No	Product	Order Value	Delivery	Status	Payment	Amount Received	Date Sent	Date Delivered	Date Paid	Date Returned

Products

—

Avg. Product Price (excl. delivery)

—

Lowest Price

—

Highest Price

—

Product Catalogue

Product price is stored separately from the delivery fee — dashboard order value always shows the price without delivery.

Product Name	Product Price (excl. delivery)	Delivery Fee	Total w/ Delivery	Actions

Upload History

When	Type	File	By	Imported	Warnings	Rejected	Unmatched

Reports & Exports

Exports respect the global date filter ().

Activity Logs

Time	User	Action	Details

Backend Connection

Paste the Google Apps Script Web App URL. The dashboard uses JSONP with a random callback parameter and cache-busting — no CORS issues from EdgeOne. Empty = demo mode.

Apps Script Web App URL API Key (required — must match the API_KEY set in the backend Script Properties) Meta returns spend in minor units — divide synced values by 100 Upload date format (how dates in your CSV/Excel files are written) Extra Meta ad keywords (optional — your Product names are used automatically; add extra comma-separated keywords here)

Data Management

The dashboard ships with sample data so you can test. Clear it here to start fresh with only your real records. This affects data stored in this browser only — it does not touch your Google Sheets.

Ad Spend & COD Order Tracking

Dashboard

COD Orders

Advertising & Reimbursement

Daily Ad Spend

Order Pipeline

Revenue by Product

Payment Summary

Unmatched Records

f Meta Ad Account

Campaign Breakdown

Monthly Summary

Spend History (daily, per ad)

Previous / Opening Ad Spend

Reimbursements from Methodical

Orders Master

Product Catalogue

Upload History

Reports & Exports

Activity Logs

Backend Connection

Data Management

Add Reimbursement

Add Product