Dashboard Effektivnosti Affiliate: Shablon Notion i Sheets

Food-creator iz Izmira tratil 4 chasa v mesyats, kopiruya ekrany Stripe i panel affiliate thMenu v Excel. Posle perekhoda na shablon Notion plyus Sheets eto vremya upalo do nulya; osvobodivshiyesya chasy ushli na novyye Reels.

Glavnaya Notion

Vverkhu pyat metricheskikh kartochek: konversii mesyatsa, samyy silnyy kontent-istochnik, tekushchiy tier (Bronze/Silver/Gold/Platinum), refundy za 30 dney i prognoz MRR. Kazhdaya kartochka tyanetsya iz linked database Sheets bez ruchnogo vvoda.

Nizhe dve galerei: "Top 10 kontent" i "Pending Payouts". Vtoraya sinkhroniziruyetsya s ocheredyu superadmina i menyaet status avtomaticheski posle vyplaty.

Syroye Sheets i Pivoty

Tab "raw" khranit ezhednevno commission_id, restaurant_slug, plan_type, gross_amount, commission_amount, status i utm_source. Apps Script tyanet CSV thMenu kazhduyu noch v 04:00.

• Pivot 1: Istochnik x mesyats — kakoy kanal zarabotal
• Pivot 2: Plan x status — protsent refundov
• Pivot 3: Restoran x mesyats — ranniy signal churn

Nedelnoe Rezyume Gemini

Formula =GEMINI() sozdaet tekstovyy daydzhest: "12 konversiy, 80 protsentov TikTok, refund 3,2 protsenta, sovet uvelichit byudzhet TikTok". Po ponedelnikam v 09:00 webhook otpravlyaet rezultat v Notion.

Kak publichnyy template-link shablon duplitsiruetsya v odin klik: vstavit affiliate_id, i cherez pyat minut vse rabotaet. Izmir creator uvidel 80 duplikatov za nedelyu v Discord.

FAQ

CSV vruchnuyu? Net, Apps Script vyzyvayet API affiliate thMenu nochyu.

Nuzhen platnyy Notion? Free plan dostatochno, esli istoriya zhivet v Sheets.

Gemini bezopasen? Khesh imena restoranov vo vspomogatelnoy kolonke.

Было полезно? Поделитесь.