- gettectonic.com - Page 9
Salesforce SOQL Tools and AI
13Apr

Salesforce SOQL Tools and AI

Salesforce Object Query Language (SOQL) is a robust instrument empowering users to retrieve data from Salesforce efficiently. With SOQL, you can interrogate any Salesforce object, spanning from custom objects to user permissions like profile and permission set perms. Salesforce SOQL Tools and AI. As a seasoned Salesforce Admin, crafting SOQL queries can often prove cumbersome. Not only must you master the syntax, but you must also ensure the queries are both effective and precise. Salesforce SOQL Tools and AI Fortunately, the advent of generative artificial intelligence (AI) tools offers a solution to this challenge. Generative AI tools, capable of producing text, code, and creative content, have emerged as invaluable aids in generating SOQL queries. Among these, Bard and ChatGPT have emerged as particularly helpful tools for crafting SOQL queries. In this discourse, I’ll illustrate how to leverage prompts to generate SOQL queries using these generative AI tools, providing query examples and resources to kickstart your journey with SOQL in your organization. Initiating SOQL Queries with Generative AI Tools To start, it’s essential to furnish the generative AI tool with pertinent information about the intended query. For instance, one might instruct the tool to generate a query retrieving all open opportunities. Subsequently, upon prompting: “Write SOQL that returns all open opportunities in Salesforce.” ChatGPT furnishes the following response: “SELECT Id, Name, StageName, CloseDate, Amount FROM Opportunity WHERE IsClosed = false” This query selects Opportunity records and retrieves their pertinent attributes, filtering the results to include only open opportunities based on the IsClosed field. Bard echoes a similar sentiment with its rendition of the query: “SELECT Id, Name, StageName, Amount, CloseDate FROM Opportunity WHERE IsClosed = false” However, the essence of prompt writing and critical thinking lies in refining the generated response. For instance, by slightly altering the prompt to include additional criteria: “Write SOQL that returns all open opportunities in Salesforce, including all standard fields and filtering results by StageName.” ChatGPT furnishes an adapted query: “SELECT Id, Name, AccountId, Amount, CloseDate, CreatedBy.Name, CreatedDate, LastModifiedBy.Name, LastModifiedDate, StageName FROM Opportunity WHERE StageName != ‘Closed Won’ AND StageName != ‘Closed Lost’” It’s worth noting that ChatGPT lacks insight into the specifics of your organization’s structure, necessitating occasional guidance to accommodate custom fields. However, through conversational cues, you can educate it accordingly: “My Salesforce org includes a custom field with the API name of NonProfit__c for Opportunity. It’s a boolean field. Please include it in all future SOQL queries on Opportunity.” To which ChatGPT responds: “Certainly! To include the custom field NonProfit__c in all future SOQL queries on Opportunity, you can modify the query as follows: SELECT Id, Name, AccountId, Amount, CloseDate, CreatedBy.Name, CreatedDate, LastModifiedBy.Name, LastModifiedDate, StageName, NonProfit__c FROM Opportunity WHERE StageName != ‘Closed Won’ AND StageName != ‘Closed Lost’” By incorporating NonProfit__c into the SELECT statement, the custom field is seamlessly integrated into the query results. Leveraging SOQL for User Permissions Reporting One particularly advantageous application of SOQL for Salesforce Admins is reporting on user permissions. By utilizing the SOQL Query tool in Code Builder or the Developer Console, admins can scrutinize permissions assigned to users via permission sets, profiles, objects, and fields. Here are a few illustrative examples of user permission SOQL queries, collaboratively devised with the assistance of ChatGPT: Check user permissions on an object: SELECT PermissionsRead, PermissionsCreate, PermissionsEdit, PermissionsDelete FROM ObjectPermissions WHERE ParentId IN (SELECT Id FROM PermissionSet WHERE PermissionSet.Name = ‘Your_Permission_Set_Name’) AND SObjectType = ‘Your_Object_Name’ AND PermissionsRead = true Check user permissions on a field: SELECT PermissionsRead, PermissionsEdit FROM FieldPermissions WHERE ParentId IN (SELECT Id FROM PermissionSet WHERE PermissionSet.Name = ‘Your_Permission_Set_Name’) AND SObjectType = ‘Your_Object_Name’ AND Field = ‘Your_Field_Name’ AND PermissionsRead = true Determine which permission sets grant Edit access for a specific field: SELECT ParentId, Parent.Name, Parent.Type, Field, PermissionsEdit, PermissionsRead, SobjectType FROM FieldPermissions WHERE Parent.IsOwnedByProfile = true AND Field = ‘ADM_Work__c.Subject__c’ AND PermissionsEdit = True Identify users assigned managed packages: SELECT Id, UserId, PackageLicense.NamespacePrefix FROM UserPackageLicense WHERE PackageLicense.NamespacePrefix = ‘YOUR_PREFIX_HERE’ Embark on Efficient SOQL Query Generation Today With generative AI tools, initiating sample SOQL queries becomes a n easier process, alleviating the need to grapple with syntax intricacies. For admins who occasionally require SOQL queries and find themselves toggling between documentation and references to commence, leveraging generative AI represents a compelling alternative. Here are some additional pointers for harnessing generative AI tools to craft SOQL queries effectively: Be precise: Furnish the tool with specific instructions to ensure accuracy and efficiency in query generation. Provide examples: Supplying the tool with query examples aids in generating more tailored queries. Test rigorously: Following query generation, ensure thorough testing to verify the returned results align with expectations. Ultimately, by harnessing the power of generative AI, admins can streamline the process of crafting SOQL queries, thereby enhancing productivity and efficiency in Salesforce data management endeavors. Data analysis serves as a cornerstone of business strategy, yet crafting custom SOQL queries to import specific Salesforce data can prove complex and time-consuming, particularly for those without coding expertise. When you add the necessity to amalgamate data from various systems, the process becomes even more cumbersome and inefficient. Coefficient Salesforce SOQL Tools and AI In this insight, we’ll demonstrate how Coefficient’s Formula Builder, powered by GPT, streamlines the creation of custom SOQL functions, and how Coefficient facilitates direct data imports from Salesforce within Google Sheets, all seamlessly integrated into your workflow without ever leaving your spreadsheet. To get started, launch the Coefficient add-on directly within your Google Sheets. If you haven’t already installed Coefficient, simply navigate to the Google Workspace Marketplace to acquire it. Here’s how to install Coefficient: Now that you have Coefficient installed, you can effortlessly import your live Salesforce data. In the Coefficient sidebar within Google Sheets, follow these steps: To do this, follow these steps: The Formula Builder will promptly generate a custom SOQL query based on your specifications. Simply copy this query, and you’re ready to go. With Coefficient, data analysis becomes more efficient and accessible, empowering users of all skill levels to harness the power of Salesforce data seamlessly within Google

