Closed

inbound phone call analysis (google docs or iWork based)

Need to track and aggregate inbound call activity.

Need to design and build cloud based (google docs or Numbers preferably), collaborative spreadsheet aggregating individual calls by employee. Individual call details reported and aggregated (product discussed, how they learned about us (i.e. google, print ad, tv ad), price quoted, and whether client purchased or not.

Monthly ad spending will also be input (total spent on PPC, print advertising, etc,) and metrics will be calculated monthly (i.e. we spent X on PPC resulting in Y calls averaging Z quoted dollars and A booked sales versus similar for print advertising, etc.) Think of this as a call log by individual user by individual day aggregated at days end and monthly and then analyzed.

Should be very easy and quick to enter (select via placing dots in pre-populated options or via dropdown) so employees actually fill in the report. Reporting tools for admin (me) should be very easy to run providing dashboard overview of call volume by employee, dollars quoted per day, week, month, trends overtime, etc.

Skills: Data Entry, Data Processing, Excel, Google App Engine

See more: google call details, design trends 2011, design collaborative, data entry metrics, collaborative design, inbound call spreadsheet, spreadsheet google, phone ad, how phone, call ad, data entry overview, tv ad, sales dashboard, ppc calls, phone call, metrics, inbound, inbound sales, inbound call, google trends, google tools, google reporting, dots, dashboard metrics, collaborative

About the Employer:
( 0 reviews ) United States

Project ID: #1117641

13 freelancers are bidding on average $140 for this job

gshiels

Please see PM

$250 USD in 3 days
(12 Reviews)
5.1
aslammollah711

hi r u agree with me.

$150 USD in 5 days
(0 Reviews)
0.0
sharkgroupz

As my company name is shark infosis..... SHARK INFOSIS is a call center service and BPO setup Provider dedicated to supporting your business' call center needs through a full range of non voice projects, inbound and o More

$170 USD in 28 days
(0 Reviews)
0.0
anidjar2

Please check PM

$250 USD in 20 days
(0 Reviews)
0.0
Ateh

I am up for this.

$250 USD in 5 days
(0 Reviews)
0.0
nahid2

I resive on your way .

$30 USD in 7 days
(0 Reviews)
0.0
shaksalam

I am ready to work

$30 USD in 4 days
(0 Reviews)
0.0
VirtualAssist100

I have references and have worked as virtual assistant for many years.

$45 USD in 3 days
(0 Reviews)
0.0
mushtaq990

I am mushtaq from pakistan and ready to work with you

$50 USD in 5 days
(0 Reviews)
0.0
mdzahid007

I think it's very easy for me

$200 USD in 7 days
(0 Reviews)
0.0
rohit063

hi we can help you

$250 USD in 15 days
(0 Reviews)
0.0
deepaksingh2011

I can do this work in very accurete and efficient manner .Please provide this work to [url removed, login to view]!!

$45 USD in 4 days
(0 Reviews)
0.0
gk0120

I can do it since I have a flexible time.

$100 USD in 5 days
(0 Reviews)
0.0