Renta / Documentation / Sources / Scaleo

Scaleo

Renta exports three Scaleo reports to your data warehouse: clicks, conversions, and affiliate billing invoices.

Each click and conversion loads as a separate row with amounts, tracking parameters, and details about the visitor's device and location. Invoices carry the amounts, statuses, and payment details of affiliate payouts.

Authentication

Renta connects to Scaleo with two values from your network account: the API base URL and the API key.

When you save the connection, Renta validates the credentials with a test request to your Scaleo network, so a wrong URL or an invalid key returns an error immediately instead of failing on the first pipeline run.

Connect Scaleo source

Go to the CatalogStep 1
  1. Navigate to the Connections > Catalog section in the left sidebar.
  2. Open the Finance category and click the Scaleo card.
Scaleo card in the Finance category of the Renta catalog
Enter the base URL and the API keyStep 2
  1. API base URL.
    The address of your Scaleo dashboard, for example https://yournetwork.scaletrk.com.
  2. API key.
    The key issued in the Scaleo dashboard, in your profile settings.
Add a new Scaleo connection page with the API base URL and API key fields
Name the connection and saveStep 3

In the Source name field, specify a name for this data source. It is used exclusively in the Renta interface.

Click Save. Renta checks the credentials against your Scaleo network before creating the connection.

Scaleo connection setup with the source name field and the Save button
Source createdStep 4

The new source appears in the Sources list with the Active status. You can now use it in pipelines.

Sources list with the new Scaleo source in the Active status

Create a Scaleo pipeline

Select Scaleo as the sourceStep 1

In the left sidebar, click New pipeline. On the Source step, select Scaleo under Already connected and click Next step.

Select a source step with Scaleo under Already connected
Select your Scaleo connectionStep 2

Choose the Scaleo connection you created earlier and click Next step.

Select your Scaleo connection step
Select a destinationStep 3

On the Destination step, select your destination (for example, Google BigQuery) and click Next step.

Select a destination step with Google BigQuery under Already connected
Select the destination connectionStep 4

Choose the destination connection you want to load data into and click Next step.

Select your Google BigQuery connection step

Pipeline configuration

On the final step, choose the report, its fields, and how Renta loads them.

Report type

In the Report Types dropdown, choose which Scaleo report the pipeline loads. One pipeline loads one report, so create a separate pipeline for each report you need.

Scaleo pipeline settings with the Report Types dropdown set to Conversions
Report typeDescription
ClicksEvery click registered in your network as a separate row.
ConversionsEvery conversion transaction as a separate row. Each conversion carries the Click ID of the click that produced it.
InvoicesAffiliate billing invoices with amounts, statuses, billing periods, and payment methods.

Parameters

Check the Scaleo fields to load into the destination table.

