Skip to main content

#Data Management102 discutindo

Customers and prospects ask for new features all the time.

 

Our company execs want to be able to track the revenue potential for building new features.  

 

My thought is to develop the following, but is there a better or already-defined process for doing this?

 

1.  Create a new opportunity picklist field named "New Feature Requested" and offer a list of known features under consideration. 

 

2.  Include "other" as a value

 

3.  Create a text field called "Other New Feature Request" that is dependent on the "other" value on the field above.

 

4.  Run an opportunity summary report that identifies the total revenue potential, summarized by the two fields above. 

 

Have I over-simplified this?  Is there already a more dynamic solution for this?

 

Thanks in advance for the advice, 

 

Sue
4 respostas
  1. 2 de fev. de 2015, 23:08
    I would track feature requests in a custom object. Then relate them to opportunities with a junction object. this way you can have many feature requests on one opportunity. You can also track additional details around feature requests, such as totals, dates, status, desciptions, etc...

     

    On the junction object, you might also want to track additional customer notes such as "I need this feature, as it will enable me to...." You may end up with different reasons for thesame feature, which may affect the final design - such as customization options and such. Technically a picklist will work, but if you're going to track it, I bet there's a lot of additional useful data there. Including date of request and such.

     

    So picture this scenario... You're tracking feature requests as i described above... you have 50+ opportunities associated, and you also placed specific contacts on the junction records. So once the feature request status changes to 'building' or 'devlivered' you can now send a notification to all of the contacts that had requested the feature - and a note to sales people to reach out to their contacts to sell the additional features... There's a lot you'll be able to do with this data!
0/9000

I am trying to align data from a CSV excel document attached to the correct fields/API's in my Salesforce CRM. I am trying to align 4 columns from the excel CSV (Building, Tenant Name, Lease Expiration, Square Feet) to the correct Fields in the salesforce. The way it is set up now, if I click on Buildings, it will have the associated Tenants in each Building. I also have a Tenant's tab that has the same information that i am trying to input so this information feeds to a few different tabs within the crm. Any help would be much appreciated!!!!  

 

#Data Management  #TrailblazerCommunity  #Salesforce  #Reports & Dashboards  #Salesforce Developer  #Trailhead  #Trailhead Challenges

1 resposta
  1. Ontem 13:37

    You need to Insert new records into the Tenant

    object using the following CSV structure. 

    You need to Insert new records into the Tenant object using the following CSV structure.

     

    Important Field Setup Notes:

    • Auto-Match: Salesforce's data import tools should automatically match the columns to the correct fields.
    • Troubleshooting Unmapped Fields: If a field fails to map, please check its Field-Level Security (FLS). Ensure that the profile of the user performing the upload has explicit Edit access to that field.

     

    How to Get the 18-Digit Building Record ID:

    To link the tenants to their correct buildings, it is recommended to use the 18-digit Salesforce Record ID in Primary Building column. You can gather these IDs using one of two methods:

     

    Method 1: Grab it from the URL (Best for a few records)

    1. Go to your Buildings tab in Salesforce and click on a building.
    2. Look at your browser's address bar.
    3. The 18-digit ID is the long string of letters and numbers right after the object name. It looks something like this: .../Building__c/a008W00000XyZ12QAF/view
    4. Copy that ID (a008W00000XyZ12QAF) and paste it into your CSV.

    Method 2: Run a Quick Report (Best for mass uploads)

    1. Go to the Reports tab in Salesforce and click New Report.
    2. Select your Buildings object as the report type and click Start Report.
    3. In the left-hand sidebar, go to Fields and search for Building ID (or Record ID).
    4. Drag and drop that ID field into your report columns.
    5. Click Run, then click the arrow in the top right to Export the report as a Excel/CSV file.
    6. Use VLOOKUP in Excel to instantly match those IDs to your Tenant CSV based on the building name.
0/9000

I have ran a large test load and discovered that I have exceeded the storage.  To quickly remedy this have deleted the custom object and yet my storage limit hasn't decreased.  Do I need to recreate the custom object and it's fields before I can use the dataloader to remove them?

