Sharing Ad Performance Data in Real-time Using Sharelinks

The Sharelink allows you to share your Actuals Report using a simple link. Anyone with a Sharelink can download a CSV file that contains the Actuals Report data without accessing the Airbridge dashboard.

Attention

The data shared via Sharelinks is the data from the report view you have created and have access to in the Airbridge dashboard.

Keep in mind that when you share Sharelinks, there are potential risks of exposing sensitive data unintentionally. Anyone with the Sharelink can import the report data, even if they don't have access permission or aren't Airbridge users.

Sharelinks can be created only for saved Airbridge reports. When entering the Sharelink into the address bar of a web browser, the report data is downloaded as a CSV file.

The data in the downloaded CSV file has the same metric, GroupBy, filter, date range, and language settings as the original report.

Aside from the metric, GroupBy, date option, and time zone settings, parameters can be added to customize other settings. Refer to this section of the article to learn more.

Caution

Sharelinks can be created only for saved reports. The [share] icon is only visible on saved reports. If you can't see the [share] icon on your report, save the report first.

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

  1. Click Saved Reports 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.

3. Switch on the [Create Sharelink] toggle. A Sharelink will appear below the toggle.

4. 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.

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/v2/(URL).csv

The data in the downloaded CSV file has the same date range, metrics, GroupBy, filter, language settings as the original report. The CSV file downloaded from a Sharelink can carry up to 1,000 rows by default.

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 50,000 rows can be downloaded.

The following table lists the parameters that are available.

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

Attention

The language parameter is present in all Sharelinks by default. To add more parameters, use ampersands (”&”) between parameters.

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

 

Caution

The following settings in the CSV file downloaded from Sharelinks cannot be modified by adding parameters to the Sharelink and will be the same as the settings of the Airbridge dashboard.

  • Metrics, GroupBys, date option, time zone

If you want to modify the above settings, modify them in 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 report data can be imported to Google Spreadsheets using the importdata function. Use the importdata function like the following example.

  • =importdata("Full Sharelink")

The report data is pulled every 1 hour, allowing for near-realtime data monitoring on Google Spreadsheets. By using Sharelinks and the importdata function, you can create your own custom report that combines Airbridge data with data from any other source.

Troubleshooting date field errors in Google Sheets

The “Event Date” GroupBy column in the Google Spreadsheet file 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]. Or, click the [date] icon in the format menu bar.

By importing the Actuals Report data using Sharelinks and Google Spreadsheets, you can share the Actuals Report data in your desired format regardless of the app access permissions in Airbridge. 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 in real-time

  • Creating a custom report by integrating Airbridge data with internal company data

Attention

Was this page helpful?

Have any questions or suggestions?