Please enable JavaScript.

Coggle requires JavaScript to display documents.

Lead Gen, City Summary Sheet, O/p : sheet :1.Meeting_Fixed(Pipeline), 2…

- - - - lead_city
      - lead_status
      - tag
      - meeting_id
      - start_date
      - 7.status
      - employee_code
      - number_of_apartments
      - resource_name
      - Lead_id
- - - - F -
        meeting fixed date
      - C- Checkbox the City
      - N-
        count
      - G-
        Lead source
- - - - left merge
        
        meeting_fixed(left)
        
        py_read : Leadgen Lead DB
        
        lead_db1
        
        lead_db[['lead_id','source']]
        
        lead_db
        
        mis_tab1_prospect_a_new_16_dec_2022-02-07T09_58_17.387068Z
    - - 04 February 2022/Akash/Lead ownership transfer history.csv
- - - - left merge
        on="Lead ID"
        
        df_meetings_status(left)
        
        left merge
        on Lead ID
        
        meeting_fixed(left)
        
        "py_read"
        
        meetings:
        filter meetings :warning: = meetings.loc[meetings['hierarchy']=="sales_hierarchy"]
        
        Feb 2022/04 February 2022/Akash/MIS-Tab2-Meeting-A with meeting start date filter.csv
        
        lead_db1
        
        lead_db[['lead_id','source']]
        
        lead_db
        
        mis_tab1_prospect_a_new_16_dec_2022-02-07T09_58_17.387068Z
    - - 04 February 2022/Akash/Lead ownership transfer history.csv
- - - - left-merge
        on ="Lead ID"
        
        df_call_data(left)
        
        left merge
        on =["LeadID","call_date"]
        
        df_call(left)
        
        leftmerge
        on="Lead ID"
        
        df_calls
        
        1 more item...
        
        meeting_fixed
        
        1 more item...
        
        df_call1
        
        leftmerge
        on="Lead ID"
        
        meeting_fixed
        
        1 more item...
        
        df_call1
        
        1 more item...
        
        lead_db1
        
        lead_db[['lead_id','source']]
        
        lead_db
        
        mis_tab1_prospect_a_new_16_dec_2022-02-07T09_58_17.387068Z
    - - 04 February 2022/Akash/Lead ownership transfer history.csv
- - - - left merge
        on="Lead ID"
        
        meeting_fixed
        
        "py_read"
        
        demos
        
        demos = demos[['Lead ID','Meeting ID','Emp Email ID','Role','Meeting Status','Demo Date','Demo Participants','Demo Duration (in mins)','Recording Link']]
        
        "masterDEMO"
    - - lead_db[['lead_id','source']]
        
        mis_tab1_prospect_a_new_16_dec_2022-02-07T09_58_17.387068Z
- - - - leftmerge
        on='Lead ID'
        
        df_assigned_date(left)
        
        leftmerge
        on='Lead ID'
        
        meeting_fixed
        
        "py_read"
        
        assigned_date
        
        04 February 2022/Akash/Lead-ID-Transfer date filter.csv
        
        lead_db1
        
        lead_db[['lead_id','source']]
        
        mis_tab1_prospect_a_new_16_dec_2022-02-07T09_58_17.387068Z
    - - 04 February 2022/Akash/Lead ownership transfer history.csv
- - - - "masterDEMO"
    - - lead_db1 = lead_db[["Lead ID","lead_status","source","tag","lead_city","number_of_apartments"]]lead_db1 = lead_db[["Lead ID","lead_status","source","tag","lead_city","number_of_apartments"]]