Category Archives: We Did

Salesforce and TEQSA PIR Reporting – making life easier

For Higher Education providers there is a requirement to report their PIR data on a yearly basis.  This is a time consuming exercise requiring many hours of effort.

If you are running or want to run your SMS on the Salesforce platform, we can implement Salesforce to ensure you have all the required data, including capturing:

  1. Course data for the PCO file
  2. Student enrolment data for the PSD file
  3. Staff data for the PSF File
  4. Course completion data for the PPS file
  5. Load estimate data for the PLE file

In addition we can export all the required PIR data to a text positioned file so that they can be directly consumed into HEPCAT.

Our expertise in this area will ensure you have a solution that is continually validating your data.  We’ll advise you on PIR best practice to ensure reporting time is as painless as possible.

Contact us at getinfo@wdcigroup.net to discuss our experience and how we can help you to meet your PIR reporting in a timely manner and with minimal impact to your organisation.

Wedid: Salesforce Health Check

Health is important for all humans and also for your IT system’s! Keeping your IT system’s healthy helps in sustaining a better business. For example, Salesforce being your company’s CRM system.

Keeping Salesforce healthy helps you access your customer information in a smother and safer environment.

As such, we’ve recently helped our customer to perform a health check against their existing Salesforce instance which have operated for at least 3 years.

Some of the highlights of the health check scope includes:

  • Salesforce very own security health check
  • Scanning apex code/s within the Salesforce instance
  • Monitor Salesforce API request limit
  • And much more

It is recommended to health check your system at least on a yearly basis, similar to your yearly body checkup as well.

If you value your Salesforce instance as much as you value your own health, feel free to contact us for help you with your Salesforce health check.

WeDid: Generating Bulk Document in Salesforce

Challenges

The Customer manages their clientele function bookings (i.e. company meetings, birthday party’s, wedding dinners, etc.) within Salesforce. They would like to generate every functions agenda in bulk so they can be distributed to the Staff for reference/preparation prior to the actual events day. The Customer would also like to have the flexibility over defining a range of functions based on date as well as its venue when generating the function’s agenda.

Solution:

Conga Mail Merge is being proposed as the tool to generate the functions agenda in bulk. Additionally, a page to provide Salesforce users the convenience to define the set of functions to bulk generate and print is set up as well.

Related Objects Account, Conga’s Objects and other related Custom Objects (Functions)
Components Custom Link, Custom Fields, Workflows and Conga
Complexity Moderate

Wedid: Enhanced Recurring Event in Salesforce

Challenges

The customer manages their clientele function bookings (i.e. company meeting, birthday party, wedding dinner, etc.) within Salesforce via a custom event app and integrated with a calendar app to display each of the events in the calendar view. Requests from their clientele for recurring functions/events such as weekly board meeting, community discussion and many more need to be tracked accordingly within Salesforce, plus being displayed on the calendar app view accordingly. Double booking on the slot which may have been booked by other occasions is not allow and needs to be notified.

 

Solution:

The parent event was created via the custom event app. The customer utilised the standard Salesforce task object (which allows defining recurring activities) attached to the parent event.  This  is used to spawn the desired recurring event (Children records to the parent event) when the events are created. They are to be displayed accordingly in the calendar app view as well. Additional apex customisation is used to handle the double booking scenario instead.
Sample flow

Related Objects Account, Tasks/Activities and other related Custom Objects
Components Custom Button, Visualforce Pages, Apex Classes
Complexity Moderate

Wedid: Marketo and Infor (Formerly known as Saleslogix) Integration

Challenges

Customer uses Marketo to track incoming leads that would need to be converted to accounts and contacts respectively in their Infor CRM system. The customer would also like to track all field changes and/or activities that occur in Marketo into Infor as the contact related activities, as well as other custom records being tracked in Marketo at the moment.

Solution:

Purpose To ensure leads and their respective related records from Marketo are in-sync between Contact in their Infor system.
Applications Marketo
Infor
Tool Boomi
Information Marketo Lead > Infor Account/Contact
Infor Account/Contact > Marketo Lead
Marketo Activities > Infor Activities (Custom)
Infor Notes Histories (Custom) > Marketo Notes History (Custom)
Data Formats JSON
Volumes ~100 – 300/day
Process When a new lead is registered in Marketo, the lead record will be in return synced into Infor as Contact with the lead’s company being the Infor account record.
However, when a new contact is created or a contact record is updated in Infor, the information would need to be synced to Marketo as well.
For every change in Marketo Lead (Activities), these trails will need to be synced into Infor as well. Some additional information tracked in Infor (custom object records), needs to be created and tracked in Marketo too.
Schedule ~ 5 minutes
Complexity Medium

