Summary:
Guidance on how to add records to a Portfolio in Data Studio. This can be done by a mass Excel import and also manually for individual records.
Solution:
There are three ways to upload or create records in a Portfolio in Data Studio. To learn how to do this, please click on the interactive demonstrations below:
Mass File Upload interactive demonstration.
Individual Record Creation interactive demonstration.
How to add a Record to a Portfolio from a Company Report interactive demonstration.
You can also follow the below steps to add records to a Portfolio:
Mass File Upload:
- From the Creditsafe home page, click on Data Studio in the left navigation bar
- Select Portfolio Manager
- Choose the Portfolio you want to upload records to
- Once you are in the Portfolio, click on the Import/Export tab
- Click the green Import Records button
- Choose New Records option, (note: if the portfolio is empty, updating records won’t be available)
- Click the green Next Step button
- On this page, select whether you want Matching and duplicate management applied to your uploaded records
- Click the green Next Step button
- Attach your import file (.csv, .xls, or .xlsx, max 50MB)
- Tick the box if your file contains a header row
- Click the green Next Step button
- Map your file’s columns to the appropriate Creditsafe data fields
- Click the green Submit button
- You’ll be notified that the file is being processed
- Click on the Records tab to view upload progress
- Once processed, records will appear in the list
Managing Records Duplicated Records:
- To manage duplicate records, click on the Portfolio health tab
- Click on the View Duplicate Records button
- You will be presented with a list of your duplicate records
- Select the record(s) out of the list that you want to remove by ticking the box
- Click Confirm Changes
- If all duplicates are removed, the section will be empty
Managing Matches:
- From your list of records, click on the Unmatched Records tab
- You will be given a list of your unmatched records
- Suggested matches will be flagged
- Click on the orange Suggested Match button to view further details
- Review the suggested match, if this is correct, click the Accept button
- If not, tick Exclude from Match and click Confirm
- Matched records will be marked accordingly
- Excluded records will remain unmatched unless reprocessed
- Click Back to Records to return to your portfolio view
Manually Creating a new Record:
- Select the portfolio where you want to create the new record
- Click the blue Create New Record button in the top right corner
- Fill in company details in the form:
- Required: Name, Country Code
- Optional: Safe Number, VAT/Reg Number, Address, City, Region, Post Code,
- Customer Data
- Use the grey + symbols to add more attributes to your record if this is needed
- Click the green Create Record and Match button in the top right corner
- The record will now begin processing
- The record will now be created. The matching status of the record will show in the top left corner
- Click the Back to Records button in the top left corner
- The new record will now be shown in the record list
Adding a Record to a Portfolio from Company Report
- On the Creditsafe home page, use the Quick Company Search bar at the top center to find the business
- Go into the Company Report
- In the Company Report, click the grey More Actions drop-down in the top-right corner
- Select Add to Data Studio
- In the pop-up, select the Portfolio you would like to add the company to
- You can add a Reference ID and a note if you need to
- Click the green Confirm button to continue
- You will have confirmation that the company has been added to the Portfolio
- Close the pop-up
- Go to Data Studio in the left menu, then click on Portfolio Manager
- Select the portfolio that you added the company to
- The company will now appear in the record list