May 2019

Salesforce is one if the leading CRM platforms used across the globe. According to Girikon’s Salesforce Consultants it is one of the largest and widely used CRM software in the market. Salesforce has two types of storage i.e. Data storage and File storage. File storage includes attachments, items a user has uploaded into the Documents tab, and Salesforce CRM Content. Contact Manager, Group, Professional, Enterprise, Performance, and Unlimited Editions are allocated 10 GB of file storage per org. Essentials edition is allocated 1 GB of file storage per org. All other data, including activities is considered a record and counts towards your Data Storage allocation. Data Storage limits for every Contact Manager, Group, Enterprise, Professional and as well Performance editions are calculated at either 1 GB or on a per user limit (20 MB per user) whichever is required for production orgs. For a business keeping their expenses in check keeping an eye on storage limits is the main goal. We all agree that Salesforce is a great CRM but when it comes to licence pricing it can get very expensive when you consider licence per users etc. If the organisation’s concern is storage cost and the users are continually uploading data at an alarming rate, then it is important to apply Girikon’s strategy for managing the orgs data. Emails and Cases are very crucial pieces of information and they can take up a lot of space. Each email takes around 2Kb – 10Kb data (it varies on a case by case basis depending on the email content) and each attachment sent alongside the email can be up to 20Mb. Management of the orgs data can be more effective by managing by archiving and then restoring the emails when needed. The Archiving strategy is very simple, and it has proved to be very effective. Our Salesforce Consultancy Services team often advise users to use the two custom buttons which are Archive and Retrieve which does all the work for the users. When clicking on archive, the emails in the related list gets archived or gets stored as an attachment. Before sending or receiving the email. After sending the email. The email is showed in the email related list and the data storage is increased. When the archive button is clicked. A visual force page pops up to ask you that “Are you sure you want to archive?” After archive the email gets into the attachments and the data storage is decreased. Let us explore the backend logic behind the storage when an email is sent or received, it creates a record in emailMessage object and the attachments along with that email creates a record in attachment object in salesforce. The record that is created has a parent Id equals to the case Id and the attachments that were sent along with that email have their parent Id equal to the email record Id. So, when we hit on archive button the code runs in the background which creates a new record or file i.e.  email(emailId).txt in the attachment object which have the email and its details such as: – BccAddress, CcAddress, TextBody/HTML body etc. And for the attachments that were delivery with the email, the parent Id of those gets re-parented and now is equal to the caseId. After that the email record in the emailMessage Object gets deleted which reduces the Data Storage. Email retrieving is also necessary after the user has archived as per the step above to be viewed at a future date. There is also an opportunity for the user to delete the emails. Click on retrieve button. A visual force page pops up and asks, “are you sure you want to retrieve?” The email is retrieved. And the data storage is increased. Let us explore the backend logic behind the storage when an email is retrieved. Code is written in such a way that it reads body of email(emailId).txt and then creates a new record in the emailMessage object from it. For the email attachments, they are again re-parented back to the email with the help of a custom field which the system created in the emailMessage Object to retrieve the attachments. The custom field contains the old Id of the email when it was not archived. After all this is done the code deletes the email(emailId).txt file from the attachments. About Girikon Girikon is a Salesforce Consulting, Oracle Gold, Microsoft Application, Adobe Bronze Technology Partners. We are also ISO 9001 Quality Management and ISO 27001 Data Management system certified.  Girikon’s Headquarters are in the US, with offices in AUS and Technology centre in Noida India with over 150 employees across the three offices. Girikon is a Salesforce Consulting Company that provides cost effective services through a hybrid offshore/onshore model, quality delivery and great testimonials.  