Read More
April 13, 2021in Generative AI, Salesforce
Salesforce AI
09Apr

Einstein Opportunity Scoring

Let Salesforce’s artificial intelligence help you and your team focus on the right opportunities so you can close more deals with Einstein Opportunity Scoring. Each opportunity in Salesforce is given a score, from 1 to 99, which is available on opportunity records and list views. Sales reps use these opportunity scores to identify top opportunities. If you use Collaborative Forecasts, opportunity scores are also available on the forecasts page. Plus, use scores with reports, Process Builder, and workflows. Einstein Opportunity Scoring is available to users with or without a Sales Cloud Einstein license. Opportunity scores tell you the likelihood that an opportunity will be closed won. For each opportunity score, Einstein shows the factors that have contributed the most to the score, both positively and negatively. Einstein uses your team’s past closed opportunities, won and lost, to create a predictive scoring model.  This model helps identify which opportunities are most likely to result in a win. Einstein Opportunity Scoring in Lightning In Lightning Experience, the score is shown on the compact layout of opportunity records or on the Details tab. Hover over the score to see a list of factors that contribute to the score. For example, a score could be relatively high because the opportunity is moving quickly through the stages compared to other opportunities. In Salesforce Classic, the score is shown on the record detail of opportunity records. The contributing factors are shown. You can add the Opportunity Score field to any of your opportunity list views. If you don’t see the score on public list views, ask your Salesforce admin to add it. In Lightning Experience, hover over the score in the list view to see the factors that contribute to the score. In Salesforce Classic, the contributing factors aren’t available from the list views. Instead, navigate to the opportunity record detail page. The opportunity score can be calculated using a variety of factors, such as market demand, competitive landscape, the potential ROI, and the resources required to pursue the opportunity. Einstein Opportunity Scoring provides an unbiased, objective prediction on the likelihood of a deal closing, based on data patterns from previously closed deals. Then, take the guesswork out of forecasting. Einstein Forecasting uses AI technology to bring more certainty and visibility to your forecasts. Improve forecasting accuracy, get forecast predictions, and track how sales teams are doing. What is the difference between Einstein Lead Scoring and opportunity scoring? Einstein Opportunity Scoring is part of Sales Cloud Einstein Scoring, which also includes Einstein Lead Scoring. In the hierarchy, Einstein Lead Scoring comes under Salesforce’s Sales Cloud Einstein model. Opportunity scores tell the salesperson the likelihood of an opportunity to be won. Like1 Related Posts Salesforce Marketing Cloud Transactional Emails Salesforce Marketing Cloud Transactional Emails are immediate, automated, non-promotional messages crucial to business operations and customer satisfaction, such as order Read more Salesforce Unites Einstein Analytics with Financial CRM Salesforce has unveiled a comprehensive analytics solution tailored for wealth managers, home office professionals, and retail bankers, merging its Financial Read more AI-Driven Propensity Scores AI plays a crucial role in propensity score estimation as it can discern underlying patterns between treatments and confounding variables Read more Asset Management Salesforce Can Salesforce do asset management? You can manage assets in Consumer Goods (desktop) and in the Consumer Goods offline mobile Read more

