Skip to main content

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​

FieldTypeRequiredDescription
network_idstringYesYour HasOffers Network ID.
client_idstringYesOAuth client ID for the HasOffers integrator API.
client_secretstringYesOAuth client secret for the HasOffers integrator API.
advertiser_idsstringYesComma-separated list of numeric advertiser IDs to include (for example: 123,456).
backfillintegerNoNumber of days of historical data to re-sync on each run (default: 7).
hour_offsetintegerNoHour 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.

Open page

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).
Loading ....

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.
Loading ....

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.company becomes advertiser__company).
  • Stat fields are mapped to snake_case (for example, Stat.offer_id becomes offer_id).

Amounts retain their original reported currency; no currency conversion is applied.