Metrics

Introduction

This section has the objective to describe the official metrics that can be calculated with the data shared.

Descriptions

Active Users

Definition

Active users refer to the number of unique individuals who were visible to our platform within a given time frame.

Purpose

The active users metric provides insights regarding available inventory. It helps measure the reach and impact of potential campaigns, assess user retention, and evaluate the overall health and growth of the user base.

Calculation

The calculation of active users depends on the specific definition set for "activity". It can be determined based on last active date and client ids. Here at Siprocal we adopt as active a user that has pinged our servers in the last 30 days. The exact calculation counts different IDs during a period specified by the analyst.

SELECT COUNT(DISTINCT clientid) -- Remember to remove the initial `DR-` if this matters
FROM DEVICES -- Se Tables documentation for in-depth description
WHERE lastactivedate >= DATE(TODAY() - INTERVAL '30' DAY) -- Adjust interval accordingly

Opt-in

Definition

Opt-in refers to the act of voluntarily providing consent or permission to receive communication, updates, or promotional material.

Purpose

The opt-in metric helps measure the willingness of individuals to engage with your company's marketing efforts. It provides insights into the size of the company's audience that has expressed interest in receiving communication, allowing for targeted and personalized messaging. Tracking opt-ins are particularly important for compliance with privacy regulations and maintaining a positive reputation with customers.

Calculation

The calculation of opt-in is typically straightforward and involves counting the number of individuals who have explicitly opted to receive communication. For an in-depth description for the relevant optin field, please refer to the documentation of the Devices or Op-ins tables.

SELECT COUNT(DISTINCT clientid) -- Remember to remove the initial `DR-` if this matters
FROM DEVICES
WHERE optin = 1 -- Depending on the relevant opt-in criteria

Campaigns Sent (Client's Targeted)

Definition

Campaigns sent refer to the number of marketing campaigns or promotional messages that have been distributed to the target audience through our channel.

Purpose

The campaigns sent metric is used to evaluate the scope and reach of marketing efforts. It provides insights into the extent of communication with the target audience, helping businesses assess the effectiveness of their marketing strategies.

Calculation

The calculation of campaigns sent is straightforward and involves counting the total number of marketing campaigns that have been sent out to the intended recipients.

Please note that if this query might take long to run if the table has not been optimizing for querying on specific campaigns.

SELECT COUNT(clientid)
FROM CAMPAIGNSENT
WHERE campaignid = 'EXAMPLE_CAMPAIGN_ID'

Campaign Sent With Success (Ad Ready)

Definition

Campaigns sent with success refer to the number of marketing campaigns or promotional messages that have been successfully delivered to the intended recipients without encountering delivery errors or issues.

Purpose

The campaigns sent with success metric is used to evaluate the effectiveness of the campaign delivery process. It provides insights into the quality of the contact list, the reliability of the communication channels, and the overall efficiency of the campaign delivery.

Calculation

The calculation of campaigns sent with success involves counting the total number of marketing campaigns that have been sent out and successfully delivered to the target audience within a specific timeframe.

Please note that if this query might take long to run if the table has not been optimizing for querying on specific campaigns.

  SELECT COUNT(clientid)
  FROM ADIMPRESSIONS
  WHERE campaignid = 'EXAMPLE_CAMPAIGN_ID'

Campaign Displayed (Impressions)

Definition

Campaigns displayed refer to the number of marketing campaigns or promotional messages that have been shown or delivered to the target audience through our channel.

Purpose

The campaigns displayed metric is used to evaluate the visibility and exposure of marketing efforts. It provides insights into the reach of a campaign.

Calculation

The calculation of impressions involves counting the total number of devices on which the campaign was rendered.

Please note that if this query might take long to run if the table has not been optimizing for querying on specific campaigns.

SELECT COUNT(clientid)
FROM ADIMPRESSIONS
WHERE displayed = TRUE
  AND campaignid = 'EXAMPLE_CAMPAIGN_ID'
  AND adintermediate = FALSE

Campaign Clicked (Clicks)

Definition

Campaigns clicked refer to the number of marketing campaigns or promotional messages that have been interacted with by the target audience.

Purpose

The campaigns clicked metric is used to evaluate the level of engagement and responsiveness of the target audience to marketing efforts. It provides insights into the effectiveness of the campaign's messaging, design, and call-to-action elements.

Calculation

The calculation of campaigns clicked involves counting the total number of marketing campaigns that have elicited clicks from the recipients within a specific timeframe.

Please note that if this query might take long to run if the table has not been optimizing for querying on specific campaigns.

SELECT COUNT(clientid)
FROM ADIMPRESSIONS
WHERE clicked = TRUE
  AND campaignid = 'EXAMPLE_CAMPAIGN_ID'
  AND adintermediate = FALSE