<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I'm working on developing a Data Warehouse that will utilize data from the GOOGEL ANALYTICS web application.<br />
<br />
I'm finding it difficult to say the least to move the data into a Data Warehouse mainly due to the absence of an UNIQUE PRIMARY KEY for the USER...or VISITOR.<br />
<br />
Can someone tell me if there is a USER_ID &nbsp;or VISITOR_ID that is available in GOOGLE ANALYTICS that can be exported out so as to be used within a data warehouse?
</div>
</div>


Experts,

I'm working on developing a Data Warehouse that will utilize data from the GOOGEL ANALYTICS web application.

I'm finding it difficult to say the least to move the data into a Data Warehouse mainly due to the absence of an UNIQUE PRIMARY KEY for the USER...or VISITOR.

Can someone tell me if there is a USER_ID  or VISITOR_ID that is available in GOOGLE ANALYTICS that can be exported out so as to be used within a data warehouse?

Is there a way to get the USER_ID from GOOGLE ANALYTICS to store in my DATA WAREHOUSE?

Google Workspace is a suite of cloud computing productivity and collaboration software tools and software. It includes Google’s popular web applications including Gmail, Drive, Hangouts, Calendar, and Docs. While these products are available to consumers free of charge, Google Workspace adds business-specific features such as custom email addresses at your domain and storage for documents and email.

Google Workspace

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

Internet marketing, or online marketing, refers to advertising and marketing efforts that use the Web and email to drive direct sales via electronic commerce, in addition to sales leads from Web sites or emails. Specialized areas of Internet marketing can also be broken down into more specialized areas such as Web marketing (, email marketing and social media marketing.

Internet Marketing

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Analytics is the discovery and communication of meaningful patterns in data. Especially valuable in areas rich with recorded information, analytics relies on the simultaneous application of statistics, computer programming and operations research to quantify performance. Specifically, areas within analytics include predictive analytics, prescriptive analytics, enterprise decision management, retail analytics, store assortment and stock-keeping unit optimization, marketing optimization and marketing mix modeling, web analytics, sales force sizing and optimization, price and promotion modeling, predictive science, credit risk analysis, and fraud analytics.