Penyerapan data dan skema data

Halaman ini menjelaskan jenis penyerapan data dan skema data yang tersedia untuk Insight Pelanggan Telekomunikasi.

Insight Pelanggan Telekomunikasi menawarkan dua jenis penyerapan data dan beberapa skema data. Anda menyajikan set data yang sesuai dengan skema data, lalu Telecom Subscriber Insights menggunakan data yang Anda berikan untuk membuat penawaran bagi pelanggan Anda.

Jenis penyerapan data

Telecom Subscriber Insights menawarkan jenis penyerapan data berikut:

• Data penggunaan dan ringkasan akun. Telecom Subscriber Insights memerlukan pembaruan rutin pada data penggunaan dan data ringkasan akun. Data penggunaan dan ringkasan akun dapat di-ingest secara real time, hampir real time, atau secara berkala. Data real-time atau data yang hampir real-time dipublikasikan ke topik Pub/Sub yang dikonfigurasi selama langkah penyiapan awal. Data ringkasan penggunaan dan akun juga dapat dikirim secara berkala, biasanya sekali sehari, dan hal ini dilakukan dengan menulis data ke bucket Cloud Storage yang dikonfigurasi selama penyiapan awal.

• Status paket data. Insight Pelanggan Telekomunikasi juga memerlukan informasi tentang status paket data saat ini setiap pelanggan. Data ini dibagikan ke Telecom Subscriber Insights menggunakan Google Mobile Data Plan Sharing API.

Tabel data

Bagian berikut menjelaskan tabel dan skema Insight Pelanggan Telekomunikasi yang dapat Anda gunakan untuk mengirimkan data ke Insight Pelanggan Telekomunikasi. Sebelum mengirimkan data, pastikan set data Anda sesuai dengan skema yang dijelaskan di bagian berikut.

Set data yang tersedia

Tabel berikut menjelaskan tabel set data yang tersedia dalam Telecom Subscriber Insights.

Nama set data dan link skema	Definisi
Catatan penggunaan	Snapshot catatan penggunaan pelanggan dan histori saldo paket tertentu.
Ringkasan akun	Ringkasan akun pelanggan dan paket yang telah dibeli.
Peristiwa CPID	Peristiwa yang dicatat per ID paket operator (CPID) jika Anda memiliki server CPID yang dikonfigurasi.

Definisi skema set data

Bagian berikut menjelaskan definisi skema untuk setiap tabel yang tersedia untuk Insight Pelanggan Telekomunikasi.

Catatan penggunaan

[
  {
    "name": "sub_id",
    "type": "STRING",
    "mode": "REQUIRED",
    "description": "Subscriber identification. A privacy preserving subscriber identity for the subscriber."
  },
  {
    "name": "usage",
    "type": "RECORD",
    "mode": "REPEATED",
    "description": "It represents the current usage of the subscriber for a given plan.",
    "fields": [
      {
        "name": "plan_id",
        "type": "STRING",
        "mode": "REQUIRED",
        "description": "Unique plan identifier."
      },
      {
        "name": "current_usage",
        "type": "FLOAT",
        "mode": "NULLABLE",
        "description": "Describes the current usage of the plan. The unit is specified in usage_unit."
      },
      {
        "name": "usage_pct",
        "type": "FLOAT",
        "mode": "NULLABLE",
        "description": "Describes the percentage used of the allotment. Range: [0, 100]"
      },
      {
        "name": "allotted_usage",
        "type": "FLOAT",
        "mode": "NULLABLE",
        "description": "Describes the allotted usage of the plan. The unit is specified in usage_unit."
      },
      {
        "name": "start_date",
        "type": "TIMESTAMP",
        "mode": "NULLABLE",
        "description": "Plan start date."
      },
      {
        "name": "end_date",
        "type": "TIMESTAMP",
        "mode": "NULLABLE",
        "description": "Plan end date."
      },
      {
        "name": "usage_unit",
        "type": "STRING",
        "mode": "NULLABLE",
        "description": "Describes the unit of measure: messages, minutes, bytes."
      }
    ]
  },
  {
    "name": "qoe_metrics",
    "type": "RECORD",
    "mode": "NULLABLE",
    "description": "Describes the quality of experience of the subscriber.",
    "fields": [
      {
        "name": "uptime",
        "type": "INTEGER",
        "mode": "NULLABLE",
        "description": "How long the user has been connected to the network without interruption in seconds."
      },
      {
        "name": "network_score",
        "type": "FLOAT",
        "mode": "NULLABLE",
        "description": "The quality of the network network_score out of 100."
      }
    ]
  },
  {
    "name": "update_time",
    "type": "TIMESTAMP",
    "mode": "REQUIRED",
    "description": "Timestamp when this record was updated."
  }
]

---

Ringkasan akun

[
  {
    "name": "sub_id",
    "type": "STRING",
    "mode": "REQUIRED",
    "description": "Subscriber identification. A privacy preserving subscriber identity for the subscriber."
  },
  {
    "name": "purchased_plans",
    "type": "RECORD",
    "mode": "REPEATED",
    "description": "List of all the purchased plans for the subscriber.",
    "fields": [
      {
        "name": "plan_name",
        "type": "STRING",
        "mode": "NULLABLE",
        "description": "Plan name"
      },
      {
        "name": "plan_id",
        "type": "STRING",
        "mode": "REQUIRED",
        "description": "Unique identifier for the plan"
      },
      {
        "name": "plan_description",
        "type": "STRING",
        "mode": "NULLABLE"
      },
      {
        "name": "promo_message",
        "type": "STRING",
        "mode": "NULLABLE",
        "description": "Additional promotional message for the user."
      },
      {
        "name": "language_code",
        "type": "STRING",
        "mode": "NULLABLE",
        "description": "The BCP-47 language code, such as en-US or sr-Latn."
      },
      {
        "name": "max_rate_kbps",
        "type": "INTEGER",
        "mode": "NULLABLE",
        "description": "The maximum bandwidth that the plan offers to the user."
      },
      {
        "name": "cost",
        "type": "RECORD",
        "mode": "NULLABLE",
        "description": "Cost of the purchased plans.",
        "fields": [
          {
            "name": "currency_code",
            "type": "STRING",
            "mode": "NULLABLE",
            "description": "The three-letter currency code defined in ISO 4217."
          },
          {
            "name": "units",
            "type": "FLOAT",
            "mode": "NULLABLE",
            "description": "The value of the amount."
          }
        ]
      },
      {
        "name": "duration_minutes",
        "type": "INTEGER",
        "mode": "NULLABLE"
      },
      {
        "name": "quota_bytes",
        "type": "INTEGER",
        "mode": "NULLABLE",
        "description": "Package quota in bytes."
      },
      {
        "name": "quota_minutes",
        "type": "INTEGER",
        "mode": "NULLABLE",
        "description": "Package quota in minutes."
      },
      {
        "name": "buy_time",
        "type": "TIMESTAMP",
        "mode": "NULLABLE",
        "description": "Timestamp when the user bought this plan."
      }
    ]
  },
  {
    "name": "update_time",
    "type": "TIMESTAMP",
    "mode": "REQUIRED",
    "description": "Updated timestamp."
  }
]

---

Peristiwa CPID

message CpidGenEvent {
  optional string cpid = 1;
  optional string sub_id = 2;
  optional string timestamp = 3;
}

---