Workaround to use RANK function on Looker Studio 

Windsor Link to connect and blend +400 Data sources:
www.windsor.ai...
For this workaround:
1- I used Windsor to connect to Facebook ads data.
2- Load the data into Looker studio and Google sheet.
3- Data cleaning on Google sheet and calculating the rank
4- Blend the data Looker Studio ( Google Data Studio