SkyGlue Sends Database & CRM User Data to Google Analytics

Send Database and CRM user data to GA

Google Analytics and other web analytics solutions only store certain information about website visitors such as traffic sources, number of visits, pages visited, number of conversions, etc. The missing pieces are transactions and revenue stats, which are stored in the CRM system. Connecting the CRM data to Google Analytics data allows you to evaluate the performance of online marketing channels based on actual revenue numbers.

You will be able to:

  • Measure the actual dollar value down to each ad, each Google ads keyword or email;
  • Optimize your sales channel based on performance and revenue generated;
  • Calculate Return on Investment (ROI) and map out customer life time value from online to offline conversions;
  • Build accurate multiple channel acquisition models in GA;
  • Create user segments based on lead status (warm/cold leads; how far a lead has progressed; etc.) and carry out online remarketing campaigns with lists of targeted visitors.

Google Analytics user list report showing data from database/CRM:

TitleStatusImportToGA

Google Analytics user explorer report showing data from database/CRM:

TitleStatusImportToGAUserReport

SkyGlue currently supports integration with the following data repositories:

Relational and Analytics

Amazon Redshift Clipper dBase EnterpriseDB Foxpro
IBM DB2 IBM Informix Microsoft Analytics Platform System Microsoft SQL Azure Microsoft SQL Server
MySQL Community MySQL Enterprise Oracle Database Pervasive SQL (Btrieve) Pivotal Greenplum
PostgreSQL Progress® OpenEdge® SAP Sybase ASE  SAP Sybase IQ Teradata

Saas/Cloud

Salesforce.com Data Sources Using Salesforce Lightning Connect ServiceMAX SugarCRM Veeva CRM
 FinancialForce Force.com Applications IBM dashDB IBM Db2 Hosted Microsoft Dynamics CRM
Microsoft Azure SQL Data Warehouse Oracle Autonomous Data Warehouse Cloud Oracle Database Cloud Service Oracle Database Exadata Oracle Eloqua
Oracle Sales Cloud Oracle Service Cloud Progress® Rollbase®  REST API Aurora PostgreSQL

Big Data

Amazon EMR Hive Apache Cassandra Apache Hadoop Hive Cloudera CDH Hive Cloudera Impala
 DataStax Enterprise Hortonworks Hive IBM BigInsights Hive MapR Hive MongoDB
Pivotal HAWQ Pivotal HD Hive Spark SQL

Text/XML/EDI

EDI data Flat files: CSV, TSV, Text files and more Healthcare EDI: HIPAA, HL7 and NCPDP XML

 If your CRM system or database is not listed above, with a little tweak of setup, we can always make it work. Get in touch with us for details.