So I've been writing these queries to get a summarized report of Opens, Clicks, Sent, Delivered, DeliveryRate.
To date I've been getting this data from the Data Views, but I ran into a snag.
We have been for the past three months recording attributes in every send using the __AdditionalEmailAttribute fields under properties.
Those attributes are stored in the SendLog, but as far as I can tell, there is nowhere else to grab them from. Is that right?
I can rejigger my queries to pull everything from the SendLog, but my SendLog is 33,504,805 rows at the time of this post, and I don't think we have any plans to clear it any time soon.
Is that HUGE? Is it safe to run queries on such a large DE?
What's better, performance wise? Querying the Data Views or the SendLog? I guess they are all just tables in the system so maybe it doesn't matter, but the size of the SendLog is really concerning me.
Please advise. Thanks!