Researpa R&D — Project Tracking & Automated Analytics Portal

Automated Data Entry Engine

Auto Fill Project Data - Enter Project Link Below

Paste Project URL (Upwork, Kolabtree, Guru, Freelancer)

Optional: Paste Job Text / Snippet

Fetches live project metadata from the URL and fills the 29-column entry form below (Dates in DD-MM-YYYY, Default Hourly Rate $50/hr, and Connect Cost @ $0.15/Connect).

Add / Edit Monthly Project Application Record

All dates use DD-MM-YYYY format and months use MM-YYYY format. Standard hourly rate is $50/hr.

Project Name *

Source Platform *

Client Name

Country

City

Applied Date (DD-MM-YYYY) *

📅

Date Posted (DD-MM-YYYY) *

📅

Delay in Application (Days)

Delay in Hours

Category *

Sub Category

Cost Applied For

Fixed Cost Max ($)

Variable Rate (/Hr)

Connects Used

Connect Cost (INR)

Invite Received?

Response Received?

Converted?

Rejection Reason

Proposals Count

Project Link (Upwork / Kolabtree)

Dynamic Upwork Connects Spend Calculator

Connects Spend for Selected Month (All Months)

Shows total Connects spent for the selected month in "Applied Projects Master Sheet". Changing the Connect Rate or FX Rate below applies only to new projects recorded after the change (previously recorded projects keep their locked-in rates).

Upwork Connect Rate ($ USD)

FX Rate (1 USD → ₹ INR)

₹

Total Connects Used (Selected Month)

0 Connects

Across Upwork applications

Total Spent on Connects (USD)

$0.00

@ $0.15 per connect

Total Spent on Connects (INR)

₹0.00

@ ₹84.00 / USD

Applied Projects Master Sheet (0 entries)

Months are in MM-YYYY format and Dates are in DD-MM-YYYY format. New months are added automatically when a project is saved, or you can add a missing month manually.

#	Month (MM-YYYY)	Project Name	Source	Client & Location	Category / Sub-Cat	Applied / Posted (DD-MM-YYYY)	Delay	Rate / Connects Spend	Response	Converted	Rejection Reason	Actions

Automated Pivot & Inferences Engine (Replicating Analysis.docx)

Monthly Project Application, Delay, Strike Rate & Connect Spend Analysis

Select Analysis Month (MM-YYYY):

💡 Automated Monthly Inferences

Auto-generated from live project records

🎯 Automated Action Points (90% Target)

Target: 90% in 0–1 Day

Projects Applied vs. Responses & Strike Rate by Category

Application Delay Distribution (Upwork vs. Kolabtree)

1. Overall Responses Received & Platform Breakdown by Category

Sr. No.	Categories - Project Applied	Upwork	Kolabtree	Other / Old Clients	Total Applied	Monthly Expected	Response	Response Share %	Strike Rate %	Converted	Rejected

2. Category-Wise Delay Analysis — Upwork vs. Kolabtree (90% in 0–1 Day Target)

Automatically computes % applied in 0–1 days, target projects required for 90% benchmark, and exact project deficit per category.

Delay Analysis		Upwork							Kolabtree
#	Category	0 Day	1 Day	2 Day	>2 Days	Total	% in 0–1d	90% Target / Deficit	0 Day	1 Day	2 Day	>2 Days	Total	% in 0–1d	90% Target / Deficit

3. Rejection Reasons Matrix (On Responses Received)

Category	Budget	Experience	Selected Someone Else	No Longer Needed	Declined By Us	No Reason	Not Good Fit	Total

4. Average Delay Trend Across Months (MM-YYYY)

Automated Quarterly Aggregation Engine

Quarterly Project Performance, Strike Rate & Delay Compliance

Select Quarter:

📈 Quarterly Executive Inferences

🚀 Quarterly Strategic Action Points

Quarter-over-Quarter (QoQ) Applications, Responses & Strike Rate

Selected Quarter: Category Strike Rate & Delay Compliance

Quarterly Category Performance & 90% Delay Target Matrix

#	Category	Upwork Applied	Kolabtree Applied	Total Applied	Responses	Strike Rate %	Converted	Avg Delay (Days)	Applied in 0–1d (%)	90% Target Deficit

30-Day Retention Policy

Trash & 30-Day Project Entry Recovery

Deleted project entries remain recoverable here for 30 days before automatic MySQL purge.

Item Type	Project Entry	Platform / Category / Month (MM-YYYY)	Deleted By	Deleted At (DD-MM-YYYY)	Recovery Window	Actions

Confirm Deletion

R&D Project Tracking & Automated Analysis Suite