🛠 Overview
The Flashtalking connector ingests aggregate delivery logs from an sFTP drop supplied by Flashtalking ad‑serving platform. Files are collected once per day, parsed, and appended to the fact table flashtalking_data_aggregate.
Granularity – one row per placement/creative/site per day (as structured in the CSV).
Purpose – Consolidate impressions and clicks served via Flashtalking for cost‑per‑placement analysis or cross‑platform attribution.
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 address (e.g. | ✅ | Text |
| Username for sFTP login | ✅ | Text |
| Password for sFTP login | ✅ | Text |
Protocol | Fixed to | — | — |
Authentication uses basic username & password over SSH.
🗓️ Job Configuration – Flashtalking – Data Import
Setting | Value |
Feed |
|
Job Label | Flashtalking – Data Import |
Schedule | Daily, 08:00 UTC |
Look‑back | 1 day |
Target Table |
|
Update Mode | Append |
Date Column |
|
File Directory |
|
Filename Pattern |
|
Grain Date Format |
|
📚 Table Schema – flashtalking_data_aggregate
All columns are ingested verbatim from the CSV; below are the standard fields used within Bright Analytics:
Field | Description |
| Date (YYYY‑MM‑DD) parsed via |
| Placement identifier/name |
| Site or domain |
| Creative name |
| Impression count |
| 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] |
|
Site Name [FT] |
|
Creative Name [FT] |
|
📊 Base Metrics
Metric Name | Formula | Round |
Impressions [FT] |
| 0 |
Clicks [FT] |
| 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.
✅ Summary
This Flashtalking sFTP connector performs a daily pull of placement‑level CSV files, parsing dates with Ymd format and appending data to flashtalking_data_aggregate. It surfaces core delivery metrics (impressions, clicks) alongside placement, site, and creative dimensions, enabling consolidated reporting alongside DSP/Ad Server data.