Looker Studio Function : SECOND
Category: DATE function
The SECOND function in Looker Studio plays a crucial role in time-based analysis. It extracts the second from a given timestamp or time field, helping analysts dive deeper into customer behavior, performance patterns, and temporal trends.
Purpose of the SECOND Function
1. Data Distribution Analysis :
By breaking down time into seconds, you can analyze peak activity windows or response times. This enables more accurate performance analysis and improves real-time monitoring of digital assets.
2. Customer Segmentation :
The SECOND function helps segment customers based on precise activity timestamps, such as click behavior within the same minute. It allows you to identify micro-moments in customer journeys.
3. Decision Making :
Using second-level data empowers decision-makers to optimize workflows and systems that rely on exact timing, such as fraud detection or server performance under stress.
Type of Calculation & Practical Use Cases
✅ Performance Benchmarking
Compare how long actions take by tracking seconds across user sessions.
✅ Customer Segmentation
Use seconds to pinpoint active user segments within specific timeframes.
✅ Time Series Analysis
Enhance time-series models by including second-level precision.
SECOND(datetime_expression)
| Parameter | Type | Description |
|---|---|---|
datetime_expression | DateTime | A date or time field from which to extract seconds |
How Does the SECOND Function Work?
The SECOND function parses a datetime value and returns the second part (00–59). It operates at the granular level, ideal for pinpointing exact moments of events within a minute.
When should use the SECOND Function Work?
Use SECOND() when you need high-precision time data. It’s perfect for measuring fast events, understanding user behavior within tight timeframes, or building real-time dashboards in Looker Studio.
Example of SECOND with Result
SECOND(DATETIME “2025-06-21 13:45:32”) → 32
Example : 1 Basic Usage
Field: Timestamp → 2025-06-21 12:30:45
Formula: SECOND(Timestamp) → Result: 45
Example 2: Column Usage
You can apply SECOND() directly in calculated fields. This allows it to be used in tables, charts, and filters for enhanced reporting based on second-level data.
Example 3: Handling Decimals and Scientific Notation
SECOND()only works with valid datetime inputs.It ignores decimals or scientific notation and only parses standard datetime formats.
Example 4: Combining with Other Functions
Combine with:
HOUR()MINUTE()CASEIF
Tips and Tricks
Use
SECOND()with filters to identify rapid interactions.Combine with
CASEstatements for labeling time-based behavior.Ideal for tracking API latency, ad impressions, or real-time logs.
The SECOND function extracts the second value (00–59) from a datetime field. It’s useful for analyzing precise time-based events, like user clicks or system actions that occur within a specific second.
Yes, SECOND() can be applied in filters to isolate events occurring at specific seconds within a minute, helping you analyze high-frequency data or user behavior with fine time granularity.
No, the SECOND function only works with valid datetime formats. It doesn’t support scientific notation or decimal numbers and will return an error if the input isn’t a proper datetime value.
Yes, you can use SECOND() in calculated fields to build time-based logic, create segments, or enhance dashboards with second-level insights, allowing for more detailed performance or behavior analysis.
The SECOND function requires a datetime input. Ensure your data field is formatted correctly as a date or timestamp to avoid calculation errors or unexpected results in your reports.