08-21-2023 04:40 AM
Hi,
i am using the Appsflyer connector. I have access to two of my client's tables:
Geo_Daily and Event
The Event table is on the user level, whereas geo_daily is aggregated.
I am trying to check the data and comparing between both of them, but it is not matching up.
I am checking for a single day the sum(event_revenue) in the event table, and comparing it to geo_daily. In geo_daily, each event has its own columns. I found the same event in both tables, but the numbers don't equal.
Can somebody tell me what I am missing, shouldn't the revenue value be the same in both tables?
Thanks