NetTracker Data Conduits for MySQL, ODBC, Oracle, PostgreSQL, a

The NetTracker Data Conduits for MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases provide direct integration between all editions of NetTracker 6.0 and these databases. The NetTracker data conduits for these databases cull customer and product data from the databases directly into NetTracker summaries, so that online marketing managers can view, for instance, each visitor's name, company, address, phone number and the names of the products they viewed, directly in each NetTracker summary. E-business analysis can be taken to a newly integrated level within NetTracker, by viewing customer or product data from external sources directly in NetTracker Web server or streaming media server summaries, along with clickstream analysis.

The NetTracker data conduits work with Web server or streaming media server reports in all editions of NetTracker.

The value of incorporating customer or product data from external sources directly in Web analytics reporting

By integrating customer or product data pulled from MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases with visitors' clickstream behavior, sessionized by NetTracker, within NetTracker's summaries, online marketing managers and e-commerce professionals can learn even more about their customer base and their interests from their online behavior, such as:

By viewing customer or product data directly in NetTracker summaries, marketing managers can identify new target audiences for their current product base and carry that knowledge over into both online and offline marketing activities. Product managers can also analyze trends in visitors' interests in products while online, so that they can incorporate online channel analysis with their offline product analysis to make overall product mix decisions. Global marketing managers gain intelligence that enables them to design their country-specific Web sites to contain the most profitable content for each targeted country or region of the world. Organizations that target specific businesses can use NetTracker to analyze their Web impact with those businesses and cater their Web initiatives toward them. Sales managers can analyze individual visitor's online behavior using NetTracker and create targeted sales campaigns for groups of visitors. When NetTracker Web analysis is enhanced with external customer and product data, NetTracker summaries provide even more detailed e-business intelligence that e-commerce professionals can use when making their business decisions.

