📣 Top up ฿1,000+ get 5% bonus · ฿3,000+ get 10% bonus
THEN 🛒 Sign upLog in
Products & Services
Online Courses
Ai Tools & Software
Ebook
Prompt/Skill
Ai Knowledge
Ai for Careers
Sign upLog in

Excel/Sheets Templates

Ready-made templates with formulas for Excel and Google Sheets

AllAI SoftwareSkillPromptseBooksOnline CoursesExcel/Sheets Templates
เทมเพลต Excel/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
฿199Lifetime
 

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

Ads and sales dashboard
Ads and sales dashboard
Daily data
Daily data
Channel settings
Channel settings

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

  1. In "Settings", add your ad channels
  2. Each day, enter each channel's numbers in "Daily data"
  3. Set your ROAS target and monthly budget in "Dashboard"
  4. 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

Product reviews

No reviews yet