Retention Information SOP
Retention SOP
Back to Home All SOP Buttons
SOP 06

Retention SOP

This page combines the main retention tasks into one clear guide. It covers CSV export checks, Telegram broadcast rules, event prize distribution, token updates, and task list updates.

CSV Export Telegram Broadcast Prize Distribution Token Update Task List Update
Daily Broadcast Telegram broadcast runs every day at 9:00 AM.
Main Event Cut-Off Daily Lottery closes at 5:00 PM. Spinwheel, Heads or Tails, and Lucky Tap close at 7:00 PM.
Important Rule Every assigned task must be added to the task list and marked complete when finished.
Safety Reminder Keep access tokens, server addresses, and passwords in secure storage. Do not place live credentials on shared SOP pages.
Section 01

SOP Export CSV File for Event

Quick Checklist
1

Check total rows

After generating the file, make sure the total row count matches the payment sheet.

2

Check the first username

Using the cut-off time in the payment sheet, confirm the first username matches the first username in the CSV file.

3

Check the last username

Using the same cut-off time, confirm the last username appears as the last username in the CSV file.

4

Check the folder

Make sure there is only one export file inside the Google Drive folder.

Section 02

Telegram Broadcast SOP

Daily Schedule

Broadcast Schedule

Day Times Time
Every Day 1 Time 9:00 AM

Content Rules

  1. Keep content short and impactful, with a maximum of 150 characters.
  2. Put the most attractive element first, such as prizes, bonuses, or rewards.
  3. Keep each broadcast connected to the previous topic.
  4. Plan content topics at least one month in advance.
  5. Use clickbait carefully. It should not be too weak or too strong.
  6. Request banner assets at least one day before use.
  7. Banner size must be 640 × 360 px.
  8. The main banner highlight should be the prize amount or bonus value.
  9. Always use the currency symbol ₱. Do not use words such as credit or peso.
  10. Big win videos must not exceed 20 MB.
Section 03

Event Prize Distribution

Follow Cut-Off Time

Daily Lottery

Cut-Off: 5:00 PM GMT+8 Export: exportDAILYLOTTERY
  1. Update Facebook followers on the Pula Puti sheet.
  2. Go to the Event PYM sheet.
  3. Click Extension, then App Script.
  4. Select exportDAILYLOTTERY from the export drop-down.
  5. Click Run.
  6. Wait until processing is completed.

Spinwheel

Cut-Off: 7:00 PM GMT+8 Export: exportSpinwheel
  1. Go to the Event PYM sheet.
  2. Click Extension, then App Script.
  3. Select exportSpinwheel from the export drop-down.
  4. Click Run.
  5. Wait until processing is completed.

Heads or Tails

Cut-Off: 7:00 PM GMT+8 Export: exportHeadOrTails
  1. Go to the Event PYM sheet.
  2. Click Extension, then App Script.
  3. Select exportHeadOrTails from the export drop-down.
  4. Click Run.
  5. Wait until processing is completed.

Lucky Tap

Cut-Off: 7:00 PM GMT+8 Export: exportLucky
  1. Go to the Event PYM sheet.
  2. Click Extension, then App Script.
  3. Select exportLucky from the export drop-down.
  4. Click Run.
  5. Wait until processing is completed.
Section 04

Token Update

Handle Securely

Main Steps

  1. Go to the Winmaya BO login page.
  2. Press F12, then reload the page.
  3. Sign in with the approved WinmayaBot credentials.
  4. Scroll through the access tokens and find the last access token.
  5. Copy the full details from the last access token.
  6. Open the access token JSON file in Visual Studio Code.
  7. Paste the new token details below the original script.
  8. Find these four values in the pasted script: access_token, expires_at, refresh_token, and refresh_expires_at.
  9. Copy only the values into the original script. Do not copy extra quotation marks or commas.
  10. Save the updated file.
  11. Open the command line and connect to the approved server.
  12. Open tokens.json, replace the old content, save the file, and exit.
  13. Run node fetch.js.
  14. Wait for the result. The process is complete only when the result shows OK:TRUE.
  15. If it still does not show OK:TRUE after retrying, inform RTN ATL immediately.

Values to Copy

  • access_token
  • expires_at
  • refresh_token
  • refresh_expires_at

Important Reminder

Copy only the new values into the original script. Do not copy the extra JSON symbols around the values.

Security Note

For safety, this SOP page does not display the live server IP, password, or raw token values. Use the secure team record for those details.

Section 05

Task List Update

Required for Every Task

Policy

  • Every assigned task must be entered into the task list.
  • Missing task entries will lead to a reminder.
  • Repeated mistakes may lead to a penalty.

Steps

  1. Open Tasks in Lark.
  2. Open the task list and click PHP Retention.
  3. Create or find the correct task group, usually the employee name.
  4. Click the + button beside the task group.
  5. Enter the task name and description.
  6. Click the person icon and assign the task owner.
  7. Click the calendar icon to add the due date.
  8. Set the start date, due date, and time.
  9. When the task is finished, click the circle on the left to mark it as complete.

Open Another SOP

Use these buttons to move quickly to another section.

Broadcast Schedule Performance Check Push Handbook Workflow Monthly Assignment Retention SOP