Read More
April 9, 2021in Einstein 1 Platform, Einstein Insights, Salesforce Einstein, Salesforce Sales Cloud
marketing cloud utm parameters
07Apr

What Are UTM Parameters in Marketing Cloud

What Are UTM Parameters in Marketing Cloud? UTM parameters are essential for tracking the effectiveness of your marketing messages by linking user clicks to actions on your website within Marketing Cloud. Once set up, the Marketing Cloud Engagement tool automatically adds these parameters to the URLs in your messages, enabling detailed performance tracking. You can track five key UTM parameters: source, medium, campaign, term, and content. These parameters are captured in Google Analytics reports, offering insights into your marketing efforts, such as total goal conversions, bounce rate, and average time spent on your site. What is a UTM Code? A UTM (Urchin Tracking Module) code is a text string appended to a URL to help monitor the performance of digital marketing campaigns. UTM codes include up to five key parameters: Campaign, Source, Medium, Content, and Term. UTM Parameter Channel Support: Example URL with UTM Parameters: arduinoCopy codehttps://www.example.com?utm_source=sfmc&utm_medium=email&utm_campaign=TestCampaign&utm_term=MyLink123&utm_content=123456&utm_id=f521708e-db6e-478b-9731-8243a692c2d5&sfmc_id=245678&sfmc_activityid=598741568 Parameter Breakdown: For more on UTM parameters, refer to the Google Analytics documentation. Configuring UTM Parameters in Marketing Cloud Engagement In Google Analytics 4 (GA4), UTM parameters are automatically appended to links in all sent messages unless the domain or subdomain is not on the allowlist in Journey Builder Settings. They will also not apply if click tracking is disabled. Adding UTM Parameters in Salesforce To track UTM parameters in Salesforce, follow these steps: Tracking UTM Parameters in Salesforce There are four primary methods to track UTM parameters and attribution data within Salesforce: Content updated March 2023. Like Related Posts Who is Salesforce? Who is Salesforce? Here is their story in their own words. From our inception, we’ve proudly embraced the identity of Read more Salesforce Marketing Cloud Transactional Emails Salesforce Marketing Cloud Transactional Emails are immediate, automated, non-promotional messages crucial to business operations and customer satisfaction, such as order Read more Salesforce Unites Einstein Analytics with Financial CRM Salesforce has unveiled a comprehensive analytics solution tailored for wealth managers, home office professionals, and retail bankers, merging its Financial Read more AI-Driven Propensity Scores AI plays a crucial role in propensity score estimation as it can discern underlying patterns between treatments and confounding variables Read more