Girikon’s Salesforce Consulting Services team are certified and experienced with both Pardot and Salesforce Marketing Cloud. They have a depth of knowledge about both automated marketing solutions and have many insights to share. Pardot and Salesforce Marketing Cloud are both marketing automation solutions where Pardot can be seen as a tool, Salesforce Marketing Cloud is seen a comprehensive toolkit for Marketeers. Both Pardot and Salesforce Marketing Cloud both allow for a level of social media sharing through their tool/toolkit and both also grant a user access for building custom email campaigns. Despite these similarities, Pardot and Salesforce Marketing Cloud have some differences including the Lead Scoring Model. does not include a lead scoring model however Pardot has default scoring functionality and model that allows for various prospect activities to be scored. In this Blog our Salesforce Consultant will endeavor to show a user how to generate lead scoring from Email based on [_Sent], [_Open] & [_Click] Data Views. Data from [ _sent ] , [ _open ] & [ _click ] by join operation in query to be saved in Data Extension ‘ DE_1’ : Simple perform a Query and join these data view in a separate Data Extension based on your JobID. Ex: from [ _sent ] as a full JOIN [ _open ] as b on a.[subscriberkey]= b.[subscriberkey] full join [ _click ] as c on b.[ subscriberkey ] = c.[ subscriberkey ] Where a.[ JobId ] = < JobID >. For your reference: join syntax: https://www.w3schools.com/sql/sql_join.asp. Create a Data Extension with default score value and save it in Data Extension ‘DE_2’: Import a file containing subscriber key & Initial Score using Import wizard and save these records in separate Data Extension. Note: At least match a few SubscriberKey with ‘DE_1’ while creating import file. Join the two Data (DE_1 & DE_2) Extensions and save it to third Data Extension (DE_3): Using case Statement in Query increment or decrement your Initial Score and save it in ‘Updated Score’ field in the target Data Extension which I have mentioned below in figure (3.2). Along with join these two Data Extension and save it to the Third Data Extension using Query based on SubscriberKey. Ex: CASE WHEN a.[ < Column name > ] IS NOT NULL THEN [ Initial Score ] + ELSE [ Initial Score ] END AS [ Updated Score ] For reference: Case Statement : https://www.w3schools.com/sql/sql_case.asp. Create an Automation and Run the following Activities: After Running these Activities in Automation your records will be updated in Data Extension with updated score: About Girikon Girikon is a Salesforce Consultancy Partner, IT consulting and development company, headquartered in the US with development centre in India and office in Australia. Our Global network allows Girikon to quickly respond to customer’s requirements effectively delivering quality outcomes. Girikon’s team of experienced and certified Salesforce Consultantsincluding Architects, Developers, Consultants, and Administrators. Our MEAN Stack, Atlassian APP, Microsoft Dynamics CRM, Mobile APPs, JAVA, PHP, ASP, .NET and AI consultants and professionals also provide services which are second to none. Our customers and services are many and varied from large multinational companies implementing large programs to small-medium enterprises implementing solutions to improve their competitiveness. Girikon also supports its customers on all leading technology platforms and Girikon’s team of dynamic, seasoned and qualified professionals have a vast experience in IT across many verticals, Product development including design, testing, support and supported by resourcing / staffing models to suit any type of business. Our Vision is to develop scalable & simplified solution for our clients.

Salesforce is a cloud-based CRM (Customer Relationship Management) software. It offers which offers great products in almost every field such as Sales, Support, Marketing, etc., and aids all kind of businesses (big or small) in their day to day activities. Girikon’s Girikon’s Salesforce Consulting Services Team member Nirupuma Shree discusses some of the key features of Salesforce which have aided business’ in their everyday activities: Contact Management- In the Salesforce, the sales rep can record the contact details and then track their progress against a company (Account) which is linked and opportunities they are tagged. The tracking is seamless and with teeny-weeny human effort. As Salesforce is a cloud-based CRM, it gives freedom to the user to add or edit contact’s information anywhere and at any point of time and the users will have the updated contact details available to them instantly. By integrating Social CRM with Salesforce CRM, the sales rep can also view and examine the conversation (with salespeople) that contacts are having on social networks. Opportunity Pipeline Management- With Salesforce Opportunity Management, the sales rep can focus more on closing a deal. Track minute details on the opportunity detail page without missing out on any of it. The sales rep can track the products tagged to an opportunity and its price, quantity and product type The user can set up payment terms, special instructions or any other details. The user can generate quotes & contracts automatically by setting up workflows and on the selected templates. Analytics and Forecasting- With the help of Einstein Analytics, the sales rep can view business data at a glance. Salesforce offers customizable dashboards and reporting tools which provide key performance data and much more to boost sales. Through Salesforce Forecasting, the sales rep can get an expected sales revenue based on the roll-up of a set of opportunities. Marketing Campaigns- Salesforce Marketing Campaigns can benefit the users in several ways like assisting in setting up Google AdWords, sending campaigns across multiple channels and getting leads to the CRM from the campaigns sent. Let us also discuss some of the key benefits which sales rep receive by using Salesforce CRM: Integrations with the 3rd Party Applications- The user has the liberty to install Salesforce apps such as the Smart SMS from Girikon into the Salesforce Org without the need of programming. Most of the applications have some basic steps for installation which helps in installation. Easily Accessible- The Sales rep can access their data, records anytime and anywhere on Salesforce CRM, thanks to its mobile app. It is a perfect tool for users who want to get connected to their sales members and to the sales rep who wants to get updated with the progress of their opportunities. Setting up Activities- Salesforce offers a wide range of features which can be used by the Sales Managers to keep things moving. They can create a task or tasks and assign to their team members, send mail to the client from the record detail page. With this, I am ending today’s article on Salesforce CRM – Key Features & Benefits. Apart from the above-mentioned features & benefits, there are abundant of features which help sales reps to close deals. If you have any query related to this article or want to know more about Salesforce CRM or if you require Salesforce Consulting Services, then do contact us at sales@girikon.com About Girikon Girikon a Salesforce Consulting Partner has a collaborative approach to assist with the development of a pragmatic roadmap Salesforce Adoption. Girikon’s clearly defined Roadmap, Strategy and Change Management methods will bring you success and ensures a positive engagement with leads, prospects and customers. This can be extended to an organization’s employees and ensures the transformation is adopted by all in your business. Girikon’s Salesforce Consulting Services apply best of breed methodologies which will assist you to fine-tune your business processes to meet your objectives. Girikon will not be matched in Salesforce Consulting Expertise and have proven experience in implementing Salesforce solutions across all industries. If you are looking for Salesforce Development Services Girikon will translate your requirements into real business outcomes and real solutions which will push the boundaries of the possible to positive outcomes.

