How to Make Money with a Review Campaign Tracker Template: A Free Excel Sheet So You Never Miss a Deadline (2026)

Step-by-step

Step 1. Prepare the file (10 min)

1. Download it and rename it, e.g. 2026-review-campaigns.xlsx.
2. To use it on your phone, upload it to Google Drive and choose “Open with Google Sheets”.
3. Look at the 3 gray example rows. Then clear their contents instead of deleting the rows, so the D-day formula stays.
4. Check that the year cell (B2) on the monthly summary sheet is this year.

Step 2. When you apply (1 min)

• Enter platform, campaign name and type (visit / delivery / reporter).
• Write the apply date as 2026-11-03. The summary only works with this format.
• Set status to 신청함 (applied).
• Note what the campaign offers (e.g. a ₩30,000 meal voucher).

Step 3. When results come out (1 min)

• Pick 선정 (selected) or 미선정 (not selected).
• If selected, set status to 선정됨 and enter the posting deadline from the campaign page.
• D-day shows days left, like D-12. After the deadline it shows D+2.
• If not selected, set status to 미선정. D-day goes blank.

Step 4. On the visit/receive day (1 min)

• Enter the visit/receive date.
• Enter the offered value in value (KRW). If unknown, use the product’s normal price as a guide.
• Enter any cash fee separately.
• Set status to 체험 완료 (experienced).

Step 5. When you post (2 min)

1. Make sure the title or first part has a clear sponsorship label. Copy wording from sheet ③ and adjust it.
2. Paste the post URL.
3. Mark the disclosure column O.
4. Set status to 포스팅 완료 (posted). D-day and color clear.
5. Register the URL on the platform too. Writing it only in the sheet doesn’t count as submitting.

If status is “posted” but disclosure isn’t O, the row turns yellow. Fix the label in your post.

Korea’s Fair Trade Commission guideline on endorsements says every post made in return for something (free products, meals, points, fees) must be clearly disclosed. On blogs, put it in the title or first part, larger or in a different color. Writing only “체험단” (review group) or hiding it in comments or “more” is not enough.

Step 6. 5-minute morning check

• Handle red (overdue) and orange (3 days or less) rows first.
• Use the filter button on the header row (row 4) to show only “selected” and “experienced” rows.

Step 7. Month-end check (5 min)

• Selection rate = selections ÷ applications. If low, improve your application text and blog topic.
• If completed is far below selections, you applied to too many. Apply less next month.
• Compare value + cash by platform to see which suits you.

Applications and selections count by apply date; completed, value and cash count by visit/receive date.

Tax note

Items, vouchers, points and fees may count as income in some cases. Ask the National Tax Service at 126 whether you need to report. This file is for record-keeping, not tax advice.

First-week plan

Common mistakes

1. Writing dates like 11/3 → D-day and summary won’t calculate. Use 2026-11-03.
2. Deleting example rows and losing formulas → clear contents only. If lost, copy a D-day cell from a row below.
3. Not updating status → posted campaigns stay red. Switch to “posted”.
4. Forgetting to register the URL on the platform → logging it is not submitting it.
5. Labeling only “체험단” → not enough under the FTC guideline. Use something like “[협찬] Received for free”.
6. Applying to too many at once → deadlines clash. Stop applying when you have more than 3 orange rows.
7. Inflating values → it only ruins your own records.

Sources: Guideline on Endorsement and Testimonial Advertising (Korea Law Information Center, FTC Rule No. 499, effective 2026-06-01), Korea.kr policy briefing on blog review ads (2024-11-20) (checked October 2026). Tax questions: National Tax Service 126. This template is for record-keeping, not legal or tax advice.

Watch out for these scams

Some sellers push paid programs or courses with “guaranteed selection” or “this tool makes you money”. Others say you were selected and ask for shipping fees or a deposit first, or ask for your blog ID and password. Review campaigns usually don’t ask bloggers to pay first. Never share account details, and if something feels wrong, ask the platform’s official customer center.