Hi Community,
I am trying to work out whether Ad exposure influenced users to activate the advertised app.
I have a logic defining what counts as "influenced", but it requires one data set to look up multiple rows in the other, and I don't know how to I express it using Alteryx.
Please refer to the attached excel sheet for visual representation.
Basically, I have 2 inputs. One is ad exposure history, containing userIDs and dates when they were exposed to the ad. Second is app usage history, containing userID and dates of when the advertised app was activated. I want to flag each row of the former when app activities were present in the latter within 5 days after the ad exposure. That way I can identify which ad exposure to whom worked and which did not.
I initially thought the first step is to join the 2 data sets, but this will expand the data sets greatly. Perhaps I should summarize the second data set, but I don't know how.
Does anybody know smart ways to perform the desired processing?
I thank you for taking in a look in advance!
Thank you,
Yoshi
