Service Activation and Provisioning Lead Times
This dataset provides detailed metrics on service order fulfillment, tracking every step from order placement to activation, including bottlenecks such as site surveys, permits, and installation. It enables analysis of lead times, on-time delivery rates, expedited orders, and identifies opportunities for process automation, making it ideal for improving operational efficiency in service delivery organizations.
Sample rows
preview · 8 of 700 rows · all 24 columns| order_idstring | bottleneck_stepstring | order_to_activation_time_daysfloat | on_time_deliveryboolean | customer_idstring | order_datedatetime | activation_datedatetime | provisioning_steps_completedinteger | provisioning_steps_totalinteger | site_survey_requiredboolean | site_survey_completedboolean | site_survey_completion_datedate | permit_requiredboolean | permit_obtainedboolean | permit_obtained_datedate | installation_requiredboolean | installation_completedboolean | installation_completion_datedate | bottleneck_duration_daysfloat | promised_delivery_datedate | expedited_orderboolean | automation_opportunity_flagboolean | automation_opportunity_descriptionstring | order_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD10001 | none | 0.29 | true | CUST201 | 2024-03-01T10:12:00Z | 2024-03-01T17:15:00Z | 2 | 2 | false | blank | blank | false | blank | blank | false | blank | blank | 0 | 2024-03-02 | true | true | Automate order verification to reduce manual entry delays. | Quick fulfillment, no physical steps needed. Customer requested urgent provisioning. |
| ORD10002 | none | 0.1 | true | CUST384 | 2024-03-02T14:23:00Z | 2024-03-02T16:48:00Z | 1 | 1 | false | blank | blank | false | blank | blank | false | blank | blank | 0 | 2024-03-03 | true | false | blank | Order processed instantly via automated workflow. |
| ORD10003 | none | 0.99 | true | CUST135 | 2024-03-03T09:32:00Z | 2024-03-04T09:00:00Z | 3 | 3 | false | blank | blank | false | blank | blank | true | true | 2024-03-03 | 0 | 2024-03-05 | true | false | blank | Fast-tracked install, technician available same day. |
| ORD10004 | site_survey | blank | false | CUST412 | 2024-03-04T12:19:00Z | blank | 0 | 8 | true | false | blank | true | false | blank | true | false | blank | 14 | 2024-03-15 | false | true | Digitize survey scheduling to reduce bottlenecks. | Order stuck awaiting site survey scheduling. Customer notified of delay. |
| ORD10005 | permit | 29.81 | false | CUST238 | 2024-03-05T15:26:00Z | 2024-04-04T10:00:00Z | 12 | 12 | true | true | 2024-03-07 | true | true | 2024-03-18 | true | true | 2024-04-02 | 11 | 2024-03-28 | false | false | blank | Permit delays due to municipal approval backlog. |
| ORD10006 | none | 3.11 | true | CUST311 | 2024-03-06T08:44:00Z | 2024-03-09T11:23:00Z | 4 | 4 | false | blank | blank | false | blank | blank | true | true | 2024-03-08 | 0 | 2024-03-10 | true | true | Automate technician dispatch for installations. | Expedited install scheduled for next business day. |
| ORD10007 | site_survey | blank | false | CUST127 | 2024-03-07T13:37:00Z | blank | 0 | 10 | true | false | blank | false | blank | blank | true | false | blank | 21 | 2024-03-20 | false | false | blank | Order awaiting site survey completion before proceeding. |
| ORD10008 | none | 9.96 | true | CUST467 | 2024-03-08T11:15:00Z | 2024-03-18T09:36:00Z | 7 | 7 | true | true | 2024-03-09 | false | blank | blank | true | true | 2024-03-16 | 0 | 2024-03-20 | false | false | blank | Standard installation completed as scheduled. |
| ORD10009 | permit | 32.91 | false | CUST222 | 2024-03-09T16:04:00Z | 2024-04-10T14:00:00Z | 11 | 12 | true | true | 2024-03-12 | true | false | blank | true | false | blank | 17 | 2024-04-05 | false | false | blank | Permit application in progress, activation delayed. |
| ORD10010 | none | 6.27 | true | CUST387 | 2024-03-10T10:22:00Z | 2024-03-16T16:45:00Z | 6 | 6 | false | blank | blank | true | true | 2024-03-12 | true | true | 2024-03-15 | 0 | 2024-03-17 | false | true | Automate permit status tracking for reduced manual follow-up. | Routine order, permit obtained quickly. |
| ORD10011 | permit | 29.9 | false | CUST319 | 2024-03-11T13:55:00Z | 2024-04-09T11:20:00Z | 13 | 13 | true | true | 2024-03-14 | true | true | 2024-03-30 | true | true | 2024-04-07 | 13 | 2024-04-05 | false | false | blank | Permit process delayed by local authority. |
| ORD10012 | none | 0.34 | true | CUST158 | 2024-03-12T11:06:00Z | 2024-03-12T19:26:00Z | 1 | 1 | false | blank | blank | false | blank | blank | false | blank | blank | 0 | 2024-03-13 | true | true | Integrate CRM for automatic order entry. | No physical provisioning steps required. Order closed same day. |
| ORD10013 | none | 0.81 | true | CUST294 | 2024-03-13T15:09:00Z | 2024-03-14T10:30:00Z | 2 | 2 | false | blank | blank | false | blank | blank | true | true | 2024-03-13 | 0 | 2024-03-15 | true | false | blank | Install completed within 24 hours. Customer pleased with turnaround. |
| ORD10014 | none | 4.27 | true | CUST328 | 2024-03-14T09:55:00Z | 2024-03-18T16:17:00Z | 5 | 5 | true | true | 2024-03-15 | false | blank | blank | true | true | 2024-03-17 | 0 | 2024-03-20 | false | true | AI scheduling for survey and install appointments. | Coordination with survey and installation teams ensured timely completion. |
| ORD10015 | none | 16.06 | true | CUST275 | 2024-03-15T14:25:00Z | 2024-03-31T15:55:00Z | 8 | 8 | true | true | 2024-03-17 | false | blank | blank | true | true | 2024-03-30 | 0 | 2024-04-01 | false | false | blank | Routine install, no delays in survey or installation. |
| ORD10016 | installation | 31.87 | false | CUST144 | 2024-03-16T13:08:00Z | 2024-04-17T10:00:00Z | 14 | 15 | true | true | 2024-03-18 | true | true | 2024-03-30 | true | false | blank | 18 | 2024-04-10 | false | false | blank | Delayed installation due to technician shortage. |
| ORD10017 | none | 1.65 | true | CUST342 | 2024-03-17T18:30:00Z | 2024-03-19T10:00:00Z | 3 | 3 | false | blank | blank | false | blank | blank | true | true | 2024-03-18 | 0 | 2024-03-20 | true | false | blank | Fast install, no survey/permit required for expedited setup. |
| ORD10018 | permit | blank | false | CUST251 | 2024-03-18T11:44:00Z | blank | 0 | 6 | false | blank | blank | true | false | blank | false | blank | blank | 41 | 2024-03-25 | false | true | Automate permit form submission and reminders. | No survey or install, but permit process stalled order. |
| ORD10019 | none | 0.29 | true | CUST190 | 2024-03-19T09:27:00Z | 2024-03-19T16:19:00Z | 2 | 2 | false | blank | blank | false | blank | blank | false | blank | blank | 0 | 2024-03-20 | true | false | blank | Instant activation for existing customer. No provisioning needed. |
| ORD10020 | none | 8.82 | true | CUST344 | 2024-03-20T13:39:00Z | 2024-03-29T09:15:00Z | 5 | 5 | false | blank | blank | true | true | 2024-03-22 | true | true | 2024-03-28 | 0 | 2024-03-30 | false | false | blank | Standard provisioning, permit obtained quickly. |
What the 700 rows show
from the 700-row sampleNone (bottleneck step) stands out: 482 of its 499 rows have on_
- 69%on_
time_ delivery = true - 3.8median order_
to_ activation_ time_ days - 3median provisioning_
steps_ completed - 5median provisioning_
steps_ total - 0.0median bottleneck_
duration_ days
None (bottleneck step)'s mean order_
Median 3.8, from 0.01 to 66.8.
- string 5
- integer 2
- float 2
- date 4
- datetime 2
- boolean 9
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 5 columns | |||
order_id | string | Unique identifier for the service orderunique | ORD10001 |
customer_id | string | Unique identifier for the customer placing the order | CUST201 |
bottleneck_step | string | Name of the provisioning step that caused the most significant delay (e.g., site survey, permit, installation)site_survey · permit · installation · none · optional | none |
automation_opportunity_description | string | Description of the automation opportunity identified for this orderoptional | Automate order verificati… |
order_notes | string | Additional notes or comments about the order fulfillment processoptional | Quick fulfillment, no phy… |
| Numbers 4 columns | |||
order_to_activation_time_days | float | Total number of days from order placement to service activation0 or more · optional | 0.29 |
provisioning_steps_completed | integer | Number of provisioning steps completed for the order0 or more · optional | 2 |
provisioning_steps_total | integer | Total number of provisioning steps required for the order1 or more · optional | 2 |
bottleneck_duration_days | float | Number of days the bottleneck step delayed the order0 or more · optional | 0 |
| Dates and times 6 columns | |||
order_date | datetime | Timestamp when the service order was placed | 2024-03-01T10:12:00Z |
activation_date | datetime | Timestamp when the service was activated for the customeroptional | 2024-03-01T17:15:00Z |
site_survey_completion_date | date | Date when the site survey was completedoptional | 2024-03-07 |
permit_obtained_date | date | Date when permits were obtainedoptional | 2024-03-18 |
installation_completion_date | date | Date when installation was completedoptional | 2024-03-03 |
promised_delivery_date | date | Date promised to the customer for service activation | 2024-03-02 |
| True or false 9 columns | |||
site_survey_required | boolean | Indicates if a site survey was required for this order | false |
site_survey_completed | boolean | Indicates if the site survey was completedoptional | false |
permit_required | boolean | Indicates if permits were required for this order | false |
permit_obtained | boolean | Indicates if the required permits were obtainedoptional | false |
installation_required | boolean | Indicates if installation was required for this order | false |
installation_completed | boolean | Indicates if installation was completedoptional | true |
on_time_delivery | boolean | Indicates if the order was delivered and activated on or before the promised date | true |
expedited_order | boolean | Indicates if the order was expedited | true |
automation_opportunity_flag | boolean | Indicates if there is an opportunity to automate part of the process for this orderoptional | true |
Use it for
A telecommunications dashboard
The on_
time_ delivery rate and order_ to_ activation_ time_ days by bottleneck_ step. Excel, Power BI or Tableau. Why do 486 of 700 rows have on_
time_ delivery = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Orders700ORD100010.29noneORD100020.1noneORD10004site_sur…
A software demo
Believable orders with customer_
id, order_ date and activation_ date to fill a screen in front of a buyer.
This dataset700 rows24 columns
Yours1,000 rows24 columnssite_survey_required: UK only
blueprint · service-activation-and-provisioning-lead-times
Behind this dataset
Same schema. As many rows as you need.
These 700 rows came out of a blueprint — 24 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
- Service order ID and customer account
- Service type: mobile activation, broadband installation, enterprise circuit, IoT connectivity
- Order timestamp and requested activation date
- Provisioning steps: order validation, credit check, inventory allocation, scheduling, installation, testing, activation
- Actual activation timestamp
- Lead time: days from order to activation
- On-time delivery: met requested date (yes/no)
- Delay reasons: site survey required, permit delays, equipment shortage, installation rescheduled
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
- service-activation-and-provisioning-lead-times