Skip to main content

Flashtalking sFTP Connector

Updated this week
Flashtalking Logo & Brand Assets (SVG, PNG and vector) - Brandfetch

Overview

Flashtalking is an advertising technology platform that provides dynamic ad serving, measurement, and analytics across display, video, mobile, and CTV campaigns. The Flashtalking sFTP offers programmatic access to campaign metadata, creative details, ad impressions, clicks, conversions, and audience metrics, enabling advertisers to integrate detailed ad delivery and performance data into dashboards and reporting systems.

Granularity

This integration retrieves data at Account, Campaign, Placement and Creative levels.

Purpose

  • Monitor Flashtalking campaign delivery and performance

  • Analyse placement and creative effectiveness

  • Track dynamic creative engagement metrics

  • Measure audience reach, frequency, and exposure

  • Integrate Flashtalking metrics into multi-channel dashboards

  • Conduct historical audits and campaign performance analysis

Refresh cadence

Daily append; 1‑day look‑back to catch late files.

For more information on this integration, please follow this link here.


Connection Setup

Key

Description

Required

Type

sftp_host

sFTP host address (e.g. sftp.flashtalking.com)

Text

sftp_username

Username for sFTP login

Text

sftp_password

Password for sFTP login

Text

Protocol

Fixed to sftp

Authentication uses basic username & password over SSH.


Job Configuration – Flashtalking – Data Import

Setting

Value

Feed

ftp_import

Job Label

Flashtalking – Data Import

Schedule

Daily, 08:00 UTC

Look‑back

1 day

Target Table

flashtalking_data_aggregate

Update Mode

Append

Date Column

activity_date

File Directory

target_directory (hidden option – path specified)

Filename Pattern

filename (hidden option – exact file name)

Grain Date Format

Ymd (e.g., 20250131) – hidden option for parser


Table Schema – flashtalking_data_aggregate

All columns are ingested verbatim from the CSV; below are the standard fields used within Bright Analytics:

Field

Description

activity_date

Date (YYYY‑MM‑DD) parsed via Ymd format

placement

Placement identifier/name

site_name

Site or domain

creative

Creative name

total_ads_requested

Impression count

clicks

Click count

Additional CSV columns

File may include cost, video metrics etc.

Note – The connector will automatically import all columns present in the sFTP file even if not listed above.


Dimensions

Dimension Name

Mapping

Placement [FT]

placement

Site Name [FT]

site_name

Creative Name [FT]

creative


Base Metrics

Metric Name

Formula

Round

Impressions [FT]

SUM(total_ads_requested)

0

Clicks [FT]

COUNT(clicks) (or SUM(clicks)*)`

0


Joins

No built‑in lookup tables or joins are defined for Flashtalking; however, the placement, creative, and site dimensions can be linked to other ad‑server data sets via shared keys.

Did this answer your question?