Rate Table - Add Rates

For a Rate Table to be effective it must contain at least one Rate Pattern or destination number. CDR2Cloud recognizes a complete destination telephone number or any number of digits starting from the beginning of the number, called a Pattern. 


EXAMPLE

For example, lets say you wanted to establish different charges for calls to Toronto which start with the area code 416. You would like to charge

  • 20¢ @ minute for calls destined to  numbers starting with 416368 which is for "Toronto Location A" 
  • 30¢ @ minute for "Toronto Location B" with telephone numbers starting with 416987 
  • 10¢  @ minute for calls to all other Toronto destinations. 

To achieve this you would create a Rate Table with 3 separate patterns like below: 

PatternDescriptionRate
416Toronto All$0.10
416368Toronto Location A$0.20
416987Toronto Location B$0.30 


CDR2Cloud would match calls against this Rate Table as follows: 
 If the destination telephone number is 4163681234, CDR2Cloud would try to match all digits of that telephone number starting from the right (last digit) and moving towards the left. The search process can be simulated as follows: 
 
CDR2Cloud would search for 4163681234.....no match would be found in the Rate Table 
CDR2Cloud would search for 416368123.....no match would be found in the Rate Table 
CDR2Cloud would search for 41636812.....no match would be found in the Rate Table 
CDR2Cloud would search for 4163681.....no match would be found in the Rate Table 
CDR2Cloud would search for 416368.....match would be found in the Rate Table 

 The closest pattern that matches the destination number is 416268 and so the CDR2Cloud would charge the call at a rate of 20¢ @ minute.  
 Likewise if CDR2Cloud received a call with a destination telephone number of 4167851234, CDR2Cloud would try to match all digits of that telephone number in the following manner: 
 
CDR2Cloud would search for 4167851234.....no match would be found in the Rate Table 
CDR2Cloud would search for 416785123.....no match would be found in the Rate Table 
CDR2Cloud would search for 41678512.....no match would be found in the Rate Table 
CDR2Cloud would search for 4167851.....no match would be found in the Rate Table 
CDR2Cloud would search for 416785.....no match would be found in the Rate Table 
CDR2Cloud would search for 41678.....no match would be found in the Rate Table 
CDR2Cloud would search for 4167.....no match would be found in the Rate Table 
CDR2Cloud would search for 416.....match would be found in the Rate Table 


