← back to Rentv Sheet Enrich
__pycache__/export_top.cpython-314.pyc
37 lines
+
�Mjp � �l � R t ^ RIt^ RIt^ RIt^ RIt^ RIt]P P ]P P ] 4 4 t
Rt ] ! ]P 4 ^8� d ]! ]P ^, 4 M^�t] ! ]P 4 ^8� d ]P ^, M ]P P! ]
R] R24 t]P$ ! ]! ]P P! ]
RR4 4 4 t]! R ]R, 4 4 t]R , ]R
, utt]! ]4 U Uu/ uF w rWbK upp tR tR t R
t R t ] ! ]R RR7 t . R#Ot!^ t"]! ]R R R 7 ;_uu_ 4 t#]PH ! ]#4 t%]%PM ]!4 ] F� t']PP ! ]']4 t)]! ]'R 4 R 8X d K& ]! ]'R4 ' g ]! ]'R4 ' g KF ]"^,
t"] ! ]'4 w t*t+]%PM ]"])]PX ! ]']4 ]! ]'R4 ]! ]'R4 ]! ]'R4 ]*]+]! ]'R4 ]! ]'R4 ]! ]'R 4 ]! ]'R4 ]! ]'R4 ] ! ]'4 ]! ]'R4 ]! ]'R4 ]! ]'R4 .4 ]"]8� g K� M RRR4 ]-! R!]" R"] 24 R# u upp i + ' g i L&; i)$u�
Export the top-N warmest RENTV leads as a ready-to-work CSV.
Reads the local snapshot (data/snapshot.json — the same source the live console
serves) so it never burns a Sheets read, scores every unique contact with the
shared warmth.py scorer, sorts hottest-first, and writes a lean outreach sheet
with a 'Why Warm' reason column.
Usage: python3 export_top.py [N] [outfile.csv]
(defaults: N=200, outfile=rentv_top<N>_to_work.csv)
Ni W: � rentv_topz _to_work.csv�dataz
snapshot.jsonc # �L " � T F qR , \ 8X g K Vx � K R# 5i)�gidN)�
UNIQUE_GID)�.0�ts & �
export_top.py� <genexpr>r
s � � �
=�l���h�*�&<�1�1�l�s �$�
$�tabs�headers�rowsc � � \ P V4 pVe: V\ V 4 8 d* W, e \ W, 4 P 4 # R# )N� )�idx�get�len�str�strip)�r�name�is && r �cellr s= � � ����
�A�!"� �1�s�1�v�:�!�$�BR�C���I�O�O� �[�XZ�[� c �& � \ V 4 ^ , # )� )�best_email_src�r s &r �
best_emailr ! s � � �!� �Q� � r c �L � R F w r\ W4 pV' g K W23u # R# )�Email))r �verified)zUpdated Email (found)�updated)zLikely Email (inferred)�inferred)r r �r )r �f�src�vs & r r r % s, � �<��� ��J�� �1��6�M� <�
�Mr c �B � \ V R 4 ;' g
\ V R4 # )zLinkedIn (Contact)zLinkedIn (Company)r$ r s &r �
best_linkedinr) / s � � ��'� (� I� I�D��4H�,I�Ir c �8 � \ P ! V \ 4 # )N)�warmth�scorer r s &r �<lambda>r- 3 s � �F�L�L��C�$8r T)�key�reverse� Contact Name�
Company/Venue�Position�Phone 1�Phone 2�Marketing/VP Name�Marketing/VP Position�Website� Source Tabs�
# Appearances�wr )�newlinezStatus (color)zSection / CategoryzWrote z
leads -> )�Rank�WarmthzWhy Warmr0 r1 r2 z
Best Emailz Email Sourcer3 r4 �Statusr5 r6 �LinkedInr7 r8 r9 ).�__doc__�csv�json�os�sysr+ �path�dirname�abspath�__file__�HEREr r �argv�int�N�join�OUT�load�open�snap�next�tab�Hr
� enumerater r r r r) �sorted�scored�COLS�writtenr% �writerr: �writerowr r, �sc�em�emsrc�reason�print)r �hs 00r �<module>rb s� ��
� � �
� �w�w���r�w�w���x�0�1��
�
��C�H�H�
��)�C����� ��s������]�Q�&�c�h�h�q�k�B�G�G�L�L���1�#�\�?Z�,[�� �y�y��b�g�g�l�l�4�� �A�B�C��
�
=�d�6�l�
=�=��
�i�.�#�f�+���4�!�!� �%� ���q�t� �%��\�
��J�
��8�$� G��X�� �� �#�s�B� � �1� �
�
�1�
�A��J�J�t��
��
�\�\�!�S�
!�� ��#� $�(<� <� ��Q��'�'�4��?�+C�+C� ��1� ��"�1�%� ��E� �
�
� �R�� � �q�#�.� ��N� #�T�!�_�%=�t�A�z�?R� ��t�A�y�)�4��9�+=� ��$� %�t�A�/B�'C� ��+� ,�m�A�.>� ��I� ��Q�
� 6��Q��8P�
� � �a�<� �% � �. ��w�i�z�#��'� (��q &�B � �s& �0
J �2AJ#�
J#� B J#�J#�# J3