Wedid: ActionHRM and Kallidus Integration

Challenges

Customer is tracking employees information through ActionHRM (A Human Resource Management System). These employees need to be tracked as a student record in their Kallidus system (being a student and learning management system) too.

Solution:

Purpose To ensure student records in Kallidus system is up to date from the ActionHRM employee records
Applications Sharefile (FTP)
ActionHRM
Kallidus
Versions Sharefile (FTP)
ActionHRM
Kallidus
Tool Boomi
Information Sharefile (CSV) > (Query) ActionHRM Employees > (CSV) Kallidus
Data Formats CSV and JSON
Volumes ~10/day
Process A set of qualified employees Id will be listed in csv format and to be uploaded to an FTP server. The integration process in return query for the employees details using ActionHRM API to produce student information in csv format for Kallidus to process.
Schedule Daily
Complexity Medium

Case Study: Amnet Sales Automation

amnet_logo

AMNET provides responsible and effective data driven display advertising, performance marketing and brand campaigns. We fuse smart Demand Side Platform technology and data to improve our service delivery to clients by buying highly targeted multi channel media.

Challenge

Sales Automation was a key challenge for Anmet in early 2015 with many sales processes being handled in outdated tools. Management visibility into new sales and renewals was not accurate which made forecasting revenue difficult and time consuming.  With a complex sales model finding an off the shelf product was not an option, so a solution was required that could be customised to fit the specific needs of the Sales team. The solution needed to be flexible and customisable to handle changes to process and or product as they occur.

Solution

The choice of Salesforce.com as the leading sales automation platform was not a difficult one. Choosing the right partner who could plan, customise and deploy the initial release was critical. Amnet chose WDCi as the implementation partner. Together we designed and released a successful Sales Automation process that included the following key features:

  • Tracking of Campaigns, Advertisers and Insertion orders
  • Quote templates that were created automatically from the platform
  • Tracking of revenue projections by channel or advertiser
  • Handling rate calculations
  • Automated renewals

Since launch in 2015, Amnet has expanded its use of SalesForce to manage client billing as well as to become the source of truth for all business intelligence for the company.

Vikki Pearce, Head of Commercial ANZ noted that “Salesforce has enabled us, as a rapidly growing and ever-changing business to build a stable and effective platform from which to deliver our business objectives and provide a robust and accurate data set. WDCi have been fantastic in supporting us customise the platform to our needs and as we continue to evolve we hope to continue working together closely.”

Wedid: Using Salesforce in a Residential Care Environment

Challenges

The main business requirement for the aged care facility was streamlining all the information to a single point of data entry as well as providing transparent updates to the residents.  Optimal care of the resident is enhanced when all data is stored in a single system.

Data such as medical records, progressive monitoring and the sharing of social updates as well as picture sharing among family members accessible via mobile.

Ability to grow as the facility increased the number of residents. The ability to provide a secure data store with access restricted based on users and information type.

Solution:

  1. Gather all data and understand the origin and process involved
  2. Design the data model and to ensure a single point of data but ensure that security will not be compromised
  3. Leverage Salesforce Customer Community to provide updates on the residents to family members

Related Objects Lead, Account (Person), Contact, Other Custom Objects
Components Data modelling, Customer Community, Visualforce Page, Apex Trigger
Complexity Medium

Wedid: Campaign Response Tracking

Challenges

Faced with some restrictions using Enterprise Edition this client requested multiple automatons in regards to tracking their clientele responses for running campaigns targeting existing clients response on prospective products being added to the Product List (assessing product validity) using the campaign object.

Solution:

By creating a custom object and reusing the same process builder where applicable around the campaign object, the limitations within Enterprise edition were able to be maintained, from creating child records to assigning tasks to the different account owners, campaign member status update, updating and closing all tasks associated once the information had been collected.

Related Objects Campaign, Campaign Members, Custom Collection Object
Components Process Builder, Enterprise Limitations
Complexity Medium

Wedid:BCI Data Modelling in Salesforce

Challenges

Data intelligence and leads coming from BCI are the core sales opportunity in the business of our chemical construction site service customer.

These leads are externally provisioned through CSV files and it needs to be tracked in Salesforce so that it can blend into other business data. The convergence of these data will help the customer form a powerful source of report in the forecast and finance area.

The current challenge is these data are residing out of Salesforce system.

Solution:

  1. Review through the files given by BCI and review the data that need to be in Salesforce
  2. Identified the core objects – Project, Firm, Contact, Contact Role
  3. Work through a model to connect these objects as part of Standard/Custom object and link with Opportunity to track any finance information
Related Objects Account, Contact, Project (CO), Opportunity, Opportunity Contact Role
Components Data modelling
Complexity Low