How can we identify Remove rows from Transactionlines table? Eg: Transaction might of had 10 rows, but we removed 5, AlayticsConnect still shows 10 rows

I'd think there has to be some sort of "is deleted" flag in the table you need to add to you WHERE clause.

There doesnt seem to be one. I've logged it with Support but no reply yet