To add a Rate Pattern to a Rate Table please follow the steps below:

  1. Open the Rate Table that you would like to add Rates to by clicking the  button
    CDR2Cloud - Rate Table Add Rate Pattern
  2. Click the [Add Rate] button located at the top of the page
    CDR2Cloud - Add Rate Menu
  3. Enter the information for the new Rate Pattern as follows:

    CDR2Cloud - Define Rate Pattern
    Number PatternThe destination number or pattern (NPA NXX) that represents calls to that pattern
    Rate NameThe name of the Rate Table
    Billing Period Initial Length[default 0 seconds] This is a numeric value which represents the number of seconds for the minimum billing length for each call made to this rate pattern. E.g: If a call lasted 10 seconds and the value defined here is 60 then that call would be billed for a duration 60 seconds and not 10 seconds. 
    Billing Period Incremental Length[default 60 seconds] This is a numeric value which represents the number of seconds which represent the billing increments (billing chunks) which will be used for calculating the cost for this call. E.g: If destination rate pattern is defined with a rate of $0.30 @ minute and a Billing Initial Length value of 60 seconds then an authorized call lasting 1 minute and 20 seconds (80 seconds) would be rounded up to the next 60 seconds and charged at total duration of 2 minutes (120 seconds) at $0.60, however with a Billing Initial Length value of 30 seconds that same call would be rounded up to the next 30 second increment and billed at 130 second at $0.45. For Per-Second-Billing set this value to 1. For Per-Minute-Billing set this value to 60.
    Day-time Start[default 7:00 AM] This is a time value which represents the start of day time billing hours. All calls made between Day Start and Eve Start hours will be treated as a day time call and billed at the rate defined in Day-time Increment Charge. 
    [default $0.0000 (0¢)] This is a numeric (money) value which represents the amount of money that will be charged initially for a call made to this destination during the day time hours. This is a one time initial charge and is separate from the incremental amount charged.
    Day-time incremental Charge[default $0.0100 (1¢)] This is a numeric (money) value which represents the amount of money that will be charged at the Billing Incremental Length intervals for a call authorized for this destination during the day time hours. This value must be entered as a per minute value.
    Eve-time Start[default 1:00 PM] This is a time value which represents the start of evening time billing hours. All calls made between Eve Start and Night Start hours will be treated as an evening hour call and billed at the rate defined in Eve-time Increment Charge. 
    Eve-time Initial Charge[default $0.0000 (0¢)] This is a numeric (money) value which represents the amount of money that will be charged initially for a call made to this destination during the eve time hours. This is a one time initial charge and is separate from the incremental amount charged.
    Eve-time incremental Charge[default $0.0100 (1¢)] This is a numeric (money) value which represents the amount of money that will be charged at the Billing Incremental Length intervals for a call authorized for this destination during the eve time hours. This value must be entered as a per minute value.
    Night-time Start[default 1:00 PM] This is a time value which represents the start of evening time billing hours. All calls made between Night-time Start and Day-time Start hours will be treated as an evening hour call and billed at the rate defined in Eve-time Increment Charge. 
    Night-time Initial Charge[default $0.0000 (0¢)] This is a numeric (money) value which represents the amount of money that will be charged initially for a call made to this destination during the night time hours. This is a one time initial charge and is separate from the incremental amount charged.
    Night-time Incremental Charge[default $0.0100 (1¢)] This is a numeric (money) value which represents the amount of money that will be charged at the Billing Incremental Length intervals for a call authorized for this destination during the night time hours. This value must be entered as a per minute value.
    Weekend-time Initial Charge[default $0.0000 (0¢)] This is a numeric (money) value which represents the amount of money that will be charged initially for a call made to this destination during the weekend (Saturday and Sunday). This is a one time initial charge and is separate from the incremental amount charged.
    Weekend-time Incremental Charge[default $0.0100 (1¢)] This is a numeric (money) value which represents the amount of money that will be charged at the Billing Incremental Length intervals for a call authorized for this destination during the weekend (Saturday and Sunday). This value must be entered as a per minute value.
    BlockedWhether not this Rate Pattern is Enabled or Disabled
    Connection Charge[default $0] This represents the amount of money that will be charged every time a call is made to the destination telephone number called. 
    Compensation[default 0 seconds] This is a numeric value which represents the number of seconds that will be subtracted from the total duration of a call. This in effect is way of compensating the caller in situations where you are aware that it may take a few seconds to get connected to a particular destination number while billing has started. E.g, if the total duration for a call is 60 seconds and the Compensation value is 10 seconds then that caller would only be billed for (60 - 10) 50 seconds.    
    Maximum Charge

    This is the maximum amount of money that a call to this Destination Pattern should be charge. The maximum charge overrides the total calculated for the call charge in the event that the calculated amount is higher that the maximum set.

    EXAMPLE

    You have set the maximum = $2.00 for a destination pattern which charges $0.50 (50 cents) per minute. If a customer makes a 60 minute call to this destination then the regular charge would be $30, i.e. (60 mins x $0.50). This means that the customer would have been charged $30, however the customer will only be charged $2.00 because the maximum = $2.00 Usage: This feature is great for telephony providers that want to offer promotions to specific destinations. The example above could be called "All you can Talk for $2.00" Promotion. This allows the system to maintain a maximum charge for the destination you are having the promotion for.

    Markup %

    [default -1.0000] This represents the percentage % that you would like to markup the CDR supplied charges for calls. For example, if your CDR files comes from a Termination Provider (like Vitelity or VoipInnovations) then the Carrier charge for the call will be supplied. This is the amount of money the Carrier charged you for the call. You can simply markup that Carrier charge by a simple % and charge that amount to your customer eliminating the need to re-rate the call. When set to -1 (default value) the Day, Eve and Night time incremental rates are used and Markup% is ignored. When the Markup% is set to a value other -1 then the Markup value is used and the Day, Eve and Night time values are ignored.

    EXAMPLE

    You have received your CDR files from your online Carrier and the file contains the cost for each call (the charge you pay to your Carrier for each call). You have decided not to re-rate these calls but simply markup them up by 30% and re-bill your customers. So in this case your Carrier charges you $0.50 ($0.25 x 2 mins) for a 2 minute call to Alaska. You in turn would like to charge your customer a 30% markup for calls to Alaska. For a 2 minute call you will charge your customer $0.65 (original-carrier-charge + (30% x original-carrier-charge)). To achieve this you would set the Markup%=0.30 as shown in the image below:

  4. Click the [Create] button to save the Rate Pattern
    CDR2Cloud - Rates


RATES & RATE TABLE TOPICS