Skip to main content

Ā 

Welcome aboard, marketing analytics gurus! šŸŽ‰

Ā 

We're thrilled to launch our very firstĀ Supermetrics Community Challenge.Ā Our Community Challenges are a chance for us all to dive into the exciting world of marketing analytics in a fun way.Ā 

Ā 

The rules of the first Challenge are simple:Ā 

  • In the replies to this post, shareĀ your favorite marketing analytics trickĀ you wish you knew sooner.
  • ā€œLikeā€ the replies of other Community members that resonate with you the most.

Ā 

We'll award 2 participants with aĀ special gift box worth $200:Ā one for the most upvoted response and one for the response chosen by the SupermetricsĀ Team šŸŽāœØ

Ā 

ā³ The challengeĀ ends on June 30, 2024.Ā 

Ā 

Our example of the trick: when analyzing the performance of different ad creatives in Google Sheets, use the formulaĀ =IMAGE("URL"), where the URL is the public web address of that image. It'll add an image of the ad to your report and make it more descriptiveĀ šŸ¤©Ā Hereā€™s our short demo video.Ā 

Ā 

Can't wait to see your answers!Ā 

Ā 

P.S. Commenting is possible only after you log in to the Community.Ā 

@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!

Ā 

Reply


Terms & ConditionsCookie settings