incomplete FB post data import
I have a query pulling post level data from Facebook. Once it's in my spreadsheet I have several additional columns where additional data is entered manually corresponding to each post.
On the automatic update today a new post was grabbed from February and inserted as a row in the middle of the table. Since the additional columns I add are manual, they were all out of sync from there down.
I'm wondering if you've encountered this and have any recommendations along the lines of...
1) ensuring we get all the data the first time, so new rows are not inserted in the middle of data sets
2) sorting rows by when they were added to the data set, so new rows are always at the bottom even if the posts they refer to were in the past and were for some reason missed
3) tips on binding manual data to imported data so even if the imported data is re-sorted the manual data re-sorts alongside