Lawhat Ada Affiliate: Qalib Notion wa Sheets

Creator at-taam fi Izmir kanat tunfiq 4 saat shahriyan li-nasakh shashat Stripe wa lawhat affiliate thMenu fi Excel. Bada al-intiqal ila qalib Notion plus Sheets nazal hadha al-waqt ila sifr daqiqa; al-saat al-muwaffara dahabat li-Reels jadida.

Safhat Notion ar-Raisia

Fi al-aala khamsat bitaqat: tahawwulat ash-shahr, masdar al-muhtawa al-aqwa, al-tier (Bronze/Silver/Gold/Platinum), isteradat 30 yawman wa MRR mutawaqqa. Kull bitaqa tasahab min linked database Sheets bidun idkhal yadawi.

Asfal, ma'radan: "Top 10 muhtawa 90 yawm" wa "Payout fi al-intizar". Al-thani yatazamn ma queue superadmin wa yubaddil al-halat tilqaiyan inda al-itlaq.

Bayanat Khaam wa Pivot

Tab "raw" yahfaz yawmiyan commission_id, restaurant_slug, plan_type, gross_amount, commission_amount, status wa utm_source. Apps Script yasahab CSV thMenu kull layla as-saat 04:00.

• Pivot 1: Masdar x shahr — ay qana rabihat
• Pivot 2: Khitta x halat — nisbat al-istirdad
• Pivot 3: Mataam x shahr — indhar mubakkir lil-churn

Mulkhas Gemini Usbui

Sigha =GEMINI() tantij mulkhas nass: "12 tahawwul, 80 fi al-mia min TikTok, istirdad 3,2 fi al-mia, tausiya zid mizaniyat TikTok". Kull yawm al-ithnayn as-saat 09:00 yadfa webhook an-nass ila Notion.

Ka-rabit qalib aam, yumkin nasikh al-qalib bi-naqra wahida wa lasq affiliate_id li-tahgil al-amal khilal khams daqaiq. Creator Izmir raat 80 nuskha fi usbu wahid ala Discord.

FAQ

Hal yajib sahb CSV yadawiyan? La, Apps Script yastadi API affiliate thMenu laylan.

Hal yajib khittat Notion madfua? La, al-free yakfi idha baqi at-tarikh fi Sheets.

Hal Gemini amin? Hash asma al-mataim fi amud musaid.

هل وجدت هذا مفيداً؟ شاركه.