Scaleo parameters picker with the field list, the Selected tab, and the Select All button
NameAPI nameDescription
ID
int		idUnique identifier of the invoice.
Invoice Number
text		invoice_numberHuman-readable invoice number (e.g. INV-AFF-0037-002).
Status
text		statusCurrent status of the invoice (e.g. paid, unpaid, draft).
Period
text		periodHuman-readable billing period covered by the invoice (e.g. Feb 1 - Feb 28, 2026).
Date
datetime		dateDate and time the invoice was created.
Amount Value
text		amount_valueInvoice amount as a string (e.g. '1941.00'). Extracted from amount.value.
Amount Currency
text		amount_currencyCurrency of the invoice amount (e.g. USD). Extracted from amount.currency.
Referral Commission Value
text		referral_commission_valueReferral commission amount as a string. Extracted from referral_commission.value.
Referral Commission Currency
text		referral_commission_currencyCurrency of the referral commission. Extracted from referral_commission.currency.
Affiliate ID
int		affiliate_idUnique identifier of the affiliate. Extracted from affiliate.id.
Affiliate Name
text		affiliate_nameDisplay name of the affiliate. Extracted from affiliate.name.
Payment Method ID
int		payment_method_idUnique identifier of the payment method. Extracted from payment_method.id.
Payment Method Title
text		payment_method_titleTitle of the payment method (e.g. USDT TRC-20). Extracted from payment_method.title.
Payment Method Info
text		payment_method_infoPayment destination details such as wallet address. Extracted from payment_method.info.
Payment Method Image
text		payment_method_imageURL of the payment method logo image. Extracted from payment_method.image.
Payment Method Metadata
json		payment_method_metadataMetadata about the payment method change — who changed it and when. Stored as JSON due to deep nesting.
Attachment
text		attachmentURL or path to an attached file for the invoice. Empty string if no attachment.
Internal Notes
text		internal_notesInternal notes for the invoice, may contain transaction URLs or free text.
Offers
structure		offersList of offers associated with the invoice.
Goal Types
structure		goal_typesList of goal types (conversion types) associated with the invoice.
NameAPI nameDescription
Transaction ID
text		transaction_idUnique identifier of the click transaction.
Added Timestamp
datetime		added_timestampDate and time when the click was registered (tenant timezone).
Click ID
text		click_idInternal Scaleo click identifier.
Payout
text		payoutAffiliate payout amount as a string (e.g. '0.000000').
Profit
text		profitNetwork profit amount as a string.
Revenue
text		revenueAdvertiser revenue amount as a string.
Currency
text		currencyCurrency code for payout/profit/revenue (e.g. USD).
Sub ID 1
text		sub_id1Custom sub-ID value #1 passed from traffic source.
Sub ID 2
text		sub_id2Custom sub-ID value #2 passed from traffic source.
Sub ID 3
text		sub_id3Custom sub-ID value #3 passed from traffic source.
Sub ID 4
text		sub_id4Custom sub-ID value #4 passed from traffic source.
Sub ID 5
text		sub_id5Custom sub-ID value #5 passed from traffic source.
Aff Param 1
text		aff_param1Custom affiliate parameter #1.
Aff Param 2
text		aff_param2Custom affiliate parameter #2.
Aff Param 3
text		aff_param3Custom affiliate parameter #3.
Aff Param 4
text		aff_param4Custom affiliate parameter #4.
Aff Param 5
text		aff_param5Custom affiliate parameter #5.
Aff Click ID
text		aff_click_idExternal click identifier passed by the affiliate/traffic source.
Deep Link URL
text		deep_link_urlDeep link destination URL if used.
Click Referer URL
text		click_referer_urlHTTP referer URL recorded at click time.
Source
text		sourceTraffic source label, if configured.
Language
text		languageLanguage detected for the click.
Connection Type
text		connection_typeNetwork connection type (e.g. WiFi / Cable, Mobile Internet).
Mobile Operator
text		mobile_operatorMobile carrier if detected.
IDFA
text		idfaApple Identifier for Advertisers.
GAID
text		gaidGoogle Advertising ID.
IP
text		ipVisitor IP address recorded at click time.
Device Brand
text		device_brandDevice brand (e.g. Apple, Samsung).
Device Model
text		device_modelDevice model (e.g. iPhone).
Device OS
text		device_osOperating system name (e.g. iOS, Android).
Device OS Version
text		device_os_versionOperating system version string.
Browser
text		browserBrowser name (e.g. Mobile Safari).
Browser Version
text		browser_versionBrowser version string.
Suspicious
text		suspiciousFlag set by Scaleo fraud checks. Empty string when not suspicious.
Affiliate ID
int		affiliate_idAffiliate identifier. Extracted from affiliate.id.
Affiliate Value
text		affiliate_valueAffiliate display name. Extracted from affiliate.value.
Advertiser ID
int		advertiser_idAdvertiser identifier. Extracted from advertiser.id.
Advertiser Value
text		advertiser_valueAdvertiser display name. Extracted from advertiser.value.
Offer ID
int		offer_idOffer identifier. Extracted from offer.id.
Offer Value
text		offer_valueOffer display name. Extracted from offer.value.
Goal ID
int		goal_idGoal identifier. Extracted from goal.id.
Goal Value
text		goal_valueGoal display name. Extracted from goal.value.
Goal Parent ID
int		goal_parent_idParent offer ID for the goal. Extracted from goal.parent_id.
Goal Parent Value
text		goal_parent_valueParent offer name for the goal. Extracted from goal.parent_value.
Goal Type ID
int		goal_type_idGoal type identifier. Extracted from goal_type.id.
Goal Type Value
text		goal_type_valueGoal type name. Extracted from goal_type.value.
Link ID
int		link_idLink identifier. Extracted from link.id.
Link Value
text		link_valueLink display name. Extracted from link.value.
Link Parent ID
int		link_parent_idParent offer ID for the link. Extracted from link.parent_id.
Link Parent Value
text		link_parent_valueParent offer name for the link. Extracted from link.parent_value.
Creative ID
int		creative_idCreative identifier. Extracted from creative.id.
Creative Value
text		creative_valueCreative display name. Extracted from creative.value.
Creative Parent ID
int		creative_parent_idParent offer ID for the creative. Extracted from creative.parent_id.
Creative Parent Value
text		creative_parent_valueParent offer name for the creative. Extracted from creative.parent_value.
Device Type Code
text		device_type_typeDevice type code. Extracted from device_type.type.
Device Type Value
text		device_type_valueDevice type display name (e.g. smartphone). Extracted from device_type.value.
Geo Country Code
text		geo_country_codeISO country code. Extracted from geo.country_code.
Geo Country
text		geo_countryCountry name. Extracted from geo.country.
Geo Region
text		geo_regionRegion/state name. Extracted from geo.region.
Geo City
text		geo_cityCity name. Extracted from geo.city.
NameAPI nameDescription
Transaction ID
text		transaction_idUnique identifier of the click transaction.
Added Timestamp
datetime		added_timestampDate and time when the click was registered (tenant timezone).
Click ID
text		click_idInternal Scaleo click identifier.
Payout
text		payoutAffiliate payout amount as a string (e.g. '0.000000').
Profit
text		profitNetwork profit amount as a string.
Revenue
text		revenueAdvertiser revenue amount as a string.
Currency
text		currencyCurrency code for payout/profit/revenue (e.g. USD).
Sub ID 1
text		sub_id1Custom sub-ID value #1 passed from traffic source.
Sub ID 2
text		sub_id2Custom sub-ID value #2 passed from traffic source.
Sub ID 3
text		sub_id3Custom sub-ID value #3 passed from traffic source.
Sub ID 4
text		sub_id4Custom sub-ID value #4 passed from traffic source.
Sub ID 5
text		sub_id5Custom sub-ID value #5 passed from traffic source.
Aff Param 1
text		aff_param1Custom affiliate parameter #1.
Aff Param 2
text		aff_param2Custom affiliate parameter #2.
Aff Param 3
text		aff_param3Custom affiliate parameter #3.
Aff Param 4
text		aff_param4Custom affiliate parameter #4.
Aff Param 5
text		aff_param5Custom affiliate parameter #5.
Aff Click ID
text		aff_click_idExternal click identifier passed by the affiliate/traffic source.
Deep Link URL
text		deep_link_urlDeep link destination URL if used.
Click Referer URL
text		click_referer_urlHTTP referer URL recorded at click time.
Source
text		sourceTraffic source label, if configured.
Language
text		languageLanguage detected for the click.
Connection Type
text		connection_typeNetwork connection type (e.g. WiFi / Cable, Mobile Internet).
Mobile Operator
text		mobile_operatorMobile carrier if detected.
IDFA
text		idfaApple Identifier for Advertisers.
GAID
text		gaidGoogle Advertising ID.
IP
text		ipVisitor IP address recorded at click time.
Device Brand
text		device_brandDevice brand (e.g. Apple, Samsung).
Device Model
text		device_modelDevice model (e.g. iPhone).
Device OS
text		device_osOperating system name (e.g. iOS, Android).
Device OS Version
text		device_os_versionOperating system version string.
Browser
text		browserBrowser name (e.g. Mobile Safari).
Browser Version
text		browser_versionBrowser version string.
Suspicious
text		suspiciousFlag set by Scaleo fraud checks. Empty string when not suspicious.
Affiliate ID
int		affiliate_idAffiliate identifier. Extracted from affiliate.id.
Affiliate Value
text		affiliate_valueAffiliate display name. Extracted from affiliate.value.
Advertiser ID
int		advertiser_idAdvertiser identifier. Extracted from advertiser.id.
Advertiser Value
text		advertiser_valueAdvertiser display name. Extracted from advertiser.value.
Offer ID
int		offer_idOffer identifier. Extracted from offer.id.
Offer Value
text		offer_valueOffer display name. Extracted from offer.value.
Goal ID
int		goal_idGoal identifier. Extracted from goal.id.
Goal Value
text		goal_valueGoal display name. Extracted from goal.value.
Goal Parent ID
int		goal_parent_idParent offer ID for the goal. Extracted from goal.parent_id.
Goal Parent Value
text		goal_parent_valueParent offer name for the goal. Extracted from goal.parent_value.
Goal Type ID
int		goal_type_idGoal type identifier. Extracted from goal_type.id.
Goal Type Value
text		goal_type_valueGoal type name. Extracted from goal_type.value.
Link ID
int		link_idLink identifier. Extracted from link.id.
Link Value
text		link_valueLink display name. Extracted from link.value.
Link Parent ID
int		link_parent_idParent offer ID for the link. Extracted from link.parent_id.
Link Parent Value
text		link_parent_valueParent offer name for the link. Extracted from link.parent_value.
Creative ID
int		creative_idCreative identifier. Extracted from creative.id.
Creative Value
text		creative_valueCreative display name. Extracted from creative.value.
Creative Parent ID
int		creative_parent_idParent offer ID for the creative. Extracted from creative.parent_id.
Creative Parent Value
text		creative_parent_valueParent offer name for the creative. Extracted from creative.parent_value.
Device Type Code
text		device_type_typeDevice type code. Extracted from device_type.type.
Device Type Value
text		device_type_valueDevice type display name (e.g. smartphone). Extracted from device_type.value.
Geo Country Code
text		geo_country_codeISO country code. Extracted from geo.country_code.
Geo Country
text		geo_countryCountry name. Extracted from geo.country.
Geo Region
text		geo_regionRegion/state name. Extracted from geo.region.
Geo City
text		geo_cityCity name. Extracted from geo.city.

