How do I keep track of all my PPV content?
Keep one spreadsheet with one row for every piece you sell: its code, name, level, a caption that worked, tags, where the files are, and whether it is live or retired. Add a second tab where you write down every mass message you send.
Your vault holds the files. It doesn't tell you what you've sent, what sold, or what you haven't used in months. A simple spreadsheet does.
Tab 1: Your content, one row per piece
| Column | What goes in it |
|---|---|
| Code | The piece's code, like MIA-260920-L3 |
| Shoot | The creator code and date, so pieces from one shoot sit together |
| Level | 1 to 5 |
| Name | A few words for what it is |
| Caption | A caption that worked, as a starting point |
| Tags | Keywords, separated by commas |
| Files | Where the originals are saved |
| Buyers' list | The name of the fan list for buyers. It's the same as the code |
| Status | Live, retired or archived |
| Times sent | How many times it has gone out |
| Last sent | The date it last went out |
Sort by Shoot, and the levels of each shoot line up together. Don't have codes yet? Start here.
Tab 2: Your sends, one row per mass message
| Column | What goes in it |
|---|---|
| Date | The day it goes out |
| Code | Which piece |
| Sent to | Which fans |
| Status | Planned or sent |
This is your weekly plan and your history in one place. Times sent and last sent on the first tab come from here.
Rules that keep it trustworthy
- One row per piece, one code per row. No blanks and no repeats.
- Add a piece the day you upload it. Not later.
- Change the status, don't delete the row. Retiring keeps the history.
- Mark every send. If a send isn't written down, your counts are wrong.
What to leave out
Who bought what. That lives in your fan lists, one list per piece, named with the code. How that works.
The free vault name builder makes the code and names for each new row.
Other questions people ask
Should prices go in the spreadsheet?
You can leave them out. The level tells you roughly what a piece sells for, and the real price is set when you send it.
What do I use this for day to day?
Three things: picking what to send this week, seeing what has not gone out in a while, and finding a caption that already worked.
Is a spreadsheet enough as my page grows?
It works for a long time if you keep it up every day. When that gets to be too much, a tool that does the tracking for you takes over the same job.