Kristian, I'd like to help. Can you define what the desired output list looks likes. Are you looking for list with just campaign names and the date they were "new"?
If needed you can screenshot how you want the list to look like
Thanks for the quick reply-
Here's a quick screenshot of a rough example dash of what I'm looking for:
The left table is summary of data for a partner, the tables on the right
are lists of the 'started' or new campaigns, and stopped campaigns for a
time period we define. What defines start/stop: example:rev on 9/12=0,
9/13=0, rev on 9/13=$100. A campaign 'stops' when consistent daily revenue
drops abruptly and /or goes to zero.
The main reason that I have to deduce start/stop of campaigns is that I
don't have that data explicitly, and need to make assumptions from the
patterns of data that we receive.
On Wed, Sep 14, 2016 at 8:42 PM, John Brink <email@example.com>
Can anyone help on this topic?