เทมเพลต Excel / Google Sheets

Ads & Sales Dashboard Template

Daily ad spend, clicks, orders and sales
Auto CTR, CPC, ROAS and cost per order
ROAS target by channel
Dashboard with daily and channel charts

฿99Lifetime

About this template

A daily ads and sales dashboard. Enter ad spend, impressions, clicks, orders and sales per channel; CTR, CPC, cost per order and ROAS are calculated, ROAS below target turns red, with trend and channel comparison charts.

Screenshots from the real file

Who it is for

People running Facebook, TikTok, Shopee and Google ads
Online shop owners checking whether ads pay off
Admins and freelancers reporting results to clients

What you get out of it

Know which ad channel pays off best
See at once when ROAS drops below target
Keep ad spend within budget
A report ready to share with clients or your team

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean

DashboardTotal spend, total sales, overall ROAS, orders, cost per order, budget used, ROAS target and daily trend charts

Daily dataDate, channel, spend, impressions, clicks, orders and sales; CTR, CPC, cost per order, ROAS and sales after ad cost are calculated

SettingsYour ad channels

How to use it

In "Settings", add your ad channels
Each day, enter each channel's numbers in "Daily data"
Set your ROAS target and monthly budget in "Dashboard"
Review trends and compare channels in "Dashboard"

What you receive

Excel file (.xlsx), 64 KB, ready to download right after payment
A Google Sheets link that makes your own copy in Google Drive, usable on mobile
Sample data on every tab so you can see how to fill it in, then replace it with yours
Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is Ads & Sales Dashboard Template for?

People running Facebook, TikTok, Shopee and Google ads; Online shop owners checking whether ads pay off; Admins and freelancers reporting results to clients

What's inside the file?

3 tabs: Dashboard, Daily data, Settings, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet