@riri1 @Looker_Studio_B @lauratilton here is the one of the best example for you guys, where i display the logo/thumbnail for performance on each channel for the campaigns.
its a calculated field.
CASE
WHEN channel = ‘Meta’ then CONCAT(‘[https://drive.google.com/uc?export=download&id=‘,REGEXP_EXTRACT(’------copy](https://drive.google.com/uc?export=download&id=‘,REGEXP_EXTRACT(’------copy) and paste the shareable link of drive file here inside a single quote-----------’, “[https://drive.google.com/file/d/([^](https://drive.google.com/file/d/([^)\\/]+)”))
//add more channels if needed else delete this line
ELSE CONCAT(‘[https://drive.google.com/uc?export=download&id=‘,REGEXP_EXTRACT(’------copy](https://drive.google.com/uc?export=download&id=‘,REGEXP_EXTRACT(’------copy) and paste the shareable link of drive file here inside a single quote for a any default thumbnail-----------’, “[https://drive.google.com/file/d/([^](https://drive.google.com/file/d/([^)\\/]+)”))
END
output.
