Visitors Dataset - Assessment Answer

Internal Code : 3HAF

Dataset Assignment Help

Task :

Thumbtack is a marketplace for local services. Our customers come to our website or mobile app, fill out category-specific request forms, and receive up to 5 quotes from relevant professionals within the next 24 hours. For example, a customer might submit a house cleaning request for a two bedroom, one bathroom apartment in San Francisco and get 3 quotes from professionals (“pros”), each with a price estimate for the project. Customers then have the option to hire one of these pros and leave them a review.

Datasets and schema

Visitors CSV

This dataset contains a list of unique Thumbtack visitors who started request forms in either house cleaning or local moving categories within the last few months. Some of these users submitted a request. These customers then received between 0 and 5 quotes from pros (i.e., professionals providing services on Thumbtack). Customers who received quotes then had the option to hire one of the pros.

date (string) the day the visitor came to Thumbtack

device (string): whether the visitor is using a desktop or mobile device

category (string): category for which the visitor needs a project done

request_sent (integer): 1 if the user sent a request, 0 if not

request_id (integer): unique identifier for a request, NA if the user did not submit a request

how_far (string): for requests in the moving category, how far the customer estimates that they will move

num_rooms (string): for requests in the cleaning category, how many rooms the customer has

num_baths (string): for requests in the cleaning category, how many bathrooms the customer has

Quotes CSV

This dataset contains a list of quotes that pros sent in response to customer requests. Each quote is associated with a particular request and usually contains a price estimate.

quote_id (integer): unique identifier for a quote

request_id (integer): unique identifier for the request a quote is associated with

quote_price (integer): estimated price in dollars for the project

hired (boolean): 1 if the quote was marked as hired by the customer, 0 otherwise

pro_id (integer): identifier for a pro

Thumbtack has decided to take a closer look at performance in two of its largest categories – House Cleaning and Local Moving. Please complete the analyses suggested below and overlay your own recommendations for how we can improve and grow our marketplace. In your analysis, please also note any steps you took to transform or clean the data.

1. Visitors and Conversion Rate

•  How does the number of visitors change over time?
•  What percent of visitors submit a project request?
•  How do category and device influence these metrics?

2. Quotes Per Request

• What is the distribution of number of quotes per request?
•  What factors contribute to some requests getting more quotes than others?

3. Job Value

•  By category, what is the distribution of quote prices for a project?
•  By category, what price do you think Thumbtack should charge pros to quote? Why?

Explain your reasoning for any assumptions that you make.

4. Further Exploration

• Briefly describe two other questions or analyses you would be interested in pursuing if you had more time to explore this data

We encourage you to explain and hypothesize about the drivers behind your findings, and to make business recommendations based on your results. We also value brevity – only include the analysis & charts that you believe are most relevant to your answers.

This Dataset Assignment has been solved by our Data Analysis experts at TV. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction