Skip to main content

Overview of export data

Updated over a week ago

Bluecore’s email service provider (ESP) and email eligibility data can be exported to inform strategic decisions around channel spend, campaign engagement, performance, audience, and marketing eligibility.

You can use the data to keep your system of record up-to-date for compliance, or import it into other third-party applications.

For information on creating and managing jobs, see how to export data.

ESP events

The following events are only available if using SendGrid:

  • Deliver

  • Hard bounce

  • Deferred

  • Dropped

  • Spam report

  • Soft bounce

The following table outlines which fields are available in which ESP export.

Field name

Open

Click

Send, deliver, and hard bounce

Deferred, dropped, spam report, and soft bounce

email

event

event_time

unique_key

updated_at

device_type

user_agent

campaign_id

campaign_name

campaign_classification

audience_id

subject_line

nqe

click_url

reason

ESP event descriptions

The following table outlines the ESP event fields and their definition.

Field name

Type

Description

Nullable

Data origin

email

String

The customer’s email

No

Bluecore

event

String

The event name

No

Bluecore

event_time

Date-time

The date-time when Bluecore was informed about the event, in UTC

No

Bluecore

unique_key

String

Alphanumeric primary unique id. Prevents accidental data duplication during data transformations.

No

Bluecore

updated_at

Date-time

When the data was last updated in Bluecore's data warehouse, in UTC

No

Bluecore

device_type

String

The device the customer used when the event occurred.

Yes

Bluecore

user_agent

String

The customer's user agent string.

Yes

Bluecore

campaign_id

Integer

The campaign’s unique ID

No

Bluecore

campaign_name

String

The name of the campaign

No

Client

campaign_classification

Enum

The campaign’s classification. Valid values:

  • Batch

  • Promotional

No

Client

audience_id

Integer

The audience’s unique ID

No

Bluecore

subject_line

String

The campaign's subject line

No

Client

nqe

String

The email’s unique ID.

Two records with the same NQE refer to the same email.

No

Bluecore

click_url

String

The URL that the customer clicked

Yes

Client

reason

String

Why the event occurred.

No

Bluecore

Eligibility events

You can export the following eligibility reports:

  • Eligibility status

    • Includes opt-in, unsubscribe, and known statuses

  • Opt-in events

  • Unsubscribe events

Field name

Opt-in and unsubscribe

Eligibility status (Includes opt-in, unsubscribe, and known)

email

email_status

event

source

reason

created

unique_key

dbt_updated_at

Eligibility descriptions

You can export the following eligibility reports:

  • Full list status:

    • Opted-in

    • Unsubscribed

    • Known

  • Opt-in events

  • Unsubscribe events

The following fields are available for all eligibility events.

Field name

Type

Description

Nullable

Data origin

email

String

The customer’s email.

No

Bluecore

email_status

String

The email eligibility status. Only appears on the current eligibility status.

Valid values:

  • ELIGIBILITY_STATUS_UNSUBSCRIBED

  • ELIGIBILITY_STATUS_SUBSCRIBED

  • NULL

Yes

Bluecore

event

String

The name of the event. Valid values:

  • Optin

  • Unsubscribe

Yes

Bluecore

source

String

The source of the eligibility event.

Yes

Bluecore

reason

String

Why the event occurred.

Yes

Bluecore

created

Date-time

The date and time the eligibility event happened, in UTC

No

Bluecore

unique_key

String

Alphanumeric primary unique id. Prevents accidental data duplication during data transformations

Yes

Bluecore

dbt_updated_at

Date-time

The timestamp of when the record was last modified, in UTC.

No

Bluecore

Opt-in source reasons

Some files contain a source as to how the customer opted in. The following sources are:

  • Bluecore_capture

    • The customer opted in through a Site capture campaign.

  • External

    • The customer’s opt-in request was added via the Events API or a managed feed.

  • Integration

    • The customer’s opt-in request was captured using the Bluecore Website Integration.

Unsubscribe reasons

Some files contain a reason as to why the customer unsubscribed. The following reasons are:

  • Bluecore_email

    • The customer unsubscribed by clicking a link in a Bluecore email.

  • Bluecore_id_conflict

    • The customer was unsubscribed due to customer identity reconciliation issues.

  • External

    • The customer’s unsubscribe request was loaded into Bluecore through a managed feed.

  • Manual

    • The customer was unsubscribed in the Unsubscribe page in Bluecore.

  • Bounce_events

    • The customer was automatically unsubscribed due to the bounce threshold.

Did this answer your question?