Why matching date of purchase and review date?
Why assuming that a customer did a review in the same month or year he purchased an audiobook?
He may rate an audiobook after a month or even a year.
So, how can we solve such an issue in this situation?
1 answers ( 0 marked as helpful)
Hi Mohamad,
We are not assuming that the customer did a review in the same month or year. We are simply creating a relationship between the Year (Date of Purchase) and Year (Review) fields; This is how data the data will be joined.
What this means is that we are structuring the data so that it joins based on the corresponding years in these two fields. By doing this, we allow the data to be linked in a way that associates each purchase year with its respective review year, without implying that the review occurred in the same year as the purchase.
This relationship enables us to analyze trends, patterns, and correlations between the time of purchase and the time of review, even if those events happened in different years. Essentially, this method ensures that our analysis remains flexible and accurate, allowing us to gain insights into customer behavior over time, irrespective of the exact timing of their review in relation to their purchase.
Best,
This relationship enables us to analyze trends, patterns, and correlations between the time of purchase and the time of review, even if those events happened in different years. Essentially, this method ensures that our analysis remains flexible and accurate, allowing us to gain insights into customer behavior over time, irrespective of the exact timing of their review in relation to their purchase.
Best,
Ned