Under each field the picker shows the name of its future column in the destination table. Select All checks the whole list at once, and the Selected tab keeps everything you have already picked.

Scaleo returns monetary values as strings, so Payout, Profit, Revenue, and the invoice amounts load into text columns. Cast them to a numeric type in SQL when you build reports.

In the Invoices report, Offers and Goal Types load as nested arrays of ID and title pairs, and Payment Method Metadata loads as a JSON column.

Include Added Timestamp in Clicks and Conversions and Date in Invoices. With this field the destination table is partitioned by day and Renta loads data incrementally. Without it, Renta reloads the whole date range on every run.

Table name

Name the pipeline and the destination table.

Scaleo integration name and table name fields
  1. Integration name.
    The name of the pipeline. It is used exclusively in the Renta interface.
  2. Table name.
    The destination table name. You can keep the auto-generated name or enter your own.

Date range

Set the historical period to load.

Scaleo date range with date start and date end
  1. Date start.
    The first date of the extraction period.
  2. Date end.
    The last date of the extraction period. Leave it as Today to keep collecting new data on every run.

For Clicks and Conversions the range covers the moment the transaction was registered. For Invoices it covers the invoice date. Scaleo interprets the dates in the time zone configured for your network.

Schedule

Choose how often the pipeline runs.

Scaleo schedule type selection with the Daily option checked
Schedule typeDescription
ManualThe pipeline runs only when triggered manually through the interface or via API.
DailyThe pipeline runs once a day at the specified update time.
IntervalThe pipeline runs at specified time intervals.
Cron ExpressionThe pipeline runs on a schedule defined by a cron expression.

