This is a CLI-based Lead Reporter that processes a CSV of leads. It performs the following tasks:
- Checks and removes duplicates
- Checks and removes any lead entries with "test" in it
- Calculates the total spend and provides an accurate cost per lead
- Ensure you have
pipx
installed:python3 -m pip install --user pipx python3 -m pipx ensurepath
- Install the project using
pipx
:pipx install actual-leads-reporter
- Clone the repository:
git clone https://github.com/yourusername/actual-leads-reporter.git cd actual-leads-reporter
- Install the project in editable mode with development tools:
pip install -e .[dev]
To use the CLI tool, run the following command:
leads <path_to_csv_file>
leads leads.csv
This will:
- Clean the CSV file by removing test entries and duplicates.
- Calculate the total number of leads.
- Calculate the cost per lead based on a predefined total spend of $911.26.
- Output the total spend, total leads, and cost per lead.
The CLI will output:
- Total Leads from cleaned file
- Total Spend
- Total Leads
- Cost per Lead