Home » Categories » Solutions by Business Process » System Features

Special Data Item Names for Web Analysis

Datafile Software

Special Data Item Names for Web Analysis

When importing orders or enquiries from a website into a Datafile Database it can be useful to analyse the sites used and any search engine / terms used. This can then be used to target your web advertising more effectively.

When importing the web details into Datafile the values are generally imported as strings into text fields but for analysis purposes you want to create sub-strings to identify specific key information. These special ‘named’ items allow you to do this via sub (=-type) data items.

Item Name Description

WWWSITE If a sub-item is named WWWSITE and based on an item containing a web address then the system will strip out the ‘www.’ or ‘http://’ prefixes. For example a X-type item containing ‘www.datafile.co.uk’ would become ‘datafile.co.uk’ as the sub item. NB. When creating sub-item set start position as 1 and size equal to that of the base field.

WWWENGINE If a sub-item is named WWWENGINE then the system will parse fields named WWWSEARCHx to determine the website search engine used to reach your website – for example GOOGLE.CO.UK, YAHOO.COM, etc. When importing search terms into a Datafile Database you will often have to import the search terms into three or more fields due to maximum X-type size of 64 characters. If you name these fields as WWWSEARCH1, WWSEARCH2, WWWSEARCH3 etc then the engine sub-item will parse all applicable fields for the search engine.

When creating sub-item base on the first WWWSEARCHx item and set start position as ‘1’ and size equal to that of the WWWSEARCH field.

WWWSEARCH If the sub-item is named WWWSEARCH then the system will return the search string used in Google / Yahoo etc to find your website.As with WWWENGINE above the system parses the X-type items named WWWSEARCHx to return the information.

 

Custom Fields
  • Release ID: 6.2
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Output to Excel Pivot Table
Viewed 25244 times since Tue, Jun 12, 2012
Data Interchange Omit First Row from Import
Viewed 3181 times since Fri, May 27, 2016
Customer / Product History Enquiry
Viewed 5393 times since Tue, Jun 12, 2012
Validate Account and Stock Groups Entries
Viewed 2476 times since Fri, May 27, 2016
Warehouse Tablet - Goods Received Image Capture
Viewed 957 times since Wed, Oct 23, 2024
Emails in HTML Format (Outlook 2007) 2
Viewed 1271 times since Thu, Sep 4, 2014
Ledger Enquiry - History DFDs – Link to Other Applications
Viewed 181 times since Tue, Oct 15, 2024
Landing Pages - Sorting and Grouping on Table Items
Viewed 508 times since Thu, Oct 17, 2024
Spooled Reports - Clear Selected Spool Files
Viewed 4632 times since Mon, Jun 11, 2012
Which Price Matrix Entries
Viewed 3161 times since Fri, May 20, 2016