Calculate User GMT Offset

SELECT DurableId, FlowDefinitionView.Label, VersionNumber, Status FROM FlowVersionView WHERE FlowDefinitionView.Label LIKE '%PLACE PART OF THE FLOW NAME HERE%' AND Status != 'Active'



/* NOTE: When IMPORTING (Delete Action) - Mark API Type as "Tooling API", limit the batch to 10 and 1 thread (SF Limitation), and change DurableId to ID */

trigger AccountTrigger on Account (before insert) {

      if(Trigger.isInsert && Trigger.isBefore) {

        
        List<Account> myList = new List<Account>();

        for(Account acct : Trigger.new){
          if(acct.name == 'My Test Account'){
           acct.AnnualRevenue = 0;
           myList.add(acct);
          }
        }

        if(myList.size() >= 0){
          insert myList;
        }
      }   
}

SELECT Id, ContentDocumentId, LinkedEntityId, ShareType, Visibility 
FROM ContentDocumentLink 
WHERE ContentDocumentId IN (SELECT Id FROM ContentDocument)

REPLACE({Name},1,FIND("~",SUBSTITUTE({Name}," ","~",LEN({Name}) - LEN(SUBSTITUTE({Name}," ","")))),"")

* _Formula:_ (Clicks / Impressions) * 100
 * _Example:_ You see that your blog post ranks well for "easy baking recipes," but its CTR is low. This indicates a potential problem with your title or meta description. 

 * _Action Steps:_ 
      * Experiment with power words (e.g., "Effortless," "Delicious")
      * Include numbers or a question in your title.
      * Ensure your meta description provides a clear, enticing preview of the content.

* _Formula:_ (Single page visits / Total sessions) * 100
 * _Example:_ Your "best homemade pasta recipes" page has a high bounce rate. This might mean:
       *  People expect quick, simple recipes, but your content is too complex. 
       * Your images are slow to load, frustrating visitors.
       *  Internal links to related recipes are missing.

 * _Action Steps:_ 
        * Use tools like Google PageSpeed Insights to check load times. 
        * Clearly format your content with headings and short paragraphs.
        * Add internal links to keep visitors engaged on your website.

 *  _Formula:_ (Conversions / Total Visitors) * 100
 * _Example:_  Despite good traffic, your e-book has a low conversion rate on its landing page. This could mean:
       *  Your call-to-action isn't clear or persuasive enough.
       * The landing page doesn't address visitor concerns or build enough trust.
       *  There are too many distractions or form fields on the page.

 * _Action Steps:_
       * Use strong verbs and clear language in your calls-to-action.
       * Highlight the benefits for the visitor.
       * Test different landing page designs and reduce clutter. 

*  _Formula_ (Number of times a keyword appears / Total words on page) * 100 
*  _Example:_ If you want to rank for "vegan cake recipes", including that phrase a few times naturally is helpful.  Repeating it excessively becomes unnatural and hurts your chances of ranking well.

*  _Action Steps:_
      *  Focus on creating valuable, informative content first.
      *  Use keyword research tools to identify related terms and phrases (e.g., "eggless cake recipes," "dairy-free frosting").

* _Tools:_ Ahrefs, SEMrush, Moz, and others provide advanced position tracking. 
* _Example:_ You track keywords like "mindfulness tips," "meditation for beginners," and notice your average position improving over time. This indicates your SEO efforts are paying off.  

 * _Formula:_ (Time spent on social media * Hourly salary) / Number of conversions through social media 
 * _Example:_ Your social media efforts resulted in 10 new e-book sales. If you spent 20 hours on social media, with an hourly rate of $30, your social cost per conversion is $60.

 * _Action Steps:_
      * Analyze if this cost is sustainable given the value of each conversion.
      * Explore ways to streamline your social media tasks.
      * Focus on platforms that yield the best results.

* _Formula:_ (Gains from SEO - Cost of SEO) / Cost of SEO  
 * _Example:_ If increased organic search traffic generates an additional $2000 in revenue, and you spent $1000 on SEO tools and content creation, your ROI is 100%.

* _Action Steps:_
    * Track revenue attributed to organic search.

Flow version:
HYPERLINK(LEFT($Api.Enterprise_Server_URL_610, FIND( '/services', $Api.Enterprise_Server_URL_610)) & {!$Record.AccountId}, {!$Record.Account.Name})     
     
Forula version: 
HYPERLINK(LEFT($Api.Enterprise_Server_URL_610, FIND( '/services', $Api.Enterprise_Server_URL_610)) & AccountId, Account.Name)     

//f_GMTOffset
24 * (DATETIMEVALUE({!$Flow.CurrentDate}) - {!Convert_Today_To_DateTime.datetimeValue})

//Convert_Today_To_DateTime is an UnofficialSF Action - ConvertDateToDatetimeFlowAction

{!dateTimeVariable} + ({!f_GMTOffset}/24)

TEXT(MONTH(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & "/" &
TEXT(DAY(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & "/" &
TEXT(YEAR(DATEVALUE({!f_StartDateTimeWithTimeZoneOffset}))) & " " &
IF(
    VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) = 0, 
    "12:" & 
    RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
    " AM", 
    IF(
        VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) < 12,
        TEXT(VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2))) & ":" & 
        RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
        " AM",
        IF(
            VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) = 12,
            "12:" & 
            RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
            " PM",
            TEXT(VALUE(MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 12, 2)) - 12) & ":" & 
            RIGHT("00" & MID(TEXT({!f_StartDateTimeWithTimeZoneOffset}), 15, 2), 2) & 
            " PM"
        )
    )
)

public class OutterClass {
    Public String name = 'outterclass';
    
    public void setName(String name){
        this.name = name;
	}
    
    public class InnerClass{
       Public String name = 'innerclass';
    }

}