Sharing Retention Data Using Sharelinks

The Sharelink allows you to share your Retention Report using a simple link. The data a Sharelink returns is updated every hour.

​

Creating Sharelinks

You need to have a saved Retention Report to create a Sharelink. If you don’t have a saved Retention Report, save a report view first.

1. Click Report Library at the top right to open the report you want to share from the drop-down list. Or, if you want to create a Sharelink of the report you have just created, click Save at the top right.
2. Click the [share] icon on the top right. Switch on the [Create Sharelink] toggle. A Sharelink will appear below the toggle.
3. Click the Sharelink below the toggle to copy it. Share the Sharelink with anyone you want to share your report data. Note that if the toggle is turned off, the Sharelink won’t work anymore. Every time you switch on the toggle, a new Sharelink is created, and the new link must be shared.

​

Customizing Sharelinks

The Sharelink can be customized by adding new parameters or editing the existing parameters to modify the settings in the data. The structure of a Sharelink looks like the following.

• Sharelink structure: Basic URL?parameter1&paramter2&parameter3
• Basic URL: report.airbridge.io/v3/(URL).csv

The data in the downloaded CSV file has the same cohort, date range, granularity, Start Event, Return Event, GroupBy, filter, and language settings as the original report. The CSV file downloaded from a Sharelink can carry up to 1,000 rows for top-rows by default. The sub-rows are provided based on the top rows. By adding parameters or editing the existing parameters, the Sharelink can be customized to modify the settings in the data, such as the language settings, date range, number of rows, etc. A question mark (”?”) must be present at the end of the URL before the parameters. For example, by adding the rowNo parameter to the Sharelink, up to 10,000 rows for top-rows can be downloaded. The following table lists the parameters that are available.

Parameters available for Sharelink customization

A Sharelink can have only 1 of the 3 parameters that are related to date range settings (from, since, last). The maximum range configurable for each granularity option is as follows.

Granularity	Minutely	Hourly	Daily	Weekly	Monthly
Maximum range	3 days	7 days	184 days	12 weeks	3 months

The table below lists the parameters available for customizing Sharelinks of Retention Reports.

Parameter	Description	Format	Example
from, to	Sets a specific date range	YYYY-MM-DD	from=2024-01-01&to=2024-03-01
since	Sets the date range from a specific date to today	YYYY-MM-DD	since=2024-01-01
last	- Sets the date range to the last n days, weeks, months. - When the granularity is set to minutely or hourly, it is automatically set to last n days. - The date range does not include today, this week, or this month unless n=0.	0 or natural numbers (0, 1, 2, 3…)	last=3
offset	- Changes the last date of the date range from today to n days, weeks, or months before today - When the granularity is set to minutely or hourly, it is automatically set to n days before today. - This must be used together with date range parameters.	Natural numbers (1, 2, 3…)	offset=3
rowNo	- Provides the top rows in n rows. - Can be configured to max. 10,000 rows.	Natural numbers (1~10000)	rowNo=5000
language	- Changes the language settings of the Sharelink. - If not specified, the same language as the Airbridge dashboard is applied.	en, ko	language=en
isNowEnabled	- Used with the last parameter. - If this parameter is not used, false is applied. (true: includes today, false:does not include today)	true, false	isNowEnabled=false
includesMetadata	- Includes the report config info in the CSV file. - If this parameter is not used, false is applied. (true: includes report config, false: does not include report config)	true, false	includesMetadata=true
csvType	- Sets the retention metric. - If this parameter is not used, count is applied. (count: number of retained users, percent: retention rate)	count, percent	csvType=percent
useViewFormat	- Sets the data display format for values that include special characters such as +α, ±α, - , etc. Unit measurements such as d, h are not considered as such. If this parameter is not used, true is applied. - true: Values that include special characters will appear as is. - false: Values that include special characters will appear without the special characters. For example, 56+α will appear as 56. If the value consists of only special characters, it will appear as 0 in the CSV file. Note that 0 does not always mean that the actual value is 0.	true/false	useViewFormat=true

NoteTo gain full visibility of your Meta ads campaign data in Airbridge reports, you need to accept Meta’s Advanced Mobile Measurement (AMM) Terms. Otherwise, Meta ads campaign data remains masked in Airbridge. For more information about Meta’s AMM terms, refer to this article.

When adding multiple parameters, separate them with an ampersand (”&”).

​

Sharelink parameter examples

A Sharelink starts with “report.airbridge.io/v3/(URL).csv” followed by a question mark and parameters. See the following examples to understand how to customize Sharelinks.

​

Importing Data to Google Spreadsheets using Sharelinks

The report data can be imported to Google Spreadsheets using the IMPORTDATA function. Use the IMPORTDATA function like the following example.

• =importdata(“Full Sharelink”)

The IMPORTDATA function calls the URL once an hour. Sharelink updates on the same schedule, so the data you see was aggregated up to an hour ago. If you see the following message instead of data, check again in an hour.

• Data has not been imported yet. Sharelink data in Google Sheets updates hourly.

The Sharelinks and Google Spreadsheets will come in handy for the following purposes:

• Sharing Airbridge data externally, regardless of access permissions
• Monitoring the Airbridge data in Google Spreadsheets, refreshed every hour
• Creating a custom report by integrating Airbridge data with internal company data

​

Attention

Data shared using Sharelinks

When you share data using Sharelinks, you’re providing access to the report view you’ve created in the Airbridge dashboard. It’s important to note that anyone with the Sharelink can import the report data, regardless of their access permissions or whether they are Airbridge users.This feature allows you to easily share data with others without the need for them to be Airbridge users or log in to the dashboard, making it a convenient option for collaboration.