The two CRM databases were completely siloed and updated on a daily basis, often by users who did not have access to both databases

Client Requirements

DNSW member details are held in two different Microsoft Dynamics CRM systems – the national NDSS database dating back to 1987 and a more recent 2011 DNSW database – each containing approximately 350,000 records. The two CRM databases are completely siloed and updated on a daily basis, often by users who do not have access to both databases. The CRM databases had never been cleansed and validation rules were minimal leading to the growth of many duplicates. This resulted in an unacceptable overlap of customer information, inconsistencies and incorrect data on one, or both, of the two databases with letters often getting sent to the wrong address and marketing opportunities missed.
DNSW required a single unique view that provided a true indication of all the people on both databases, identifying and consolidating duplicate matches and enhancing their own database with new government records that did not exist on the DNSW database and vice versa.

Discover DCA’s solution

Download PDF

Resource Types

                            Array
(
    [0] => WP_Term Object
        (
            [term_id] => 3
            [name] => Case Studies
            [slug] => case-studies
            [term_group] => 0
            [term_taxonomy_id] => 3
            [taxonomy] => resource-type
            [description] => 
            [parent] => 0
            [count] => 43
            [filter] => raw
            [term_order] => 1
        )

    [1] => WP_Term Object
        (
            [term_id] => 4
            [name] => Whitepapers
            [slug] => whitepapers
            [term_group] => 0
            [term_taxonomy_id] => 4
            [taxonomy] => resource-type
            [description] => 
            [parent] => 0
            [count] => 14
            [filter] => raw
            [term_order] => 2
        )

    [2] => WP_Term Object
        (
            [term_id] => 5
            [name] => Fact Sheets
            [slug] => fact-sheets
            [term_group] => 0
            [term_taxonomy_id] => 5
            [taxonomy] => resource-type
            [description] => 
            [parent] => 0
            [count] => 12
            [filter] => raw
            [term_order] => 3
        )

    [3] => WP_Term Object
        (
            [term_id] => 7
            [name] => Webinars
            [slug] => webinars
            [term_group] => 0
            [term_taxonomy_id] => 7
            [taxonomy] => resource-type
            [description] => 
            [parent] => 0
            [count] => 2
            [filter] => raw
            [term_order] => 5
        )

    [4] => WP_Term Object
        (
            [term_id] => 34
            [name] => Tools
            [slug] => tools
            [term_group] => 0
            [term_taxonomy_id] => 34
            [taxonomy] => resource-type
            [description] => 
            [parent] => 0
            [count] => 15
            [filter] => raw
            [term_order] => 6
        )

)