The Sharelink allows you to share your Actuals Report via a simple link. Anyone with a Sharelink can download a CSV file that contains the Actuals Report data without accessing the Airbridge dashboard.
Caution
The Sharelink can be created for saved reports in the Actuals Report only.
The Sharelink can be created for saved reports in the Actuals Report only. To save your report, click the “Save” button on the top right.
When the report is saved, the [Share] icon is made visible. By clicking the [Share] icon, you can switch on and off the [Create Sharelink] toggle to create or deprecate the Sharelink.
When entering the Sharelink into the address bar of the web browser, the Actuals Report data is downloaded in a CSV file. The data in the downloaded CSV file has the same metric, GroupBy, Filter, date option and time zone settings, as well as the same date range and language settings as the original Actuals Report. By default, the CSV file carries 1,000 rows of data.
By adding parameters to the Sharelink, the language, data range setting, and the number of rows in the CSV file can be modified manually.
Click “Saved Reports” on the top right to find the report you want to share from the dropdown list and open it.
Click the [Share] icon.
Switch on the [Create Sharelink] toggle and click the Sharelink below the toggle to copy it.
Share the Sharelink with anyone you want to share your report data. If you switch off the [Create Sharelink] toggle, 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.
The Sharelink can be customized by adding parameters to the URL or editing the existing parameters in the URL to modify the elements in the report data, such as the language, date range, and number of rows. A question mark (”?") must be present at the end of the URL before adding any parameters.
When adding multiple parameters, separate them with an ampersand ("&"). A customized Sharelink should look like the following.
URL?parameter1¶meter2¶meter3
Parameter | Function | Format | Example |
---|---|---|---|
from, to | Sets a specific date range (Max. 92 days) | YYYY-MM-DD | from=2022-01-01&to=2022-03-01 |
since | Sets the date range from a specific date to today | YYYY-MM-DD | since-2022-01-01 |
last | Sets the date range to the last n days (The date range does not include today unless n=0) | 0 or natural numbers (1, 2, 3, etc.) | last=3 |
offset | Changes the last date of the date range from today to n days before today (Always used with date range parameters) | Natural numbers (1, 2, 3, etc.) | offset=3 |
rowNo | Provides data in n rows (Max. 50,000 rows) | Natural numbers (1~50,000) | rowNo=5000 |
granularity | Changes the date unit of “last” and “offset” parameters to day, week, or month (If not specified, the date unit is “day”) | day/week/month | granularity=day |
language | Changes the language settings of the Sharelink | en/ko | language=en |
isNowenabled | Used with the “last” parameter. “true” includes today, and “false” does not include today. If the “last” parameter is used without the “isNowenabled” parameter, the date range does not include today, which is D0. | true/false | isNowEnabled=false |
Caution
The language parameter is added in all Sharelinks by default. To add more parameters, use ampersands (”&”) to separate them.
A Sharelink URL starts with “report.airbridge.io/v2/(URL).csv” and is then followed by parameters. See the following parameter examples to understand how to customize Sharelinks.
Full Sharelink URL: report.airbridge.io/v2/(URL).csv?language=en
The “language=en” parameter indicates that the text in the CSV file downloaded via Sharelink is English.
Full Sharelink URL: report.airbridge.io/v2/(URL).csv?last=4&offset=3&isNowEnabled=true&language=en
The “last=4” parameter and “isNowEnabled=true” parameter indicate that the data is from the last 4 days, including today. The “offset=3” parameter is also added, which indicates that the last date of the date range is 3 days prior to today.
Full Sharelink URL: report.airbridge.io/v2/(URL).csv?language=en&last=4&granularity=month
The “granularity=month” parameter and the “last=4” parameter indicates that the data is from the last 4 months. However, the maximum date range supported is 92 days, and therefore, this Sharelink won’t work.
Full Sharelink URL: report.airbridge.io/v2/(URL).csv?rowNo=3000&language=ko
The “rowNo=3000” parameter indicates that the CSV file will contain 3,000 rows of data.
Caution
The metrics, GroupBys, date option, time zone in the CSV file downloaded via Sharelink can’t be modified by adding parameters. If you want to change the metrics, GroupBys, date option, time zone, reconfigure the Actuals Report in your Airbridge dashboard, switch off the [Create Sharelink] toggle, and switch it on again to create a new Sharelink. Then, copy the new Sharelink for your data-sharing purposes.
The date range can be adjusted using date range parameters; however, please note that the maximum date range is 92 days.
The number of rows supported by default is 1,000 rows. By using the “rowNo” parameter, a maximum of 50,000 rows are supported.
The Sharelink can be imported to Google Spreadsheet using the importdata functions. The importdata function imports the CSV file via Sharelink to Google Spreadsheet. Use the importdata function like the following example.
=importdata("Full Sharelink URL")
Using the importdata function, the report data is pulled every 1 hour allowing for near-realtime data monitoring on Google Spreadsheet. The importdata function can be used multiple times in one Google Spreadsheet file. Use the importdata function to create your own custom report that combines data from Airbridge with data from any other source.
Troubleshooting
The “Event Date” GroupBy column in the CSV file downloaded via Sharelink may show dates in numbers. In such a case, select all cells that contain the event data value, select [Format] from the top menu bar, and select [Number]>[Date].
Was this page helpful?