Read More
April 7, 2021in Data, Google, Google Analytics, Salesforce, Salesforce Marketing Cloud
Salesforce
02Apr

Object Relationship Types in Salesforce

Types of relationship in Salesforce You can establish relationships between objects in Salesforce. You can associate one object with another. For example, you have an object named Meetup (to store information about a meeting), and you want to associate it with another object, Participant (to store information about participants for a particular meeting) so that you can associate the Participant records with the respective Meetup record. These relationship types also determine how they handle record sharing, data deletion capability, and required fields in page layouts. Salesforce provides the following object relationship types that can be established among objects: Master-detail relationship It is a strongly coupled relationship among Salesforce objects, which means if a master record gets deleted, then the child records associated with it are also deleted. In this type of relationship, the parent record controls the behavior of the child record regarding visibility and sharing. It means the security setting of a parent object applies to the child object. For example, if we create a master-detail relationship between the Meetup and Participant objects, where Meetup will act as the parent object and Participant will serve as the child object, then if someone deletes a Meetup record, all the associated Participant records will also get deleted. When there is a master-detail relationship between two objects, you can create a unique type of field over the master object, called Roll-up summary. A roll-up summary field allows us to calculate values from child records, such as the number of child records linked to a parent record. Tip For best practice, don’t create more than 10,000 child records for a master-detail relationship. Lookup relationship It is a loosely coupled relationship among Salesforce objects, which means even if a parent record gets deleted, the child records remain in the system. Here, both the parent and child have their own sharing settings and security controls. The following image gives a visual representation of the lookup relationship between Meetup and Participant objects and what happen when parent (Meetup) record gets deleted: For example, if we create a lookup relationship between the Meetup and Participant objects, where Meetup will act as the parent object and Participant will serve as the child object, then if someone deletes a Meetup record, all the associated Participant records will still exist in the system. Difference between master-detail and lookup relationships Let’s have a look at the differences between the lookup and master-detail relationships in the following table: Lookup relationship Master-detail relationship Loosely coupled. Strongly coupled. Roll-up summary field cannot be created. Roll-up summary field can be created. Parent record is not required while creating a child record. Parent record is always required in order to create a child record. Lookup fields are not required on the page layout of the detail record. Master-detail field is always required on the page layout of the detail record. Standard object record can be on the detail side of a custom object in a lookup relationship. Standard object record cannot be a child. By default record ownership of child records is not controlled by the parent. Parent controls the record ownership of child records. The owner field is not available on the detail record in master-detail relationship queues, sharing rules and manual sharing is not possible for detail records as it requires the owner field. You can have a child record without a parent. You cannot have a child record without a parent. You can have a maximum of 40 lookups on an object. You can have a maximum of two master details on an object. No cascade delete. Cascade delete. Self-relationship Self-relationship is another example of a lookup relationship. In Salesforce, we can use lookup relationships to create self-relationship among objects; we can have a maximum of 40 self-lookups. For example, a campaign record can have a Parent Campaign record. External lookup relationship We can create two special lookups on an external object apart from the standard lookup relationship. They are external lookup relationship and indirect lookup relationship. External lookup relationship allows us to link an external object to a parent external object whose data is stored in an external data source. In other words, it allows us to link two external objects. Indirect lookup relationship An indirect lookup relationship allows us to link an external object to a standard or custom object. We can only create an indirect lookup to an object with a unique external ID field on the parent object that is used to match the records in this relationship. While creating an indirect lookup relationship field on an external object, we have to specify the child object field and the parent object field to match and associate records in the relationship. For example, we can display a related list of payments from the ERP external record with matching external IDs on the account object. Many-to-many relationship The many-to-many relationship in Salesforce allows us to link a child record to multiple parents. For example, a campaign is attached to many leads, and one lead may have more than one campaign. If you have two objects, called Case and Article, and you want to relate these two objects in such a manner that one case can have multiple articles and one article is linked to many cases, then we have to use the many-to-many relationship. The many-to-many relationship is made with the help of a junction object. In this case, we can create the third object, let’s say, Solution with two master-detail relationships with Solution – Case and Solution – Article. Note One object can have only two master-detail relationships. Hierarchical relationship In Salesforce, only a user object has this type of relationship where we can create a hierarchy of users in the organization. For example, a user can have his manager, and his manager may have senior manager, and so on till the CEO or CIO level. Like Related Posts Who is Salesforce? Who is Salesforce? Here is their story in their own words. From our inception, we’ve proudly embraced

