Discussions

Hi Dewey team,

This never got fully resolved. Please advise on follow up question ....

Hi Dewey team,

1. Attribution of Online and Pickup/Delivery Transactions
   When a consumer pays through the Walmart app (or website) and uses the "pickup service," I'd like to know whether that transaction is counted toward the raw_num_transactions and raw_total_spend of a specific Walmart Supercenter, or whether it is attributed to the headquarters (or e-commerce channel) instead.
   Similarly, for "delivery service" transactions, could you please confirm whether those transactions are included in the raw_num_transactions and raw_total_spend of the individual Supercenter that fulfilled the order?

2. How Online Metrics (online_spend, online_transactions) Are Handled
   Related to the above, I'd like to know whether purchases made through "pickup service" and "delivery service" are also included in the online_spend and online_transactions variables for that Walmart Supercenter.
   The reason I'm asking is because of how receipts are labeled differently. When using Walmart's delivery service, the merchant name on the receipt appears as "Walmart Online," whereas an in-store purchase shows as "Walmart #XXXX Supercenter." So I want to clarify exactly how transactions made through the app or website are mapped in the data.

3. Accuracy as a Proxy for Actual Store Sales
   Considering these complex fulfillment methods, to what extent can your dataset serve as an accurate proxy for the 'actual total revenue' of individual offline stores?

4. Whether Cash Transactions Are Included
   Additionally, I would like to know if offline cash (banknote) transactions are also captured and attributed to raw_num_transactions and raw_total_spend. If not, could you confirm whether your data exclusively represents transactions made via credit/debit cards?

When I try to apply filters in the Dwellsy TotalIQ data, I get the message: “Free customization preview limit reached. Subscribe to Dewey to customize, save, and download datasets.” However, my account and my university are already subscribed. Why am I still seeing this message?

Hello,

Hi Dewey team,

Hi,

The precipitation variables (i.e. HOURLYPRECIPOPTIONALFLOATINGPOINT_CENTIMETERS_ ) have a high missing rate. The missing values are marked as blanks. The majority of the data consists of blanks, but there is also a large number of records where the precipitation value is 0.

We are interested in using RentHub for a research project. How many observations per week do they have in Columbus, Ohio and by neighborhood?