Why it worked
The video taps into a relatable scenario of being added to group chats for shared goals, like travel, and provides a practical, visually appealing solution for managing savings. The use of a pink-themed, aesthetically pleasing spreadsheet template appeals to a target audience interested in organization and visual content.
Summary
The video shows a Google Sheet template for tracking savings goals. It displays various goals like tuition fees, trips, and specific events, with columns for amount, period, bank, starting month, and status. The user interacts with the sheet, filling in details for a "Vietnam 2027" goal and marking off completed savings periods.
Structure
- 1Introduction of the Google Sheet template
- 2Display of various savings goals
- 3User inputting data for 'Vietnam 2027' goal
- 4Marking off savings periods for different goals
- 5Showing progress bars and completion status
On-screen text
TEMPLATE 2 in PINK_V2
SETUP TABLE
goal name
amount
period
bank
starting month
status
Tuition fee
P40,000.00
10
BPI
Jan 2026
70.00%
Japan Trip
P50,000.00
12
BPI
Jan 2026
50.00%
Digicon
P12,000.00
10
GCash
Jul 2026
33.33%
Taiwan 2027
P30,000.00
10
BPI
Jul 2026
100.00%
Vietnam 2027
P45,000.00
9
BPI
Jul 2026
#DIV/0!
#DIV/0!
#DIV/0!
Welcome to Goal Tracker where you can track your savings for a specific goal. This sheet is composed of a Setup Table and 8 Tracker sheets.
Vietnam 2027
Goal
P45,000.00
Amount Saved
P35,500.00
Remaining Balance
P9,500.00
Bank
BPI
Progress Bar
78.89%
Date
Amount
Status
Jul 2026
5000
Aug 2026
5000
Sep 2026
5000
Oct 2026
5000
Nov 2026
5000
Dec 2026
5000
Jan 2027
5000
Feb 2027
5000
Mar 2027
5000
Tuition fee
Goal
P40,000.00
Amount Saved
P28,000.00
Remaining Balance
P12,000.00
Bank
BPI
Progress Bar
70.00%
Date
Amount
Status
Jan 2026
4000
Feb 2026
4000
Mar 2026
4000
Apr 2026
4000
May 2026
4000
Jun 2026
4000
Jul 2026
4000
Aug 2026
4000
Sep 2026
4000
Oct 2026
4000
Nov 2026
4000
Dec 2026
4000
Japan Trip
Goal
P50,000.00
Amount Saved
P25,000.00
Remaining Balance
P25,000.00
Bank
BPI
Progress Bar
50.00%
Date
Amount
Status
Jan 2026
4166.666667
Feb 2026
4166.666667
Mar 2026
4166.666667
Apr 2026
4166.666667
May 2026
4166.666667
Jun 2026
4166.666667
Jul 2026
4166.666667
Aug 2026
4166.666667
Sep 2026
4166.666667
Oct 2026
4166.666667
Nov 2026
4166.666667
Dec 2026
4166.666667
Instructions
12-Month Goal Tracker
24-Month Goal Tracker
36-Month Goal Tracker