Read More
April 2, 2021in Salesforce
Design to No-silo Teams
29Mar

Design to No-silo Teams

Design Tips to ‘No-Silo Mentality’ Your Teams Working in silos is a detrimental organizational condition where a team, or group of teams, isolates itself from the rest of the organization. This can happen intentionally, due to organizational structures, or simply as an unintended consequence over time. Design to No-silo Teams can eliminate silos. Silos often result in withheld information, poor collaboration, and work that is misaligned with company goals. What is a No Silo Mentality? A no silo mentality is the practice of actively resisting the natural tendency to create divisions within a company. This approach aims to prevent the formation of an “us versus them” mindset among different teams or levels of leadership, fostering a more unified and collaborative corporate culture. Here are design tips to no-silo your teams. And here are 7 steps to create better collaboration, while you are at it. 7 Strategies to Break Down Team Silos and Enhance Team Effectiveness Highly collaborative and connected teams are more agile and better equipped to meet user needs. In fact, 72% of leaders believe merging teams and responsibilities can improve overall operational efficiency. Here are seven strategies to break down team silos and improve team effectiveness: By implementing these strategies, you can break down silos, enhance team collaboration, and improve overall effectiveness, leading to greater agility and better alignment with user needs. Working in silos is the opposite of collaboration; silos prevent individuals from being part of a team with a unified vision, while different teams work amongst themselves, not knowing what’s happening with other departments or initiatives in the business. By implementing these no-siloed Design tips, you can effectively ‘no-silo’ your product and other teams, fostering a culture of collaboration that enhances customer satisfaction and drives success. Content updated April 2024. Like Related Posts Who is Salesforce? Who is Salesforce? Here is their story in their own words. From our inception, we’ve proudly embraced the identity of Read more Tectonic’s Successful Salesforce Track Record Salesforce Technology Services Integrator – Tectonic has successfully delivered Salesforce in a variety of industries including Public Sector, Hospitality, Manufacturing, Read more Asset Management Salesforce Can Salesforce do asset management? You can manage assets in Consumer Goods (desktop) and in the Consumer Goods offline mobile Read more What is Salesforce? Salesforce is cloud-based CRM software. It makes it easier for companies to find more prospects, close more deals, and connect Read more

Read More
March 29, 2021in Unified Knowledge
Cloud Computing for NGOs
22Mar

Cloud Computing for NGOs

As cloud computing becomes more prevalent and accessible, nonprofits are increasingly leveraging its benefits to enhance operations, boost fundraising efforts, and adapt to changing circumstances. Cloud Computing for NGOs. Despite this transition trend, some organizations remain hesitant to adopt cloud technology due to perceived costs, technical expertise gaps, and concerns about security. However, the advantages of cloud computing are pplentiful and can significantly impact nonprofit efficiency and effectiveness. Cloud Computing for NGOs For nonprofits, especially those impacted by the ongoing pandemic, cloud computing offers transformative advantages. It allows organizations to conserve resources by freeing up in-house IT teams or reducing their reliance on them altogether. Furthermore, cloud technology enables nonprofits to enhance digital experiences for donors and volunteers, particularly for those accustomed to in-person fundraising events. Beyond these benefits, cloud computing drives digital transformation within nonprofits, revitalizing processes and enhancing marketing efforts. Here are some specific advantages of cloud computing for nonprofits: Process Advantages: Marketing Advantages: For nonprofit organizations striving to create awareness, raise funds, recruit volunteers, and advocate for change, cloud computing offers a cost-effective solution to enhance operational efficiency, improve marketing strategies, and ensure compliance and security. By embracing cloud technology, nonprofits can thrive in today’s digital landscape while focusing on their core mission of serving communities and effecting positive change. Like Related Posts Who is Salesforce? Who is Salesforce? Here is their story in their own words. From our inception, we’ve proudly embraced the identity of Read more Salesforce Marketing Cloud Transactional Emails Salesforce Marketing Cloud Transactional Emails are immediate, automated, non-promotional messages crucial to business operations and customer satisfaction, such as order Read more Salesforce Unites Einstein Analytics with Financial CRM Salesforce has unveiled a comprehensive analytics solution tailored for wealth managers, home office professionals, and retail bankers, merging its Financial Read more AI-Driven Propensity Scores AI plays a crucial role in propensity score estimation as it can discern underlying patterns between treatments and confounding variables Read more

