Rate Plans and Service Bundles Configuration
This dataset provides a comprehensive catalog of mobile service rate plans and bundles, detailing allowances for voice, data, SMS, international roaming, family plans, unlimited options, and promotional add-ons with associated pricing structures. It enables telecom operators, analysts, and consumers to compare offerings, analyze pricing strategies, and manage plan configurations efficiently.
Sample rows
preview · 8 of 100 rows · all 21 columns| plan_idstring | plan_typestring | family_plan_max_linesinteger | international_roaming_includedboolean | plan_namestring | base_monthly_pricefloat | voice_minutes_includedinteger | data_gb_includedfloat | sms_includedinteger | international_roaming_detailsstring | unlimited_voiceboolean | unlimited_databoolean | unlimited_smsboolean | promotional_addon_availableboolean | promotional_addon_detailsstring | pricing_tiersstring | activation_feefloat | contract_length_monthsinteger | is_activeboolean | effective_start_datedate | effective_end_datedate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RP1001 | individual | 0 | true | Unlimited Plus | 69.99 | -1 | -1 | -1 | Global Roaming 10GB, 100 min | true | true | true | true | Free streaming for 6 months | Standard; Data overage $10/GB | 25 | 24 | true | 2024-04-01 | blank |
| RP1002 | family | 4 | false | Family Connect 4 | 119.99 | 2000 | 40 | 2000 | blank | false | false | false | true | Bonus 5GB for first 3 months | Add line $25/month | 40 | 12 | true | 2023-07-01 | blank |
| RP1003 | business | 0 | true | Business Essential | 59 | 3000 | 30 | 3000 | Europe roaming 2GB, 200 min | false | false | false | false | blank | 5+ lines: $5 off/line | 50 | 24 | true | 2024-01-15 | blank |
| RP1004 | add-on | 0 | false | Starter Add-On Data | 15 | 0 | 5 | 0 | blank | false | false | false | true | Double data for 2 months | Data only | 0 | 0 | true | 2024-05-01 | blank |
| RP1005 | promotional | 0 | false | Promo Spring Unlimited | 49.99 | -1 | -1 | -1 | blank | true | true | true | true | Spring promo: free activation | Limited time pricing | 0 | 6 | false | 2024-03-15 | 2024-06-30 |
| RP1006 | family | 6 | true | Family Max 6 | 189.99 | -1 | 100 | -1 | Roaming Asia 5GB | true | false | true | false | blank | Add line $20/month | 35 | 24 | true | 2023-11-01 | blank |
| RP1007 | individual | 0 | false | Individual Basic | 29.95 | 500 | 3 | 500 | blank | false | false | false | true | First month free | Standard | 20 | 0 | true | 2024-04-10 | blank |
| RP1008 | business | 0 | true | Business Pro | 85 | -1 | 60 | -1 | Global roaming unlimited SMS | true | false | true | false | blank | 10+ lines: $10 off/line | 75 | 36 | true | 2022-09-01 | blank |
| RP1009 | promotional | 0 | false | Promo Data Boost | 39.99 | 1000 | 20 | 1000 | blank | false | false | false | true | Extra 5GB for 6 months | Promo tier | 0 | 6 | false | 2023-05-01 | 2023-12-01 |
| RP1010 | family | 3 | false | Family Value 3 | 89.99 | 1200 | 15 | 1200 | blank | false | false | false | true | Free SIM for each line | Add line $30/month | 30 | 12 | true | 2024-03-20 | blank |
| RP1011 | add-on | 0 | false | Add-On Unlimited SMS | 7.5 | 0 | 0 | -1 | blank | false | false | true | true | Discounted for first 2 months | SMS only; no voice/data | 0 | 0 | true | 2024-05-05 | blank |
| RP1012 | individual | 0 | false | Individual Lite | 19.99 | 250 | 1 | 250 | blank | false | false | false | false | blank | Standard | 10 | 0 | true | 2024-03-01 | blank |
| RP1013 | business | 0 | true | Business Unlimited | 99 | -1 | -1 | -1 | Global unlimited | true | true | true | false | blank | 20+ lines: $20 off/line | 100 | 36 | true | 2022-01-01 | blank |
| RP1014 | promotional | 5 | true | Promo Family Unlimited | 149.99 | -1 | -1 | -1 | Promo: Unlimited NA/EU | true | true | true | true | Free Netflix for 12 months | Add line $10/month | 0 | 12 | false | 2023-01-01 | 2023-12-31 |
| RP1015 | family | 2 | false | Family Flex 2 | 59.99 | 700 | 6 | 700 | blank | false | false | false | false | blank | Add line $35/month | 15 | 0 | true | 2024-06-01 | blank |
| RP1016 | business | 0 | true | Business Roamer | 110 | 5000 | 100 | 5000 | Roaming: Americas 10GB, 500 min | false | false | false | true | Free conference calls for 1 year | Bulk discount $15/line | 75 | 36 | true | 2022-03-01 | blank |
| RP1017 | add-on | 0 | false | Add-On 10GB | 25 | 0 | 10 | 0 | blank | false | false | false | false | blank | Data only | 0 | 0 | true | 2024-04-20 | blank |
| RP1018 | individual | 0 | true | Individual Unlimited | 59.99 | -1 | -1 | -1 | Global unlimited | true | true | true | false | blank | Standard | 25 | 24 | true | 2024-05-10 | blank |
| RP1019 | promotional | 0 | false | Promo Individual Flex | 34.99 | 1000 | 12 | 1000 | blank | false | false | false | true | Free activation; extra 3GB/month | Promo pricing | 0 | 3 | false | 2024-02-01 | 2024-05-01 |
| RP1020 | family | 5 | true | Family Gold 5 | 169.99 | -1 | -1 | 3000 | Roaming: Europe unlimited voice | true | true | false | false | blank | Add line $15/month | 45 | 24 | true | 2023-07-01 | blank |
What the 100 rows show
from the 100-row sampleFamily (plan type) stands out: mean family_
- 46%international_
roaming_ included = true - 0median family_
plan_ max_ lines - 55.0median base_
monthly_ price - 500median voice_
minutes_ included - 5median data_
gb_ included - 500median sms_
included
Median 0, from 0 to 10.
- string 6
- integer 4
- float 3
- date 2
- boolean 6
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
plan_id | string | Unique identifier for the rate plan or bundleunique | RP1001 |
plan_name | string | Descriptive name of the rate plan or bundle | Unlimited Plus |
plan_type | string | Type of plan (e.g., individual, family, business, add-on, promotional)individual · family · business · add-on · promotional | individual |
international_roaming_details | string | Description of international roaming package (if any)optional | Roaming Asia 5GB |
promotional_addon_details | string | Description of any promotional add-ons (if applicable)optional | Double data for 2 months |
pricing_tiers | string | Details of pricing tiers (e.g., discounts for additional lines, data overage rates, etc.)optional | Add line $25/month |
| Numbers 7 columns | |||
base_monthly_price | float | Standard monthly price for the plan (in local currency)0 or more | 69.99 |
voice_minutes_included | integer | Number of domestic voice minutes included per billing cycle (use -1 for unlimited)-1 or more | -1 |
data_gb_included | float | Amount of domestic data included per billing cycle in GB (use -1 for unlimited)-1 or more | -1 |
sms_included | integer | Number of SMS messages included per billing cycle (use -1 for unlimited)-1 or more | -1 |
family_plan_max_lines | integer | Maximum number of lines allowed for family plans (null or 0 if not applicable)0 or more · optional | 0 |
activation_fee | float | One-time activation fee for the plan (if any, 0 if none)0 or more · optional | 25 |
contract_length_months | integer | Length of contract in months (0 for no contract)0 or more | 24 |
| Dates and times 2 columns | |||
effective_start_date | date | Date when the plan becomes available | 2024-04-01 |
effective_end_date | date | Date when the plan is no longer available (null if still active)optional | 2024-06-30 |
| True or false 6 columns | |||
international_roaming_included | boolean | Indicates if international roaming is included in the plan | true |
unlimited_voice | boolean | Indicates if the plan offers unlimited domestic voice minutes | true |
unlimited_data | boolean | Indicates if the plan offers unlimited domestic data | true |
unlimited_sms | boolean | Indicates if the plan offers unlimited SMS | true |
promotional_addon_available | boolean | Indicates if promotional add-ons are available for this plan | true |
is_active | boolean | Indicates if the plan is currently available for new customers | true |
Use it for
A telecommunications dashboard
The international_
roaming_ included rate and family_ plan_ max_ lines by plan_ type. Excel, Power BI or Tableau. Why do the 23 family rows have a mean family_
plan_ max_ lines of 5.3? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Plans100RP10010individu…RP10024familyRP10030business
A software demo
Believable plans with plan_
name, plan_ type and base_ monthly_ price to fill a screen in front of a buyer.
This dataset100 rows21 columns
Yours1,000 rows21 columns
blueprint · rate-plans-and-service-bundles-configuration
Behind this dataset
Same schema. As many rows as you need.
These 100 rows came out of a blueprint — 21 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Rate plan ID and commercial name (e.g., Unlimited Plus, Family Share)
- Monthly recurring charge (MRC) in currency
- Voice allowance: minutes (local, national, mobile-to-mobile)
- Data allowance: GB per month with overage charges or throttling
- SMS/MMS allowance: message count or unlimited
- International roaming zones and daily/weekly roaming passes
- Family plan: shared data pool, multiple lines discount
- 5G access included vs. 4G-only plans
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- rate-plans-and-service-bundles-configuration