To add a further filter in the connector for the transaction report that allows for users to select by spotlight id/name. When selecting for multiple campaigns, I am finding it generates a lot of extra rows of data and takes exponentially longer to download as the number of campaigns increase.
Ideally the filter will reduce some of the data being retrieved as I found it took over 2 hours to download 30 campaigns of data via the API when I only needed some 2k rows (of a specific spotlight) out of nearly 2 million rows of data.
Thanks for the question. I don't think this is possible in the API at the moment. This is something that Flashtalking need to enable in order to allow us to implement this functionality.