Read More
March 22, 2021in Cloud Computing, Salesforce for Nonprofits, Salesforce Nonprofit Cloud, Salesforce Sales Cloud, Salesforce Service Cloud
Salesforce work.com
18Mar

Salesforce Work.com Explained

Work.com was developed in response to the challenges posed by the Coronavirus Pandemic, offering support to companies and communities in safely resuming their operations. At its core, Work.com features a command center that empowers users to make informed, data-driven decisions regarding the safety of various activities, such as reopening offices. Seamless integration with Tableau allows the visualization of extensive datasets. Beyond the command center, Work.com incorporates essential features, including employee health and wellness monitoring, shift management for capacity planning, and contact tracing. Welcome to Work.com, an employee-centered experience designed to help everyone at your company succeed, regardless of their work location. Key Features: Is Work.com owned by Salesforce? Yes, Salesforce acquired the technology behind Work.com in 2011 when it purchased Rypple, a Toronto-based company that provided cloud-based human resources (HR) software. The application has since evolved through various iterations, expanding its focus to enhance employees’ remote work experience. Work.com Customer 360 Integration Work.com integrates the full power of Salesforce Customer 360, health experts, business leaders, and the Salesforce partner ecosystem. It equips teams with the tools needed to be productive, safe, and resilient in the evolving landscape of business operations, employee safety, wellness, experience and productivity, and customer trust and communications. Workplace Command Center serves as a company’s “single pane of glass” for managing the complexities associated with reopening businesses and guiding employees back to work. It functions as an Operations Executive’s “cockpit” for navigating the organization through crises, resuming business operations, and emerging stronger. Shift Management, an add-on to Workplace Command Center, helps companies balance workplace coverage and employee availability while creating new capacity models that support a safe return to work. HR and People leaders can create shifts to fill workplace capacity, while staggering arrivals to facilitate a safe return to offices. Employee Concierge delivers one integrated service experience for any employee need, streamlining workflows across various departments and empowering employees to find answers to their questions within Employee Workspace. Like1 Related Posts Who is Salesforce? Who is Salesforce? Here is their story in their own words. From our inception, we’ve proudly embraced the identity of Read more Salesforce Marketing Cloud Transactional Emails Salesforce Marketing Cloud Transactional Emails are immediate, automated, non-promotional messages crucial to business operations and customer satisfaction, such as order Read more Salesforce Unites Einstein Analytics with Financial CRM Salesforce has unveiled a comprehensive analytics solution tailored for wealth managers, home office professionals, and retail bankers, merging its Financial Read more AI-Driven Propensity Scores AI plays a crucial role in propensity score estimation as it can discern underlying patterns between treatments and confounding variables Read more

Read More
March 18, 2021in Salesforce
Salesforce Marketing Cloud Email Studio
17Mar

What is Email Studio in Marketing Cloud?

Enhance your account branding through the Sender Authentication Package (SAP), a tool provided by Marketing Cloud. SAP features include custom account branding, a private domain for email sending, a custom domain for CloudPages, a dedicated IP address, and reply mail management. Upon purchasing SAP, you will receive an email from mc-deliverability@mcld.salesforce.com 1–2 days after your contract activation. This email includes the SAP Quick Start Guide and a personalized form to set up your SAP.

Read More
March 17, 2021in Data, Salesforce, Salesforce Marketing Cloud
gettectonic.com