7 respostas
0/9000
1 resposta
0/9000

Verify step error :- The 'Lead' records from the CSV were not found. Please check the instructions. 

Import report file error :- 

 FIELD_INTEGRITY_EXCEPTION:There's a problem with this country, even though it may appear correct. Please select a country/territory from the list of valid countries.: Country:Country -- 

 

 

However, I confirmed accurate data and tried couple of times. Also checked the value in Salesforce State/Country Picklist validation. 

Also checked this instruction Note: If experiencing verification issues, make sure the Salesforce user which is used to import the data has English language and English (United States) location selected. 

Use the Data Import Wizard, In last stage getting the error Records Failed

 

 

 

#Data Management

3 respostas
0/9000

Hi.. We are planning to Migrate from Siebel to Salesforce. Need some help to understand how we can load Siebel Assets (including the child Hierarchy and its attributes) into Salesforce as a one time job.

 

Any ETL conversions can be done and is there any option in salesforce, that we can directly import the data? Can you we use any staging tables in Siebel and use these tables of Siebel for a conversion using any procedure and then import in Salesforce?

4 respostas
  1. Sushil Kumar (UKG) Forum Ambassador
    23 de jul. de 2024, 18:17

    Salesforce has couple of data loading tools but they dont provide ETL type capability, you will have to manually transform data into required csvs. Examples include SF data loader, Import wizard, Dataloader.io etc. If you really need to transform data before loading you need some middleware tool in between like informatica/mulesoft/db amp etc. These middleware can connect to external data sources, transform data and have native connectors to load data into salesforce. 

0/9000
Hi Experts,

 

While deploying dashboards to another org , i am gettign this error called "You reached the limit for dashboards run as the logged-in user." , can anyone help me how to solve this or another way to deploy. Thanks in advance
7 respostas
  1. 5 de abr. de 2019, 08:53
    Hi Aditya,

     

    For performance reasons, there is a limit of how many dashboards you can have in an org that run as the logged in user, and not as a predefined user in the dashboard settings. If you can't deploy yours, it means you have reached that limit.

     

    You'll need to find another dashboard on your production org that is set to run as the logged in user and either delete it, or set it to run as a specific user.
0/9000

Even after deleting the workflow rules in salesforce, the reference is still seen when uninstalling a package. Have checked the meta data and the recycle bin, didnt find anything there.    

3 respostas
0/9000

Hi All,

I have seen some community articles and even Salesforce help articles: Data Loader behavior with Bulk API enabled using 'Insert null values' (salesforce.com)

which specify how to make field values null while using the <Bulk Api> option of data loader.

However, I am not able to make it work, am not sure if it works at all.

 

1. I have tried with csv where field values were blank, and it did not work.

2. I have tried with CSV where field values were explicitly mentioned as <#N/A>, it failed with following error

Error converting value to correct data type: For input string: "#N/A".

 

If anyone was able to make it work, your detailed insights would be helpful.

Thanks

3 respostas
  1. 14 de jun., 22:14

    I had this same question -- please note that the question is explicitly regarding using the Bulk API, which you have to turn off to utilize the "Insert Null Values" option in Dataloader. I run into CPU timeout issues when I run it with the Bulk API turned off. 

     

    The answer is that you can enter "#N/A" into the cells you want to be made blank, as would be returned from an unmatched value in a VLOOKUP. One response I found said to enter "#.N/A" and the period may be a typo. Do not use a period.  

     

    TL;DR -- Enter "#N/A" to overwrite data in a field when using Bulk API in Dataloader.

0/9000
Lena Wong perguntou em #Sales Cloud

Hi all,

I am on my search of a good data quality tool which should not be expensive.

Which data quality tool would you recommend from your experience?.

 

#Sales Cloud  #Integration  #Data Management

4 respostas
  1. Ajaypreet Singh Saini (Grantbook) Forum Ambassador
    15 de fev. de 2024, 17:46

    Hey @Lena Wong, have you tried Salesforce optimizer and Health Check tools in salesforce?

     

    https://www.salesforceben.com/salesforce-health-check/

    https://www.apexhours.com/salesforce-health-check/

0/9000