polling_promotion_customer_points
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
polling_promotion_customer_points [2016/11/30 11:49 (8 years ago)] – swind | polling_promotion_customer_points [2021/05/11 19:00 (3 years ago)] (current) – jbalasabas | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Polling Customer Promotion Points ====== | ====== Polling Customer Promotion Points ====== | ||
- | |||
- | |||
- | [[http:// | ||
- | |||
====== Customer Promotion Points Do Not Poll ====== | ====== Customer Promotion Points Do Not Poll ====== | ||
- | When you create the new remote datasets, they would have the point values showing in the head office | + | When you create the new remote datasets, they would have the point values showing in the head office |
====== Solution ====== | ====== Solution ====== | ||
Line 35: | Line 31: | ||
View the report | View the report | ||
- | This will create | + | This will create |
- | Then we can temporarilly | + | Then we can temporarily |
- | Sort the report by Customer Points column. This will save us a few steps when we process it in Excell. | + | Sort the report by Customer Points column. This will save us a few steps when we process it in Excel. |
- | Now that we have the report, we have to export it to excell. | + | Now that we have the report, we have to export it to excel. |
- | The first thing we need to do is duplicate the Unique Column. It needs to be in the report twice so we can dataload | + | The first thing we need to do is duplicate the Unique Column. It needs to be in the report twice so we can data load the unique into the account number field based on the unique number. |
- | Also we must eliminate all lines that do not have points. This way, only people' | + | Also we must eliminate all lines that do not have points. This way, only people' |
- | The Unique Numbers and Points numbers are exported with a comma in the number denoting the thousands place, This also has to be removed prior to dataloading. | + | The Unique Numbers and Points numbers are exported with a comma in the number denoting the thousands place, This also has to be removed prior to data loading. |
- | This is easilly | + | This is easily |
We need the columns to be named the following: | We need the columns to be named the following: |
polling_promotion_customer_points.1480535353.txt.gz · Last modified: 2016/11/30 11:49 (8 years ago) by swind