For Daily schedules, set the Update time, the exact time each run starts, then click Create pipeline.

Update time selection and the Create pipeline button

Renta also supports API triggers and integration with external orchestrators such as Apache Airflow, Dagster, and Prefect. See the full scheduling documentation for details.

The new pipeline appears in the Pipelines section under the ETL tab, where you can track its runs, progress, and the destination table name.

Pipelines list with the new Scaleo integration

Sync strategy

The synchronization strategy depends on whether the report includes its date field.

StrategySupported report typesDescription
IncrementalClicks (with Added Timestamp selected), Conversions (with Added Timestamp selected), Invoices (with Date selected)The destination table is partitioned by the day of added_timestamp (date for Invoices). On every run Renta re-requests the report from the day of the last successful run to the end of the date range and replaces those daily partitions. Older partitions stay untouched.
Full reloadClicks (without Added Timestamp), Conversions (without Added Timestamp), Invoices (without Date)The table has no date column to partition by, so Renta requests the whole configured date range and replaces the dataset on every run.

Changing the selected parameters updates the table schema, so the next run after the change reloads the entire date range.

Frequently asked questions

Ready to get started?

Build your data pipeline today or get a personalized demo. Start free!

Need help?

Get expert support to ensure your project succeeds. We're here to help!

Feature requests?

Help shape our product! Share your ideas for new features and integrations.