Pull social metrics for multiple accounts

We often get this question: How can I pull social metrics for multiple twitter/facebook/linkedin accounts at a time? Instead of having to input the url manually for each pull. This is actually quite easy: In the wizard of a connector or integration generate the query as a formula and then replace the literal url with a reference to the first cell in the column of urls. Then use Excel's autofill feature to populate the rest of the cells....