According to Girikon’s Salesforce Consulting Services Team JavaScript has progressed very rapidly in recent years and is still a very powerful programming language that runs on various platforms. If you’re learning JavaScript in 2017 and you haven’t touched ES6, you’re missing out on an easier way to read and write JavaScript. ES6 refers to version 6 of the ECMA script programming language. ECMA script is the standardized name for JavaScript and version 6 is the next version coming after version 5 which is a major enhancement of JavaScript. Let’s start Before ES6, the only way that we could declare a Variable in JavaScript was using the var keyword. When we declared a variable using var Keyword inside a Function. This means that the Scope of that variable would exist only within the Function in which it was declared. And it still makes sense if we declared global variable (outside of a function). Let’s see this example: What do you think it will print? 1 or 2? It will print both value (1 and 2) in the function, firstly 2 and then 1. This is because function scope 2 is printed when the function is called and because of the global scope, 1 is displayed the second time. Most of you would have get this easily and everything is great until we encounter code inside an if Statement like the example below: The code print 2, twice because the var keyword does not support block scope. This example makes no sense to you. A block is any code within curly braces. Block scoping ensures that any variable defined within those braces don’t become global instead they have local scope this type of control prevent you from unexpected behaviour in your code. “Let” Is the new Var The lack of block scoping has caused many headaches for JavaScript developers especially during variable declaration in for loops. So, for this ES6 introduced Let Keyword any Variable assigned with let always have block scope and cannot be hoisted. If we will use let keyword instead of var then it will be less error prone and avoid all the confusing bugs. Const ES6 also introduced another keyword const this can be useful when you need to declare a variable that cannot be redeclared. Const keyword are also blocked scope and cannot be hoisted. However, there are couple of things to be aware of when using the const keyword since const value cannot be reassigned, they must be initialized at the time they are declared. Just don’t forget that constants are immutable so when dealing with objects or arrays, only the object itself cannot be reassigned. Property within that object or array can be changed example: We can execute the following code and the name property will be reassigned without throwing an error. Why type the same thing twice? Developers are always trying to get data in and out of arrays or objects so for this they use code where the property of an object are initialized using variables like: In ES6 you no longer must repeat yourself if the variables and object property names are the same. This code accomplishes the same thing: All we did here was remove the repeating variable name and colon (:). This is very useful when we have objects containing many fields. ES6 also provide a simpler way of getting out of array or objects. This helps reduce repetitive lines of code example: You can now access the data through the variable names. So here the number 1 would be Printed to the console. But instead of this you can use another shortened method known as array DE structuring. The bracket on the left side of the assignment are part of the new DE structuring syntax. So, this is something like four variables named one, two, three, and four and assign the first value in the numbers array to variable one, the second value to variable two, and so on. Shorter, sweeter, great. We think that once you start working with ES6, you will come to love them as much as we do. About Girikon Girikon are IT Development and Salesforce Consulting Company. An excellent choice to be an organisation’s Salesforce Development Partner. As a Software Development Company, we will take the time to meet your requirements. We have a variety of