Get the Data
Uploading your company's data for freeUploading your data for free is the best way to see how our service performs. Our introductory free service allows anyone to upload as many sample data files as they like
* See Transaction Data Requirements.
Where is the data?
Most retailers have database systems that record the purchase of every item at the register. For example, Acme Retailer sold 100,000 items yesterday. It is this list of 100,000 items that CustomerTool needs to begin providing value.
Customer Support: admin@customertool.com is here to answer your questions, including questions like: - "How do I ask my IT team for the data?"
- "Why is my data not uploading correctly?"
- "Is your website secure?"
- "Which level in my product hierarchy should I use?"
- "How should I sample my data?"
- "Can you help me read my reports?"
Transaction Data Requirements1) Free upload limit will be about 4MB or 110,000 items purchased.
2) The file must be a comma seperated file (csv) and have no quotes. Exceptions to this rule can be made by contacting admin@customertool.com
3) FIELD MAPPINGS: The files must follow our required column format:
Transaction ID, Product Number, Quantity, Unit Price, Product Name
* See Example SQL section to extract a file in this format
* Please remove the currency symbol from the unit price column of your data.
* Please do not aggregate your transactions. There should be 1 rows for each item purchased. If you are uploading a file with 100,000 items purchased there should be 100,000 rows in the file.
Example SQL to extract from your company's database
With Join to Product_Name Table
SELECT
Sales_Detail_Table.Transaction_Identification, Sales_Detail_Table.Product_Number, Sales_Detail_Table.Quantity,Sales_Detail_Table.Net_Price, Product_Name_Table.Product_Name
INTO OUTFILE "sample.txt" FIELDS TERMINATED BY ','
FROM
Sales_Detail_Table, Product_Name_Table
WHERE
Sales_Detail_Table.Product_Number = Product_Name.Product_Number AND
Sales_Detail_Table.Date is between (Beg_Date AND End_Date)
LIMIT 110,000
About Dimensions (Product Categories)
Most Product Categories are hierarchical in nature. For example, most companies have a product hierarchy that might look something like this: All Products->Departments->Classes->Subclasses->SKUs. Which level in the product hierarchy you choose to extract should be determined by your business needs. Continuing with our example, if you chose to extract at the top level of the product hierarchy there would be no customer segments because all of your customers buy all of your products. Typically, most end-users find the Class to Subclass level to be of sufficient value to use in our application. Our application permits SKU level analysis. Typically the number of products that are helpful for our application tend to contain anywhere from 10-300 different types of products.
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part5/c1761.mspx?mfr=true
|
|
