Exporting Data
There are three primary ways to export your data from Northbeam -- let's review them!
- CSV file
- Google Cloud Storage (GCS)
- Data Export API
CSV File
Exporting your data to a CSV file can easily be done within the Sales page.
Frequency
CSV files can be exported either on a one-time basis or on a regular schedule (daily, weekly, or monthly).
- One-Time Basis: Select your metrics, click "Export Now," then go to the Documents menu to download your file.
- Regular Schedule: After choosing your metrics, click "Schedule Export" and configure your preferences. You will receive emails with a link to download your file once the export is scheduled.
Step by Step Instructions:
- Navigate to the Sales page
- Click Export
- Select Chart values or Table Values
- Chart Values - data from the line graph
- Table Values - data from the table
- If Table Values is selected, click CSV Export
- Use the Report Builder to create your report
- Export Now or Schedule the Report
Data Export Options:
| Option | Description | Examples // Extra Context |
|---|---|---|
| Export data broken down by label | Does not break out by date | - |
| Export data broken out by date | Breaks data down by the Granularity selected (Daily is the default) | If Weekly is selected, data from Sunday to Saturday will be combined. We report data starting on each Sunday. |
| Remove $0 / 0 transaction items | Removes any line items valued at $0 or 0 transactions | - |
| Export aggregated data only | Ignores the Level that is selected. | If Campaign level is selected, all campaigns will be consolidated. |
Google Cloud Storage
You could also export your data from Northbeam directly into Google Cloud Storage bucket.
Step by Step Instructions:
- Navigate to the Sales page
- Click Export
- Select Table Values
- Chart Values - data from the line graph
- Table Values - data from the table
- Click Google Cloud Storage
- In the "Storage Object Admin", add the following email: [email protected]
- Under Add Your Bucket, enter the name of your bucket to receive the data
- Click Validate to confirm that the connection works
Data Export API
Lastly, you could set up an API request using our Data Export API.
FAQs
1. How can I receive CSV file exports attached to emails?
Currently, our scheduled export functionality only provides a link to your dashboard for file downloads. Our Product team is aware of the request to attach files directly to emails, but there is no timeline for this feature at the moment.
2. How can I get Northbeam data into Google Sheets?
Currently, we do not have a product feature that automatically exports data into Google Sheets.
However, if you have development resources available, here are a few methods:
- Method 1: Use Google Apps Script with our Data Export API to export data to Sheets
- Method 2: Export to GCS then using the GCS Connector in Sheets (Google's official documentation)
- Method 3: Export to CSV and import or copy/paste into Google Sheets
Please Note
Unfortunately, we cannot provide further guidance on setting this up. Please consult your development team or refer to the documentation linked above for assistance.
3. How can I get Northbeam data into BigQuery?
The easiest way to get data into BigQuery is to export the data into a custom Google Cloud Storage bucket (via dashboard or API), then import it from GCS into BigQuery (Google's official documentation)
Please Note
Unfortunately, we cannot provide further guidance on setting this up. Please consult your development team or refer to the documentation linked above for assistance.
Updated 3 months ago