SIM_STATS_MONTHLY_SUMMARY

Monthly SIM usage totals by SIM and speed class.

SIM_STATS_MONTHLY_SUMMARY contains pre-aggregated monthly traffic totals per SIM and speed class. Prefer it over raw SIM_STATS records whenever you are aggregating monthly usage counts or traffic totals and the included dimensions are enough. Those dimensions include SIM, IMSI, operator, month, speed class, and the MISC usage attributes; in Global/SNG tables, SPEED_CLASS can also carry a three-letter country code. Use it for trend analysis and monthly usage ranking. Aggregate across SPEED_CLASS when users ask for total monthly usage per SIM.

Do not assume SPEED_CLASS is only a plan code. In Global/SNG tables, SPEED_CLASS can be prefixed with a three-letter uppercase country code and hyphen, such as USA-plan01s or MUS-plan01s. It can be empty for non-SIM entries, and the country prefix can be omitted when it does not make sense, such as a planArc01 WireGuard connection. JP entries usually omit the country prefix because JP coverage supports Japan only.

The MISC column contains optional service usage counters and VPG usage attributes.

Public Contract

• Rows are limited to the current SORACOM Query request context.

Data Freshness

Updated monthly.

Columns

Column	Type	Description
SIM_ID	TEXT	SIM identifier.
IMSI	TEXT	IMSI used by the SIM or device identifier for non-SIM devices.
OPERATOR_ID	TEXT	Operator identifier associated with the row.
YEAR_MONTH	TEXT	Usage month in YYYYMM format.
SPEED_CLASS	TEXT	Speed class for the aggregated usage. Global/SNG values can include a three-letter uppercase country code prefix and hyphen, such as USA-plan01s.
DOWNLINK_BYTES	NUMBER	Total bytes downloaded for the month and speed class.
UPLINK_BYTES	NUMBER	Total bytes uploaded for the month and speed class.
DOWNLINK_PKTS	NUMBER	Total packets downloaded for the month and speed class.
UPLINK_PKTS	NUMBER	Total packets uploaded for the month and speed class.
MISC	OBJECT	Additional service usage counters and VPG usage attributes.

JSON / VARIANT Fields

MISC contains optional service usage counters. Fields appear only when the corresponding usage exists.

Common fields include:

Field	Type	Description
beamStatsMap.inHttp.count	number	Beam inbound HTTP request count.
beamStatsMap.outHttp.count	number	Beam outbound HTTP request count.
beamStatsMap.inHttps.count	number	Beam inbound HTTPS request count.
beamStatsMap.outHttps.count	number	Beam outbound HTTPS request count.
beamStatsMap.inTcp.count	number	Beam inbound TCP request count.
beamStatsMap.outTcp.count	number	Beam outbound TCP request count.
beamStatsMap.inUdp.count	number	Beam inbound UDP request count.
beamStatsMap.outUdp.count	number	Beam outbound UDP request count.
beamStatsMap.inMqtt.count	number	Beam inbound MQTT request count.
beamStatsMap.outMqtt.count	number	Beam outbound MQTT request count.
harvestStatsMap.harvest_inHttp.count	number	Harvest inbound HTTP request count.
harvestStatsMap.harvest_inTcp.count	number	Harvest inbound TCP request count.
harvestStatsMap.harvest_inUdp.count	number	Harvest inbound UDP request count.
harvestStatsMap.harvest_inMqtt.count	number	Harvest inbound MQTT request count.
harvestStatsMap.harvest_outPlain.count	number	Harvest outbound plain request count.
funkStatsMap.funk_outAwsLambda.count	number	Funk AWS Lambda invocation count.
funnelStatsMap.<funnelType>.outputCount	number	Funnel output count for the funnel type.
inVPGStats	object	Usage counters for traffic through VPG.

Example:

SELECT
  SIM_ID,
  YEAR_MONTH,
  MISC:beamStatsMap.inHttp.count::NUMBER AS beam_in_http
FROM SIM_STATS_MONTHLY_SUMMARY
WHERE MISC:beamStatsMap IS NOT NULL;

Common Queries

SIM_STATS_MONTHLY_SUMMARY provides monthly traffic totals per SIM and SPEED_CLASS. Column names match the SIM_STATS convention: DOWNLINK_BYTES, UPLINK_BYTES, DOWNLINK_PKTS, and UPLINK_PKTS.

Monthly traffic trend per SIM, aggregated across speed classes:

SELECT
  SIM_ID,
  YEAR_MONTH,
  SUM(DOWNLINK_BYTES + UPLINK_BYTES) AS total_bytes
FROM SIM_STATS_MONTHLY_SUMMARY
GROUP BY SIM_ID, YEAR_MONTH
ORDER BY SIM_ID, YEAR_MONTH;

Top SIMs for a specific month, aggregated across speed classes:

SELECT
  SIM_ID,
  IMSI,
  SUM(DOWNLINK_BYTES + UPLINK_BYTES) AS total_bytes
FROM SIM_STATS_MONTHLY_SUMMARY
WHERE YEAR_MONTH = '202501'
GROUP BY SIM_ID, IMSI
ORDER BY total_bytes DESC
LIMIT 100;

Beam usage counters:

SELECT
  SIM_ID,
  YEAR_MONTH,
  MISC:beamStatsMap.inHttp.count::NUMBER AS beam_in_http,
  MISC:beamStatsMap.outHttp.count::NUMBER AS beam_out_http
FROM SIM_STATS_MONTHLY_SUMMARY
WHERE MISC:beamStatsMap IS NOT NULL;