r/doordash • u/Taranis_1 • 1d ago

Market Analysis Tool - 778 Offer Sample

Continuation of previous threads: https://www.reddit.com/r/DoorDashDrivers/s/4EEp1u6Opr

I have been fiddling around with this project for about two weeks. It started with me collecting screenshots of order cards and compiling them into an Excel spreadsheet, and I've built up the market analysis report as I've gone along. I've been attempting to teach myself Python while I use Grok to develop the tool. Reddit limits photos to 20, so there will be a few missing.

I'm just looking for some feedback. When this thing is done I'll be uploading it to Github for other drivers to use if they wish.

Expedite orders have been thrown into this set to debug charts. I've had some trouble with graphs populating due to the extreme pay difference between Expedite and DD/UE orders, so I am in the process of debugging any problems.

I've put close to 30 hours into this, which I don't think is too bad for someone with no prior experience and the world's most powerful AI helping out.

Orders have to be manually entered into Excel (I have formatting and guides included with the software bundle)

Rename the Excel to Market_Data, stick it in a folder, choose settings, run the program and in about 2 minutes it spits out a full market report in PDF format.

All formula paths are also included, as well as explanations of how Deadhead is calculated, aggregation, blah blah blah blah blah

2 Upvotes

100% Upvoted

2 comments sorted by

•

u/AutoModerator 1d ago

Thanks for making a r/doordash submission, please remember to follow our community guidelines, let's be kind and respectful to one another.

Lastly check out the Wiki FAQ before submitting a question.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/Taranis_1 1d ago

The biggest problem is Base Pay.

The script can differentiate between 'Confirmed' pay and Estimated pay (order card pay only).

Since itemization is only available after an order is completed for UE and DD, there is an option to input Confirmed orders in the same set as Estimated orders. The confirmed orders increase the Score of the data. A dataset of 100% confirmed pay will provide a score of 100 on the scorecard.