MENU

Brandfolder Insights Data Connector

Overview

Brandfolder's Insights Data Connector allows customers to connect directly to their own data. The data is housed in Google BigQuery within a unique Google Cloud Platform (GCP) Project which is established for the customer. The data can be accessed with any existing BigQuery connection method using a GCP account associated with the customer GCP project. The data is refreshed nightly.

Schemas

The current version of the Insights Data Connector includes the following schemas, with more tables and columns planned in future versions. These tables exist within the brandfolder dataset in the customer’s GCP project. Each table can be accessed with the path <GCP-project-name>.brandfolder.<table_name>.

Here is an example test query to use, replacing with the one for your organization.

SELECT * FROM `bfdc-<org-slug>.brandfolder.assets` LIMIT 1000

Assets

The collections column is an array. For notes on how to query array-type columns in BigQuery, please reference this BigQuery documentation.

availability can contain four values: published, unpublished, expired, and pending approval.

Column Data Type
key String
name String
description String
brandfolder_key String
section_name String
type String
availability String
availability_start Timestamp
availability_end Timestamp
collections ARRAY (String)
created_at Timestamp

Attachments

Column Data Type
key String
filename String
asset_key String
created_at Timestamp

Brandfolders

privacy can contain three values: public, private, or stealth.

Column Data Type
key String
name String
slug String
privacy String
created_at Timestamp

CDN Aggregates

This table contains daily aggregates of CDN hits, grouped by object and referrer link.

Objects can either be assets or attachments. It is recommended to join to both assets and attachments when consuming this table to get a full picture of CDN hits.

Column Data Type
object_key String
object_type String
event_date Date
referrer_link String
hit_count Integer
bytes_sum Integer
brandfolder_key String

Collections

privacy can contain three values: public, private, or stealth.

Column Data Type
key String
name String
slug String
privacy String
brandfolder_key String
created_at Timestamp

Custom Field Values

Column Data Type
key String
custom_field_key_name String
value String
asset_key String
created_at Timestamp

Events

This table contains events on objects, where prepositional objects are the location from which the user accessed the object. For example, if a user downloaded an asset from inside a collection, the object would be that asset, and the prepositional object would be the collection.

Column Data Type
key String
object_key String
object_type String
type String
prepositional_object_key String
prepositional_object_type String
brandfolder_key String
session_key String
created_at Timestamp

Tags

Column Data Type
key String
name String
asset_key String
auto_generated Bool
created_at Timestamp
deleted_at Timestamp