Customer Relationship Management

September 23, 2010

Here at GU we have a CRM System and a programme of work to improve how institutional contacts and events can be shared via this core system.

The system supports a range of individual and organisational contact types.  This includes alumi and business contacts.

As part of our on-going drive to improve integration we have been thinking about how to better join up the data from different parts of the University.  I am looking at the Research applications and awards and there is also currently a drive being led by staff in Careers, Recruitment, Corporate Communications and Museums. 

What has this got to do with Research Outputs?  Lots of the activities e.g. public lectures and school visits are outputs that Research Councils, the REF and others require information about.


Investigating Export of data to MRC System

September 14, 2010


Today I have been having a further look at how we might send data direct to RCUK system/s in future. 

I pulled a test set of data from our system for some of the entities in the MRC e-VAL exercise as it is actually a LIVE system and I personally think it is a very good place to start as a model for collecting output information.

Initial observations include:

  • ‘Further funding’ and ‘collaboration’ entities are basically the same data extract from our system.  One is working with other parties who are providing some funding and the other is working with other parties who are not providing funding.  I need to discuss further with MRC to check if they need the collaboration to include all the funding (i.e duplicate info).
  • There are a few text fields that hold several bits of info and this can be a bit awkward to store and retrieve easily.  E.g. the ‘impact’ field also asks you to explain if the work was multi-disciplinary.
  • I have been wondering how to identify ‘further funding’ that is relevant to the MRC award without having a field for this in my system as it gets a bit labour intensive – the links between pots of money could be many.  I think that most of the funding obtained by staff after an MRC award might be relevant but of couse some of it might not so how to exclude what is not relevant to the previous MRC award in any way without academics or administrators having to mark it up.
  • Wondering again about standard organisation name codes.  Both internally within GU and across other organisations we use a variety of codes for the same organisation.
  • The usual issue of terminology crops up  e.g. where MRC use project I think that = award on our system.  I have however not come across any major terminology issues with MRC e-VAL so far so should be no problems mapping once we clarify definitions.

These are initial observations and I will let you know how I get on with this over the next few weeks depending on time available to dabble with it!



Some Interesting Views on Metrics

September 9, 2010

This paper explores values and benefits of league tables and metrics.


UNIVERSITY RANKINGS: Diversity, Excellence and the European initiative

This blog article discusses value of metrics: