KYZN Docs
Home
  • Welcome
  • Intro
    • What is KYZN?
    • Age Group
  • KYZN Funnel
    • Glossary
      • General
      • Tracking Framework
    • Report
      • TAC Funnel
      • TCC Funnel
      • TAC Sleekflow
  • KYZN CRM
    • Glossary
      • My Leads
        • Add Leads
        • Add Family Leads
        • Add Appointment
        • Add Membership
        • Edit Branch
        • Edit PIC
        • Edit & Delete Leads
        • Search Leads
        • Reschedule Appointment
        • Clear Abnormal Stage
      • Approach
      • Pool
      • My Appt
        • Edit & Delete Appointment
        • Trial Form
      • My Convert
      • User Manager
      • UTM Generator
      • Assign PIC
      • Set Target
      • Schedule List
    • Event Bulk Data
  • Digital System
    • ETL Process
      • Query Checking
        • Cek Funnel Stage
        • Insert from temp_leads
        • Insert from sleekflow
        • Check Duplicate
        • Update Source Ads
        • Conversion Duration Analysist
        • Cek branch tidak match
        • Select Potential Contact
      • Query View
        • TAC Combined
        • TAC
        • TAC Appt
        • TAC Appt - Appt
        • TAC Appt - MQL
        • TAC Appt - MQLplus
        • TAC Appt - Tourplus
        • TAC Appt - Trialplus
        • TAC Convert
        • TAC Inbound
        • TAC Leads
        • TAC MQL
        • TAC MQLplus
        • TAC Tourplus
        • TAC Trialplus
        • Target View
        • Leads View
        • Appt View
        • Actual vs Target
        • All Time Leads Stages
        • All Time Appt Date
        • Budget Control
      • Database Management
        • pgAdmin
        • Looker Studio
  • Changelog
    • 2025-03
Powered by GitBook
On this page
  • Update KYZN BSD
  • Update KYZN Kuningan
  1. Digital System
  2. ETL Process
  3. Query Checking

Cek branch tidak match

Update KYZN BSD

branch != 'KYZN BSD'
select * from public.leads
where 
assigned_pic IN (
    'Tegar',
    'Ananda',
    'Annisa',
    'Raditya',
    'Mulyadi',
    'Dhita',
    'Dimas',
    'Seyla',
    'Nesni',
    'Desra',
    'Sarah Tika',
    'Ayu',
    'Endah',
    'Munajar',
    'Roy',
    'Zain'
) AND branch != 'KYZN BSD'
update branch != 'KYZN BSD'
update public.leads
set 
branch = 'KYZN BSD'
where
assigned_pic IN (
    'Tegar',
    'Ananda',
    'Annisa',
    'Raditya',
    'Mulyadi',
    'Dhita',
    'Dimas',
    'Seyla',
    'Nesni',
    'Desra',
    'Sarah Tika',
    'Ayu',
    'Endah',
    'Munajar',
    'Roy',
    'Zain'
) AND branch != 'KYZN BSD'

Update KYZN Kuningan

branch != 'KYZN Kuningan'
select * from public.leads
where 
assigned_pic IN (
'Usep',
'Dede',
'Nicolaas',
'Regi',
'Reinaldy',
'Nisha',
'Reza',
'Riandaud',
'Farhan',
'Indah',
'Jehan',
'Delfi',
'Erika',
'Rastika',
'Richard',
'Ibra',
'Rani',
'Yovita',
'Ulfa'
) AND branch != 'KYZN Kuningan'
update branch != 'KYZN Kuningan'
update public.leads
set
branch = 'KYZN Kuningan'
where 
assigned_pic IN (
'Usep',
'Dede',
'Nicolaas',
'Regi',
'Reinaldy',
'Nisha',
'Reza',
'Riandaud',
'Farhan',
'Indah',
'Jehan',
'Delfi',
'Erika',
'Rastika',
'Richard',
'Ibra',
'Rani',
'Yovita',
'Ulfa'
) AND branch != 'KYZN Kuningan'

PreviousConversion Duration AnalysistNextSelect Potential Contact

Last updated 4 months ago