Share your best marketing analytics trick and get a chance to win! 🏆 🎉 (Ended)

@Sandrinha if you are using Instagram Insights connector, use the dimension Media Peremalink:

If you are using the Facebok Ads connector, use the dimension Link to Insgram post:

Just a pratical example:

Here’s a Forbes reel. The “media URL” will return the temporary file. The Link to Instagram or the Media Permalink will return exactly the permanent post URL: https://www.instagram.com/reel/DB94blLSX0P/.

The permanent thumbnail file is located in this URL https://www.instagram.com/p/DB94blLSX0P/media

The trick to do this is REGEX_REPLACE(Media Permalink, “/reel”, “/p”) to change the middle part of the URL, and CONCAT with “media” at the end.

Let me know if changing the dimension worked.

@Sandrinha, 

Your goal is to make  https://www.instagram.com/reel/C2PjkZjO_NO/ turn into https://www.instagram.com/p/C2PjkZjO_NO/media.

Basicly we have two steps here:

1. REPLACE “/reel” for “/p”, to normalize the URLs;
   Using this function REGEXP_REPLACE(Link to post, "reel", "p"), lets call it “normalized URL”.
2. CONCATENATE media at the end of the URL
   Using this function CONCATENATE( normalized URL, “media”).

Your function is:

REGEXP_REPLACE(REGEXP_REPLACE(Link to post, "reel", "p"), "media", "") 

but it should be:

CONCATENATE(REGEXP_REPLACE(Link to post, "reel", "p"), "media") 

Let me know if it works!