The NetTracker data conduits for MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases pull external data from within these databases into NetTracker Web server and streaming media server summaries. The types of data that can be pulled from these databases include user data, host data, cookie data, visitor data (all of which will insert visitor information--such as the visitor's name, company, phone, e-mail address, etc.--directly within the NetTracker summaries) and information about parameter values (which will insert product information--such as product names--directly within the NetTracker summaries).

For example, the NetTracker data conduits would allow your organization to replace the cookies that represent each unique visitor listed in the NetTracker Cookie Summary with the name and phone number of that visitor. Since the NetTracker Cookie Summary allows you to rank visitors by the total time spent on your Web site within a given time period, your telemarketing managers can use this summary to create a "call list" for a phone campaign that targets all visitors who have viewed products for longer than 20 minutes on your Web site. The NetTracker Cookie Summary would show the telemarketing rep the name, phone number and time spent online for each customer that should be called, and the telemarketing rep can drill down within the NetTracker Cookie Summary to see each of the products that the visitor viewed while online. This arms the rep with some important customer insight for his or her call. To demonstrate, a cookie that was listed in the NetTracker Cookie Summary before the NetTracker data conduit was installed would simply identify a visitor as:

However, once the data conduit has been installed, it can replace the cookie with visitor information and the NetTracker Cookie Summary will identify the visitor as:

Name: Rico Banks
Title: Partner
Company: CCBT Financial Companies Inc.
Phone: 209-555-1212
E-mail: rico.banks@ccbtfinancialcompaniesinc.com

By configuring a NetTracker data conduit to actually look up customer data (via cookies) stored in a database, you could transform your Cookie Summary into a prospect list, complete with information on the views and visits each prospect made.

The NetTracker data conduit will also allow your organization to view each product from your online catalog directly in your NetTracker summaries, along with the clickstream behavior of those visitors that have viewed that product. If your Web site has an online catalog, and the product pages within this catalog are dynamically generated for your visitors, the URLs in your log will look like:

You can use NetTracker's ability to parse parameter values out of URLs to create a NetTracker Parameter Summary of the SKUs that your visitors are viewing, and how many views and visits each SKU receives. A summary of SKUs, such as "xyz1234," would have to be manually deciphered by looking up the name of the product associated with each SKU. The NetTracker data conduit, however, can be configured to replace the SKUs with product names directly in NetTracker summaries. This is useful since very few marketing managers have memorized every one of their SKUs, and the marketing manager for Bagels.com might not know that "xyz1234" is equal to the "sesame seed bagel" in their online catalog. By using the NetTracker data conduit, NetTracker is able to convert the above URL to the following in your NetTracker summaries:

By configuring a NetTracker data conduit to actually replace SKUs with product information in your NetTracker summaries, you can analyze the products that are being viewed on your online catalog with the clickstream behavior of those who viewed them.





Other NetTracker Products NetTracker Enterprise NetTracker eBusiness Edition NetTracker for Business Objects NetTracker for Cognos NetTracker for MicroStrategy Product Extensions		NetTracker Data Conduits for MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases The NetTracker Data Conduits for MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases provide direct integration between all editions of NetTracker 6.0 and these databases. The NetTracker data conduits for these databases cull customer and product data from the databases directly into NetTracker summaries, so that online marketing managers can view, for instance, each visitor's name, company, address, phone number and the names of the products they viewed, directly in each NetTracker summary. E-business analysis can be taken to a newly integrated level within NetTracker, by viewing customer or product data from external sources directly in NetTracker Web server or streaming media server summaries, along with clickstream analysis. The NetTracker data conduits work with Web server or streaming media server reports in all editions of NetTracker. The value of incorporating customer or product data from external sources directly in Web analytics reporting By integrating customer or product data pulled from MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases with visitors' clickstream behavior, sessionized by NetTracker, within NetTracker's summaries, online marketing managers and e-commerce professionals can learn even more about their customer base and their interests from their online behavior, such as: Are female users actually interested in the content that is directed to males? Are the job titles of the most frequent visitors to my site changing, indicating that I should purchase a new "title select" for my next direct mail list? Is interest in products X and Y dwindling on our Web site, while interest in products A and B is increasing? Which Web content and products are most popular with visitors from each country in our customer base? What products are often viewed by the businesses that are most profitable to us? What are the e-mail addresses and phone numbers of visitors that have spent more than 20 minutes looking at products on my Web site (i.e., hot prospects for my sales team to contact)? By viewing customer or product data directly in NetTracker summaries, marketing managers can identify new target audiences for their current product base and carry that knowledge over into both online and offline marketing activities. Product managers can also analyze trends in visitors' interests in products while online, so that they can incorporate online channel analysis with their offline product analysis to make overall product mix decisions. Global marketing managers gain intelligence that enables them to design their country-specific Web sites to contain the most profitable content for each targeted country or region of the world. Organizations that target specific businesses can use NetTracker to analyze their Web impact with those businesses and cater their Web initiatives toward them. Sales managers can analyze individual visitor's online behavior using NetTracker and create targeted sales campaigns for groups of visitors. When NetTracker Web analysis is enhanced with external customer and product data, NetTracker summaries provide even more detailed e-business intelligence that e-commerce professionals can use when making their business decisions. Here's how it works The NetTracker data conduits for MySQL, ODBC, Oracle, PostgreSQL, and Sybase databases pull external data from within these databases into NetTracker Web server and streaming media server summaries. The types of data that can be pulled from these databases include user data, host data, cookie data, visitor data (all of which will insert visitor information--such as the visitor's name, company, phone, e-mail address, etc.--directly within the NetTracker summaries) and information about parameter values (which will insert product information--such as product names--directly within the NetTracker summaries). For example, the NetTracker data conduits would allow your organization to replace the cookies that represent each unique visitor listed in the NetTracker Cookie Summary with the name and phone number of that visitor. Since the NetTracker Cookie Summary allows you to rank visitors by the total time spent on your Web site within a given time period, your telemarketing managers can use this summary to create a "call list" for a phone campaign that targets all visitors who have viewed products for longer than 20 minutes on your Web site. The NetTracker Cookie Summary would show the telemarketing rep the name, phone number and time spent online for each customer that should be called, and the telemarketing rep can drill down within the NetTracker Cookie Summary to see each of the products that the visitor viewed while online. This arms the rep with some important customer insight for his or her call. To demonstrate, a cookie that was listed in the NetTracker Cookie Summary before the NetTracker data conduit was installed would simply identify a visitor as: 24.218.154.115-992914303694 However, once the data conduit has been installed, it can replace the cookie with visitor information and the NetTracker Cookie Summary will identify the visitor as: Name: Rico Banks Title: Partner Company: CCBT Financial Companies Inc. Phone: 209-555-1212 E-mail: rico.banks@ccbtfinancialcompaniesinc.com By configuring a NetTracker data conduit to actually look up customer data (via cookies) stored in a database, you could transform your Cookie Summary into a prospect list, complete with information on the views and visits each prospect made. The NetTracker data conduit will also allow your organization to view each product from your online catalog directly in your NetTracker summaries, along with the clickstream behavior of those visitors that have viewed that product. If your Web site has an online catalog, and the product pages within this catalog are dynamically generated for your visitors, the URLs in your log will look like: http://www.bagles.com/cgi-bin/order.cgi?sku=xyz1234 You can use NetTracker's ability to parse parameter values out of URLs to create a NetTracker Parameter Summary of the SKUs that your visitors are viewing, and how many views and visits each SKU receives. A summary of SKUs, such as "xyz1234," would have to be manually deciphered by looking up the name of the product associated with each SKU. The NetTracker data conduit, however, can be configured to replace the SKUs with product names directly in NetTracker summaries. This is useful since very few marketing managers have memorized every one of their SKUs, and the marketing manager for Bagels.com might not know that "xyz1234" is equal to the "sesame seed bagel" in their online catalog. By using the NetTracker data conduit, NetTracker is able to convert the above URL to the following in your NetTracker summaries: Sesame Seed Bagel By configuring a NetTracker data conduit to actually replace SKUs with product information in your NetTracker summaries, you can analyze the products that are being viewed on your online catalog with the clickstream behavior of those who viewed them.





	Copyright © 2001 TRTEC Informática - Todos os direitos reservados