FluentCo
FluentCo is an affiliate marketing network built on the HasOffers (TUNE) platform. The Extract connector pulls:
- Conversion-level events from the HasOffers Reporting API
- Aggregated daily performance (stats) from the HasOffers Stats API
Source Setup Guide
To connect FluentCo to Extract, you’ll need HasOffers API credentials for your network:
- Network ID
- Client ID
- Client Secret
- Advertiser IDs (one or more numeric advertiser IDs, comma-separated)
Contact your FluentCo account manager to obtain these values and confirm your account has access to the Reporting/Stats endpoints.
Authentication
This connector uses OAuth-style client credentials against HasOffers:
- Extract requests an access token from the HasOffers authorization endpoint using your Client ID and Client Secret.
- Extract then uses the token to call the HasOffers API for reports.
Connection Setup Guide
After connecting FluentCo to a destination, configure the following settings:
- Connection Pull Schedule: How frequently Extract pulls data from FluentCo.
- Backfill (Days): How many days of historical data to include on each run (default: 7 days).
- Destination-specific settings: Settings such as Dataset Name or Target Schema (varies by destination).
- Schema Migration Policy: How Extract handles schema changes from the source.
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
network_id | string | Yes | Your HasOffers Network ID. |
client_id | string | Yes | OAuth client ID for the HasOffers integrator API. |
client_secret | string | Yes | OAuth client secret for the HasOffers integrator API. |
advertiser_ids | string | Yes | Comma-separated list of numeric advertiser IDs to include (for example: 123,456). |
backfill | integer | No | Number of days of historical data to re-sync on each run (default: 7). |
hour_offset | integer | No | Hour offset applied when querying report windows (default: 0). Use this if you need the reporting day boundary shifted relative to UTC. |
Data Retention
FluentCo/HasOffers API retention depends on your network configuration and the specific report/dimensions requested.
If you cannot retrieve older data you expect to be available, contact FluentCo support to confirm retention limits for your account and reporting configuration.
Schema ERD
Explore the interactive entity relationship diagram for FluentCo.
Data Streams
conversions
Individual conversion events from the HasOffers Report.getConversions endpoint. Each row represents a single conversion with associated offer, affiliate, advertiser, goal, and geo details.
- Sync behavior: Partitioned by
date. The connector re-reads the backfill window on each run to capture updates (for example, status changes). - Primary identifier:
tune_event_id(must remain selected). - Enabled by default: No (must be explicitly selected).
daily_report
Aggregated daily performance statistics from the HasOffers Stats API. Includes metrics such as impressions, clicks, conversions, revenue, payout, and profit, along with a wide set of dimensions (offer, advertiser, affiliate, device, geo, and more).
- Sync behavior: Partitioned by
date. Replaces existing data for each date in the sync window. - Enabled by default: Yes.
Field Naming
Fields from the HasOffers API are flattened into Extract’s standard snake_case:
- Nested dimension paths are flattened with double underscores (for example,
Advertiser.companybecomesadvertiser__company). - Stat fields are mapped to
snake_case(for example,Stat.offer_idbecomesoffer_id).
Amounts retain their original reported currency; no currency conversion is applied.