DATAFEED:Data feed Account Performance Summary report doesn't show "calls" value

Data feed Account Performance Summary report doesn't show "calls" value.

1.Start the calldata script

./calldata.sh /var/local/tsa/config/com.thesearchagency.datafeeds.calldata.properties

2.Place call_data_2012-02-21_s1.csv to directory /var/local/tsa/calldata

CUST ID DATE CALL COUNT

12568678 20/02/2012 88

12568678 21/02/2012 190

touch the file as done /var/local/tsa/calldata/call_data_2012-02-21_s1.csv.done

3)Check warehouse database

[gsingh@optus-qa-agency1 ~]$ mysql -uspike -ptar63t -hdwh-01-write -P3309

mysql> select productCode, clConversions, conversions from

mysql> whDailySourceConv w join products on productID=products.id where

mysql> w.accountid=5860 and w.startTime ='2012-02-21';

-------------------------------------

-------------------------------------

-------------------------------------

19 rows in set (0.00 sec)

4) Ran the datafeed report service

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dat="http://www.thesearchagency.com/smb/DataFeedService/">

<soapenv:Header/>

<soapenv:Body>

<dat:executeJobFromFileSystemRepository>

<!-Optional:->

<job name="Job 1">

<!-Optional:->

<variables>

<!-Zero or more repetitions:->

<variable key="START_DATE" value="2012-02-19"/>

<variable key="END_DATE" value="2012-02-23"/>

</variables>

</job>

</dat:executeJobFromFileSystemRepository>

</soapenv:Body>

</soapenv:Envelope>

5)Check the generated reports at //usr/local/share/tsa/reports/1/ on agency1 server, these reports doesn't show the value for calls.

[gsingh@optus-qa-agency1 1]$ cat report_909.csv 2,ColumnLabelText "Account","Channel","Campaign","ViewBy","Impressions","Prod Conv","Clicks","SEAID","Status","AdCost","contact_us","fb_like","gp_like","page_view","tw_like","vanity_url","calls"

"12568678","Organic Bookmarks/Type-Ins","12568678_2000062_22770_888888_GT","02/21/12","0","0","1","405751","enabled","0","2","1","3","1","4","1","0"

"12568678","Other Referring Domains","12568678_2000062_22770_888888_GT","02/21/12","0","0","51","405751","enabled","0","0","0","0","0","0","0","0"

6)And see the generated outbound datafeed reports.

[gsingh@optus-qa-agency1 datafeeds]$ cat AcctPerfSum_2012-02-19_2012-02-23.csv

Date,CustomerID,Impressions,Clicks,Spend,Nominal_Budget,Carryover,Calls,Pageviews,SocialMediaClicks,WebsiteClicks,ContactUsLeads

2012-02-19 00:00:00.0,atultest-7,0,0,0.0,66.0,0.0,0,0,0,0,0

2012-02-20 00:00:00.0,atultest-7,0,0,0.0,66.0,0.0,0,0,0,0,0

2012-02-21 00:00:00.0,atultest-7,0,0,0.0,66.0,0.0,0,0,0,0,0

.

.

.

.

2012-02-19 00:00:00.0,12568678,0,0,0.0,66.0,0.0,0,0,0,0,0

2012-02-20 00:00:00.0,12568678,0,0,0.0,66.0,0.0,0,0,0,0,0

2012-02-21 00:00:00.0,12568678,0,52,0.0,66.0,0.0,0,1,8,1,2

2012-02-22 00:00:00.0,12568678,0,0,0.0,66.0,0.0,0,0,0,0,0

2012-02-23 00:00:00.0,12568678,0,0,0.0,66.0,0.0,0,0,0,0,0