06/05/05
Design for "ADMIN
LOGIN" page.
ADMIN LOGIN
Dear Partners
This page is for you.
Please identify yourself, so that
we may present to you statistics pertaining to your area of
operations/collaboration.
I belong to:
- Mobile Service Provider - - - - - - [ ]
- Jobsite/Job Portal - - - - - - [ ]
- Job Advertiser [Corporate Employer] - - - [ ]
- Job Advertiser [Placement Agency] - - - [ ]
- Print Media [Newspaper/Magazine] - - - [ ]
ADMIN LOGIN - MOBILE SERVICE
PROVIDER
Welcome.
This login page is for:
- Mr. Mohit Bhatnagar
Vice President
Airtel
- Mr. Gopal Das
Chief General Manager - MS
MTNL (Mumbai)
- Mr. S.P. Pachauri
Chief General Manager - MS
MTNL (New Delhi)
[Login Name: []]
[Password: []]
[Login]
JAM ADMIN ANALYTICS
Dear Mr. Bhatnagar
Commander of an aircraft or a
ship, has his "flight deck". Here is where he sets course - then
monitors feedback from instruments to make "course-correction". All
monitoring in online / dynamic / in real time.
We present here, your own Flight
Deck - in the form of JAM ANALYTICS.
We hope these online / real time
statistics will help you to direct the efforts of your marketing team and to
set goals / targets for them
with regards
Abhinandan
|
Graph/Tabulation |
How Does this Help? |
|
|
1 |
Report of Registrations
[Tabulation] |
* Are new registrations keeping
pace with your targets? * What is your "share" of the
registrations? Is it getting better (or worse)? |
|
2 |
Earnings Summary (Last 6
months) [Tabulation] |
* How much are you earning
every month from different types of SMS? * What is Month-Over-Month growth in
your earnings? * How many subscribers are "Unsubscribing" (JAM
UNSUB)? |
|
TO BE INTRODUCED GRADUALLY |
||
|
3 |
List of Jobsites/Corporate
Websites (from where we download job-advts) [List] |
* Are we aggregating jobs from
a fairly large no. of Jobsites/Corp websites to be able to send millions of
job alerts? covering a wide spread of roles & functions & every
level? |
(2)
|
4 |
No. of Job Advts.
downloaded/processed [Graph] |
* As time goes, are we
downloading/processing ever-increasing no. of job-advts to keep pace with
ever-increasing no. of JAMMERS? |
|
5 |
Job Advt. Break Up
Company function-wise & City wise graphs already uploaded, under
"Where Are the Jobs?" |
* Job-Advts are never spread
evenly/uniformly, across all * Industries * Functions * Designation Levels *
Companies * Cities |
Nor are your mobile-subscribers.
Matching these two sets of
databases [Jobseekers' Database Vs. Jobs Availability Database], will result in
a fine-tuned marketing strategy for your marketing team.
Graphical "Job Market
Profiles" can be delivered on WAP platform
(3)
|
6 |
Match Index [Graph] |
* Match Index =
$\frac{\text{No. of Alerts delivered}}{\text{No. of Alerts requested}}$ |
|
This Index will be made
available: * Overall for World-Wide-Jobs * Overall for a given MSP * For an
Individual Subscriber |
||
|
This Index tells us all, how
good is our "Matchmaking Ability", given all the fluctuations in *
Industry booms & dooms [Supply Chain of Jobs] * Extremes of "Job
Preferences" |
||
|
7 |
Yield Rate [Graph] |
* Yield Rate = $\frac{\text{No.
of "Apply Online" clicks}}{\text{No. of Job-Alerts delivered}}$ |
|
This is the rate at which the
No. of job-alerts delivered, are getting converted into revenue. Obviously
you want as many job-alerts as possible to translate into "Apply
Online" Clicks! |
||
|
This RATE, will be displayed,
at MACRO-LEVEL, for an individual MSP. |
(4)
|
8 |
Database of JAMMERS
[Tabulation] |
* Each MSP will get to
View/Download this database pertaining to his own JAM Subscribers. |
|
This database will provide
break-up of your registered mobile-subscribers, * City wise * Edu. Quali.
wise } Mandatory Fields in Registration * Job Preference wise *
Current Designation wise * Age wise |
||
|
It is possible that, using our
proprietary extraction software, we may be able to also extract and make
available database, * Designation Level wise * Edu. Quali. wise * Current
Employer wise etc. |
||
|
This database will be extremely
useful. |
(5)
|
9 |
Database of Advertisers
[Tabulation] |
* During next 12 months, we
would have downloaded & processed, over 2 MILLION job-advts. From
these, we would have extracted, * Company Names/Addresses/Email IDs *
Positions/vacancies advertised with Man-specifications for each vacancy * Job
Descriptions for each vacancy * "Vacancy-wise" Frequency of
advertising |
|
This database would be made
available to all MSPs - who in our opinion, have put into place, an
aggressive strategy for marketing/promoting JAM amongst subscribers. |
(6)
|
10. |
A-B-C Analysis
[Tabulation] |
You want to know which 20%
of your JAM Subscribers are generating 80% of your JAM revenues. You
may want to reward these "high value" customers with something
equivalent of "frequent flier points" (e.g: some "free"
job-alerts SMS or "apply online" SMS, on their next re-charge
card?). |
|
11. |
Life Time Customer Value -
LTCV |
Unless he becomes
"self-employed", a jobseeker remains a jobseeker for most of his
working life. Using appropriate commercially available software, we will
project/compute Life Time Customer Value of each & every JAM Subscriber
(MSP-wise). |
|
This analysis will help an MSP
project revenues that can be expected over the years. |
(7)
|
12. |
Loyalty Index |
As MSP, you are compiling
excellent/up-to-date statistics re: * No. of Subscribers "leaving"
you * No. of Subscribers "joining" you. |
|
But you have no clue as to *
Who came from where (which MSP) * Who went to where ( ) |
||
|
At least for those, who may
change MSP but continue to use JAM, we would make available to you, the Loyalty
Index of each JAM Subscriber by compiling following data: |
||
|
Subscriber Name: |
||
|
While changing over from one
Service Provider to another, a JAM Subscriber EDITS his "Mobile
No/Service Provider" data, if he wants to continue receiving JAM
Service. Our database stores all "movements" of each JAM user. |
13. Conversion Index
For any given period (or
cumulatively),
$$\text{Conversion Index} =
\frac{\text{No. of JAM SUB (activations) SMS}}{\text{No. of T JAM (Inquiry)
SMS}}$$
Very clearly, this Index tells
us,
"How many inquiries are
getting converted into activations?"
Inquiries (T JAM) are no more
than an "expression of curiosity" on part of a subscriber. Activation
(JAM SUB) is proof that we have succeeded in "selling the concept".
Hence this Index will indicate,
as to how good we are at marketing the concept of JAM.
14. Churn Index
For any given period:
$$\text{Churn Index} =
\frac{\text{No. of "JAM UNSUB" SMS received during the
period}}{\text{Ave. No. of active Subscribers during the period}}$$
Some subscribers are bound to
"deactivate" their service. Foremost reason could be they got a job
and don't need job-alerts any more (atleast for a while!).
Hence a high Churn Index, may not
be bad in itself - If it is due to the fact that jobseekers are finding jobs
thru JAM! If this is the reason, those lucky jobseekers will talk highly about
JAM, to their friends & colleagues - even when they have themselves ceased
to using JAM.
If so, JAM reputation (as a
job-finder) will spread by word-of-mouth, leading to many more JAM SUB
(activation) SMS.
In turn, this would bring down
the Churn Index!
15. Stability Index
For any given period,
$$\text{Stability Index} =
\frac{\text{No. of JAM SUB (activation) SMS recd}}{\text{No. of JAM UNSUB
(deactivation) SMS recd.}}$$
Obviously, we would want this
Index to be above 10 i.e. for every JAM UNSUB SMS, we should receive 10
JAM SUB SMS.
But, what we could reasonably
expect, is that this Index, initially starts at (say), 1000 and then
gradually drops to 10. It is ok, as long as it "stabilizes" at
10!
\#4$ No. of Job Advts
Downloaded
[Table structure titled "No.
of Advts Downloaded From" showing data for Monster India, Naukri,
and JobsAhead across months May 2005, April 2005, and March
2005.]
|
Month |
Monster India |
Naukri |
JobsAhead |
Total |
|
May 2005 |
63894 |
26836 |
14255 |
% |
|
April 2005 |
% |
% |
% |
% |
|
March 2005 |
100% |
Clicking $\uparrow$ will reveal
Same tabulation date-wise.
Clicking $\searrow$ will reveal
date-wise data for JobsAhead.
We should also have a tabulation
as follows:
[Table structure showing
"Total Advts. downloaded during the Month" and "Cumulative No.
from the beginning" across months May 2005, April 2005, and March
2005.]
|
Month |
Total Advts. downloaded
during the Month |
Cumulative No. from the
beginning |
|
May 2005 |
||
|
April 2005 |
||
|
March |
5^\#$ Job Advt. Break-Up
We are already separating
"Function-wise" & "City-wise" & plotting
pie-charts. These charts are prepared for last 30 days. It should not be
difficult to compile MONTH-WISE data and prepare a tabulation such as:
[Table structure titled "No.
of Advts Downloaded from Major Jobsites" showing percentage share for
major cities across months Jan, Feb, Mar, and Apr.]
|
Month |
Jan |
Feb |
Mar |
Apr |
|
City |
||||
|
Mumbai |
40% |
35% |
30% |
25% |
|
Delhi |
30% |
20% |
||
|
B'lore. |
15% |
|||
|
10% |
||||
|
5% |
||||
|
Total |
100% |
We will take only MAJOR
jobsites and only TOP 8/10 cities, for the purpose of this tabulation.
If Month-after-month, Mumbai's
percentage share (market-share) is dropping (as shown hypothetically), it would
be a clear signal that there is a geographical shift in the Job-Market.
Such TRENDS would be of great interest to jobseekers/employers/state
Govts/politicians/Prof. Bodies (even to jobsites themselves!) etc.
\#5$ Job Advt. Break-Up (Cont)
We can also plot a tabulation
(like shown on preceding page) for FUNCTIONS
[Table structure titled "No.
of Advts. downloaded from Major Jobsites" showing data for job functions
across months Jan, Feb, and Mar.]
|
Function |
Jan |
Feb |
Mar |
|
Sales |
% |
% |
|
|
Mktg |
Once again, we may select only top
8/10 Functions (which make up for 80% of advts) - for plotting this table.
Once again, any shift in % market
share would send clear signal to jobseekers, which functional-areas are
in demand & which are not.
5^\#$ Job Advt. Break-Up.
So far, we have not found any
Satisfactory/reliable method of categorizing job-advts
Industry-wise
Designation-Level wise
Actual Designation wise
But, I am sure, someday, we will
find a solution.
"Actual
Designation-wise" may be the easiest since we are capturing this field.
Problem is, a very small
variation in writing makes it appear UNIQUE, an actual designation whereas, in
reality, some 10/15 different ways of writing/spelling, may all mean, one
$\&$ the Same! So, we need to first create "Synonyms-Rings"
(CISYS has this feature). Then all, such, similar designations will get clubbed
together and treated as ONE/SAME. (like proximity search ?).
\#5$ Job Advt. Break-Up.
This leaves us, creating such a
break-up "COMPANY-NAME-WISE".
This may be relatively easy to
create. We are capturing "Company Name" while processing.
Once again, we need to apply A-B-C
Analysis. 10% of the Companies may be contributing to 70% of
job-advts. Of course, after a while, even 10% of company-list may run
into 10,000 companies! Currently, top 10% advertiser company-list
may be, no longer than 100 companies. Then, it is somewhat manageable.
[Table structure showing
"No. of Jobs Advertised" across months Jan, Feb, and Mar
for companies like Wipro and Infosys.]
|
Company-name |
Jan |
Feb |
Mar |
Total Sofar |
|
Wipro |
2345 |
1683 |
4883 |
8968 / 200% |
|
Infosys. |
\#6$ MATCH INDEX
$$\text{MATCH INDEX} =
\frac{\text{No. of Alerts Delivered}}{\text{No. of Alerts Requested}}$$
MSP = (Airtel)
[Table structure comparing Airtel
specific data with Total World-Wide Jobs (WWJ) data for the Match Index
across months May 2005 and April 2005.]
|
Month |
Airtel |
Total World-Wide Jobs |
||
|
Alerts Deld. |
% |
Alerts Deld. |
% |
|
|
Alerts Reqd. |
Alerts Reqd. |
|||
|
May 2005 |
15268 / 18935 |
84% |
142,694 / 160,435 |
88% |
|
April 2005 |
78% |
84% |
$\leftarrow$ This data will
change as per User ID/Password
This data will be displayed for
all MSPs
What does this tell MSP
(Airtel, in this case)?
My share of job-alerts deld
$\left\{ \frac{15268}{142,694} = \text{\%}\right.$ in May 2005 (Market-share of
"Deld. Job Alerts").
Am I doing better/worse
- Month-after-month
- as compared to all MSPs put together?
\#7$ YIELD RATE
$$\text{YIELD RATE} =
\frac{\text{No. of Apply Online Clicks}}{\text{No. of Job Alerts Deld.}} \text{
\%}$$
MSP = Airtel
[Table structure comparing Airtel
specific data with WWJ (World-Wide Jobs) data for the Yield Rate across
months May 2005 and April 2005.]
|
Month |
Airtel |
WWJ |
||
|
Clicks/Deld. |
% |
Clicks/Deld. |
% |
|
|
May 2005 |
10263 / 15268 |
67% |
102,356 / 142,694 |
58% |
|
April 2005 |
58% |
65% |
What would this tell Airtel?
From April to May, our Yield rate
has improved ($\text{from } 58\% \rightarrow 67\%$)
This, despite the fact that, for
WWJ, as a whole, the yield rate has declined ($\text{from } 65\% \rightarrow
58\%$).
In May, our Yield rate is better
than the overall rate for WWJ ($67\%$ as compared to $58\%$).
An MSP, whose rate "is WORSENING,"
will sit up & initiate (publicity/promotional) steps to reverse the trend.
$\blacktriangleright$ #8 $\quad$ Database
of JAMMERS
Please show me, database of our
JAM subscribers
- City-wise
- Age Wise
- Job-Pref-Wise
- Desig. level Wise
- Edu. Quali. Wise
- Current Employer Wise
|
MSP = [box] |
Database of JAM Subscribers
CITY-WISE |
|
CITY |
% No. of Subscribers |
|
Top 8/10 cities? { Mumbai,
Delhi, Kolkata } |
80% |
|
Rest (MISC) |
20% |
|
Total |
100% |
Abhi Rajeev
April 12, 2005
ADMIN TOOL
Enclosed find some thoughts on
design of Admin Tool.
We must design it in such a
manner that
different "sections" of
the Admin Tool are made "accessible" to
different
"Agencies/Entities"
based on predefined "Viewing
Rights".
Hence Admin Tool, has to be MODULAR.
obviously, you need to prepare a
tabulation such as:
|
Viewers |
Who will have Viewing
Right? |
|
Module |
WWJ |
|
1 |
$\checkmark$ |
|
2 |
Variable
Free Trial (Period and/or No.
of job-alerts)
How does this "Vary"?
- Different MSPs would want to offer different "free
trial" offers to their subscribers, where either Period or No. of
job-alerts during that period or both may Vary.
- Then again, some may want
only MT SMS free
OR
only MO SMS free
OR
both "free"
- Our Software/Admin Tool must be capable of catering
to any/all permutation/combination of FREE TRIAL SCHEMES.
- And each scheme may be UNIQUE for each
jobseeker — in the sense that, new free-trial-"wallas" are
continuously joining & exiting, all the time!
City/State/Country
How does this "Vary"?
What is the impact?
- Co-ordinates of a location are: city/state/country
(3 dimensional cube) * And everything has a "location", whether
a jobseeker
a job-advt
a job-advertiser (employer)
a MSP
- We will always need to see/View these three along
following axis: [Hand-drawn diagram of a 2D plot]
Jobseeker
Job Advt
Job-Advertiser.
$\left.\right\}$ Since these are
never UNIFORMLY distributed along any of these axis!
[Location] axis [city/state/country]
[Time] axis
$\left.\right\}$ year, Month, Date (Period)
And people are always interested
in making "comparisons" between [A] One city & [B]
Another city [box] OR [A] One Month & [B] Another Month [box]
etc.
AND then DRAW
CONCLUSIONS/DEFINE PATTERNS/ PREDICT FUTURE TRENDS (Extrapolation?).
TIME PERIOD
How does this "Vary"?
What is the Impact?
- All data/record must carry a Time-stamp, so
that, when any database is being searched, it should be possible to search
it by "Time Period".
- Time period Search must start at
MACRO-LEVEL Year 2004,
2005, 2006 etc.
Then drill down $\left. \right\}$
further to Month - Jan, Feb etc.
Then further drill $\left.
\right\}$ down to Day - $1^{\text{st}}, 2^{\text{nd}}$ etc.
- For "MONTH" & for "YEAR",
we should have search feature (provision to compare
Year 2005 OR Year 2006
OR
JAN 2005 Vs. Jan 2006
to be able to see Month-to-Month
or Year-to-Year % (Percentage) growth.
WWJ ADMIN TOOL
Variable
Corporate Job Advertisers
(Employers)
How does this "Vary"?
What is the Impact?
- We will be delivering job-alerts (SMS) from
job-advts posted by job-advertisers (employers). These could also
be intermediaries such as Placement Agencies.
- For each job-advertiser (Indian or Foreign), we
want to compile (on a continuing basis), a "JOB ADVTS RELEASED
HISTORY".
- These HISTORIES will be "searchable" by
Time period
Advt - Function
Advt - Posting City
Advt - Designation (Vacancy -
Name)
Name of Advertiser
Advt - Industry (we have to
figure this out)
- Besides ourselves, we may permit/enable some other AGENCIES/PARTNERS
to search this "Job Advertisers Database as also "Job
Advertisements" Database. Some AGENCIES may be allowed to Search/Shortlist/Print
the results for FREE (eg: Newspapers/Cyber cafes/TV channels etc) -
IF that would get us FREE publicity.
- We may permit Corporates & Jobseekers to PULL
this info as SMS on their mobile and pay for the same to MSP - who
must give us a share.
WWJ ADMIN TOOL
Variable
Jobseeker
How does this "vary"?
What is the impact?
A jobseeker can be
a casual Visitor to WWJ (not
registered - but exploring various pages/features and we might want to
"capture his clicks to know, which page he is visiting and what is he
doing. His behaviour - and the pattern (of behaviour) of ALL such casual Visitors
will tell us a lot of interesting things.
a duly registered MEMBER
- this is our current focus and
we want to capture every click to create "history (pattern)" for that
individual.
an "Unsubscribed"
(past) member
- We want to retain his history
& keep in touch with him thru mass-emailing
a "Re-subscribed"
member
- We want to welcome him
"back" to the "community" & observe differences (if
any) in his CLICK-HISTORY in his earlier avatar and his current avatar!
WWJ ADMIN TOOL
|
Variable |
How does this
"Vary"? What is impact? |
|
Service Providers |
1) Mobile Service
Providers/Landline phone Cos. |
|
$\downarrow$ |
2) Any Portal (eg: Rediff/Yahoo
etc) |
|
All of these |
3) Newspapers/Magazines |
|
could be |
4) TV Channels (JAT-Job Alert
on TV) Interactive DTH/ |
|
Indian |
5) ISPs/Cybercafes |
|
Foreign. |
6) Broadband Providers
(Sify/VSNL/Reliance etc) |
|
7) Placement Agencies |
|
|
8) Jobsites |
|
|
9) Corporates (for CAM) etc.
etc. |
|
|
10) Cable Operators |
All of these are our "Distribution
Channels/Delivery Mechanism", thru whom, we want to distribute "content"
(Job-related or candidate related) to those who are interested in
such content.
As far as possible, we will try
to ensure/select those "Distributors/Dely. Channels," who have
already created/put-in-place, a robust mechanism for $\textcircled{1}$ charging
their subscribers for this content $\textcircled{2}$ collecting fee/charge for
the content.
Only if they collect, they can
share their revenue with us. But there will be instances, when we may give away
our content in return for non-monetary benefits (Trading bricks for Jade!).
WWJ ADMIN TOOL
Variable
Jobsites (from where we
download)
How does this "vary"?
What is the impact?
It may be an "Indian jobsite
or a "Foreign" jobsite. If "foreign", we need to capture
the "country" (where hosted).
We are going to offer a CHOICE to
each jobseeker to receive job-alerts for any given "country".
We may, someday, even offer a
choice to jobseekers to pick/select any particular jobsite(s) from which he
wants to receive job-alerts. Then this field will become part of the "Job
Preference" Form.
With different jobsites, we may
enter into different arrangements/agreements/alliances.
These could be for
* Daily sending us their job-advt
database (fresh) in XML format
* On their server, installing
Gurutime/GuruSearch/GuruAd etc (on royalty payment or even FREE).
* Paying them a small percentage
of revenue earned by us, everytime a jobseeker clicks "Apply online"
on a job-alert (Which came from that particular jobsite).
* Pooling their "Resume
Databases" with WWJ
* Agreeing to BROADCAST (to their
candidates), job/vacancies, posted on WWJ etc. etc.
Abhi
ADMIN TOOL
14-06-04
COUNTERS
You have already made a provision
for display of counters on WWJ. These could be on homepage (my preferred
location) or on some relevant "inner pages".
These could be on relevant inner
pages in addition to being on homepage. In such matters, duplication
only helps.
See enclosed list of counters.
Out of these,
We will certainly NOT want
anybody to see #6 & #7! Only we should be able to see them thru ADMIN TOOL.
#4 (No. of Apply Online
clicks)/#5 - Feedback Emails
If these fig[ures] become
substantial after a while, we may consider making this info "PUBLIC"
to all visitors.
Rest could be displayed
publicly from day ONE - and should be.
You are capturing all the
transactions anyway.
COUNTERS
| Item | Last 24 hours |
Cumulative so far |
| 1. No. of Registrations | | |
| 2. No. of Job Ads downloaded |
| |
| 3. No. of Job Alerts pushed | |
|
| 4. No. of
"Apply-Online" clicks | Same | |
| 5. No. of Feedback emails | | |
| 6. Revenue Earned (Rs.) | | |
| 7. No. of
"De-Activations" | | |
| 8. No. of Advts found
"matching" (for all members put together) | | |
14-06-04
ADMIN TOOL
ABHI
JAM/WWJ STATISTICS
Ultimately we will need to
develop hundreds of statistical tables and trend graphs/charts for JAM.
Some will be meant for our own
internal use only, whereas from the others, we will try to generate additional
revenue-streams!
Some tables/graphs we may give
away free to Jobseekers/Corporate Advertisers/mobile service providers (MSP),
to make them "stick" to our site/service (loyalty). There is no
doubt, someday JAM will get "copied" by competitors. At that time
"Brand Loyalty" will prevent JAM subscribers to ditch us and move out
to other (similar) service-providers.
Remember, to "retain"
an existing customer costs maybe 1%-5% of what it costs to "acquire"
a NEW customer!
I have already compiled a fairly
long list of statistics to be generated. But I STILL have to create actual
"Table/Graph" designs, so that there is no confusion over WHAT is
needed and in WHICH format. This will take some time.
28-05-04
But, in the meantime, there are
two statistical tabulations, which we will need to look at DAILY and right from
day ONE!
These will tell us (with complete
clarity),
A. Whether JAM is
picking-up/growing and at what "rate" (growth-rate)
B. Whether JAM is getting us any
money and how fast.
The (tentative) formats could be
as follows
A. JAM SERVICE REGISTRATIONS
|
Date |
[Box] [Dropdown] |
Service Provider |
No. of Registrations |
% |
|
Month |
[Box] [Dropdown] |
BPL |
||
|
Year |
[Box] [Dropdown] |
Airtel |
||
|
Tata |
||||
|
SUBMIT |
Aircell |
|||
|
Total |
100% |
Besides our own info, I would
also like to (selectively) email this data to one (or more) Service providers
to motivate them to put in more marketing effort to catch-up/overtake those
Service-providers who enjoy a much larger "market-share %" of JAM.
I WILL also use these statistics
to convince those service-providers, who
[Page 2/4]
have yet to make-up their mind,
whether to Sign-up for JAM or not. When they see that one or two
Service-providers are Signing-up thousands of mobile-owners, then, they too,
will get Convinced!
In fact, even a much more
powerful "incentive" would be a tabulation as follows:
JAM SERVICE "APPLY
ONLINE" CLICKS
|
Date |
[Box] [Dropdown] |
Service Provider |
No. of clicks |
% |
|
Month |
[Box] [Dropdown] |
|||
|
Year |
[Box] [Dropdown] |
|||
|
SUBMIT |
TOTAL |
100% |
we don't need to share/publicize
'Apply online' Tariff fixed by
each provider (Although, this would be public knowledge)
our % revenue-share from each
provider (even this cannot be kept a secret!)
But any smart Service provider,
can easily figure-out, what revenues are his competitors earning, by one look
at the above table! You don't need to be a genius!
Amongst the Service-providers
with a meagre percentage (%) of Total clicks, we have to create a
"Competitive feeling".
[Page 3/4]
B. Like any good
"BIRLA", we must have our own, Simple "padta"
system, which tells us, how much money we made at the end of each day! And for
this, we need a tabulation like below:
JAM REVENUE GENERATION
|
Date |
[Box] [Dropdown] |
Service Provider |
No. of Apply Clicks |
MSP's Revenue per click
(Rs) |
Total Revenue Earned |
|
Month |
[Box] [Dropdown] |
A |
B |
C = A x B |
|
|
Year |
[Box] [Dropdown] |
||||
|
SUBMIT |
Total |
$\Sigma$ A |
- |
$\Sigma$ C |
Ave. Revenue/click (Rs) =
$\frac{\Sigma \text{C}}{\Sigma \text{A}}$
Someday, for ease of
understanding the "trends", we will convert both of these tabulations
into a no. of graphs. In the meantime, these tabulations will be our
SCORE-BOARDS
and you cannot enthuse your
players to play well/better, unless you give them feedback (DAILY) about their
SCORE/RUN-RATE etc!
[Signature]
28/05/04
ADMIN TOOL
STATISTICS TO BE COMPILED
(Datamining of Databases of
Transactions carried-out on World-Wide-Jobs)
KEY DIMENSIONS (Data To Be
Captured)
1. Corporates
- Name
- Industry / Industries
- City / Country
- Job-Advts
- Function
- Actual Position Name
- Designation Level
- Job Descriptions
- Date of Advt
- Media / Source
- Advt. Ref. No.
2. Media / Sources (of
Job-Advt)
- Media Type (Job sites / Corpo websites / Print
Media / Direct Posting)
- Country (from where media gets broadcasted)
Election-Day
26-04-04
STATISTICS
3. Mobile Service Providers
(Delivery channel)
- Name / Brand
- Country
- Agreement Date / Period
- "Apply online" Tariff / our share %
4. Job-Advts
- covered under "Corporates"
5. Jobseekers
- PEN
- All fields of "Image Builder" resume duly
validated by the concerned jobseeker
- Last "Edit" date
6. Transactions
- a. No. of "Matching" job-advt for each
jobseeker (as per his job-preference criteria)
[Daily/Weekly/Monthly/Annually]
- b. No. forwarded to jobseeker as SMS
[Daily/Weekly/Monthly/Annually]
- c. No. clicked "Apply-Online"
[Daily/Weekly/Monthly/Annually]
- d. Ratio (Yield %) $\left(
\frac{\text{c}}{\text{b}} \right)$ [Daily/Weekly/Monthly/Annually]
7. TIME-PERIOD
- Date / month / year
statistics
Using the 7 DIMENSIONS shown on
p. 1 & 2 - and the data captured under each "field" of each
"dimension" -
we can compile an enormous amount
of statistical "TRENDS" (Analytics), to figure out
- How slow/fast is our business
growing?
- In which "Respect/aspect/region" is it
growing "slow" & Where "is it growing"
"fast"?
- How much REVENUE is JAM generating
- daily
- weekly
- monthly
- quarterly
- annually
- overall "total"
- from each Mobile Service Provider
- growth-rate (%) of Revenue (from PERIOD X to
Period Y).
Of the three items mentioned
above, the third (viz: REVENUE GENERATED) is the MOST IMPORTANT/VITAL.
Not only we must know (tabulation
& graphically)
How much money are we
"earning" every day (or for any "period")
But we must also know,
Which Mobile Service Provider is
giving us "MAX" revenue "MIN" revenue
[Page 3/]
We must monitor closely
Mobile Service Provider-WISE
revenue-generation "trends".
This is all-the-more important,
because, "Revenue-share percentages" & "Apply-online"
Tariff may differ from one mobile service provider to another mobile service
provider.
Some Mobile Service Providers may
have a vast no. of combinations of following factors:
|
Service Provider |
Tariff Rs/Apply online
click |
our share of Revenue |
No. of subscribers opted
for JAM |
Ave. YIELD % (c/b) |
|
$\downarrow$ |
||||
|
Hutch |
||||
|
BPL |
||||
|
Tata |
||||
|
Bharati |
So, it is quite possible, that
TWO mobile-service providers may give us SAME/IDENTICAL weekly/Monthly
"Revenue" but with totally different "combinations of FACTORS!
A simple A-B-C analysis of
revenues-received from different mobile-service-providers (by descending order
arrangement) will not do! we need to get "behind the numbers":
There is a reasonable chance that
we may get all the
mobile-service-providers to keep/maintain the same tariff (Rs. 1/- per
"Apply Online" click);
however,
It is very likely that depending
upon their
- Subscriber Base (their "bargaining
power")
- proposed marketing / promotional spending,
they will "dictate"
(-and we will accept), differing "Revenue-share percentage" from
different service-providers.
No comments:
Post a Comment