Outbrain V2 (Old)

Outbrain ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Outbrain Username Password

Replication Type

Key Based Incremental

Replication Key

NA LastRunTime

Tables/APIs Supported

Conversion_Events

Budget_for_marketer

Campaigns_associated_with_marketer

Performance_report_periodic

Platform

Geo_campaign

Geo

Performance_interests

Platform_by_campaign

Engagement_Metrics

Publishers_by_campaigns

IABCategories

Currencies

Segments_by_campaign

Performance_report_campaign

Sections

Users_permitted_to_marketer

Sections_by_campaign

Stepwise Manual

Prerequisites:

  1. An active Outbrain account.

  2. API access enabled on your account. (If API access is not enabled, fill out the Outbrain API access form and wait for a confirmation email.)

Integrate Outbrain with Daton

  1. Sign in to Daton.

  2. Select Outbrain from the Integrations page.

  3. Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.

  4. Provide Outbrain Username and Password corresponding to your Outbrain account. Follow this link to learn.

Note: Outbrain authentication is limited to once per hour

  1. Post successful authentication, you will be prompted to choose from the list of available accounts and tables.

  2. Then select all required fields for each table.

  3. Submit the integration.

Workflow

  1. Integrations would be in the Pending state initially and will be moved to the Active state as soon as the first job loads data successfully onto the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Outbrain Data

Conversion_Events

Purpose: Retrieve all Conversion Events associated with the current Marketer.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/multiple-conversions/conversion-event-collection/retrieve-all-marketer's-conversion-events

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

categoryid

STRING

categoryname

STRING

children

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

subConcepts

RECORD

id

STRING

name

STRING

canBeTargeted

BOOLEAN

reachEstimationCount

NUMERIC

children.categoryid

STRING

children.categoryname

STRING

children.parentid

STRING

children.pageviews

NUMERIC

subConcepts.id

STRING

subConcepts.name

STRING

subConcepts.canBeTargeted

BOOLEAN

subConcepts.reachEstimationCount

NUMERIC

Budget_for_Marketer

Purpose: Retrieve a collection of all Budgets for the specified Marketer

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/budgets/budgets-collection/list-budgets-for-a-marketer

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

id

STRING

name

STRING

shared

BOOLEAN

amount

NUMERIC

currency

STRING

amountRemaining

NUMERIC

amountSpent

NUMERIC

creationTime

DATETIME

lastModified

DATETIME

startDate

DATE

runForever

BOOLEAN

type

STRING

pacing

STRING

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Campaigns_associated_with_marketer

Purpose: Collection of all campaigns for a specific Marketer

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/campaigns/campaigns-collection/retrieve-multiple-campaigns

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

id

STRING

name

STRING

enabled

BOOLEAN

creationtime

DATETIME

lastmodified

DATETIME

cpc

NUMERIC

autoarchived

BOOLEAN

minimumcpc

NUMERIC

currency

STRING

targeting

RECORD

marketerid

STRING

contenttype

STRING

budget

RECORD

suffixtrackingcode

STRING

livestatus

RECORD

readonly

BOOLEAN

starthour

STRING

trackingpixels

RECORD

pixels

RECORD

onairtype

STRING

objective

STRING

creativeformat

STRING

dynamicretargeting

BOOLEAN

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

targeting.platform

STRING

targeting.language

STRING

targeting.excludeadblockusers

BOOLEAN

targeting.nativeplacements

RECORD

targeting.nativeplacements.enabled

BOOLEAN

targeting.includecellularnetwork

BOOLEAN

targeting.nativeplacementsenabled

BOOLEAN

targeting.locationsversion

STRING

budget.id

STRING

budget.name

STRING

budget.shared

BOOLEAN

budget.amount

NUMERIC

budget.currency

STRING

budget.creationtime

DATETIME

budget.lastmodified

DATETIME

budget.startdate

DATE

budget.runforever

BOOLEAN

budget.type

STRING

budget.pacing

STRING

livestatus.onairreason

STRING

livestatus.campaignonair

BOOLEAN

livestatus.amountspent

NUMERIC

livestatus.onairmodificationtime

DATETIME

trackingpixels.enabled

BOOLEAN

trackingpixels.urls

STRING

pixels.trackingpixels

STRING

Performance_report_periodic

Purpose: Retrieve performance statistics by periodic breakdown

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/promoted-content/retrieve-periodic-performance-statistics-for-a-marketer

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

metadata

RECORD

metrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata.id

DATE

metadata.fromdate

DATE

metadata.todate

DATE

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalconversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewconversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionrate

NUMERIC

metrics.viewconversionrate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalcpa

NUMERIC

metrics.totalsumvalue

NUMERIC

metrics.sumvalue

NUMERIC

metrics.viewsumvalue

NUMERIC

metrics.totalaveragevalue

NUMERIC

metrics.averagevalue

NUMERIC

metrics.viewaveragevalue

NUMERIC

metrics.totalroas

NUMERIC

metrics.roas

NUMERIC

metrics.conversionMetrics

RECORD

metrics.conversionMetrics.name

STRING

metrics.conversionMetrics.totalConversions

NUMERIC

metrics.conversionMetrics.conversions

NUMERIC

metrics.conversionMetrics.viewConversions

NUMERIC

metrics.conversionMetrics.conversionRate

NUMERIC

metrics.conversionMetrics.viewConversionRate

NUMERIC

metrics.conversionMetrics.totalCpa

NUMERIC

metrics.conversionMetrics.cpa

NUMERIC

metrics.conversionMetrics.totalSumValue

NUMERIC

metrics.conversionMetrics.sumValue

NUMERIC

metrics.conversionMetrics.viewSumValue

NUMERIC

metrics.conversionMetrics.totalAverageValue

NUMERIC

metrics.conversionMetrics.averageValue

NUMERIC

metrics.conversionMetrics.viewAverageValue

NUMERIC

metrics.conversionMetrics.totalRoas

NUMERIC

metrics.conversionMetrics.roas

NUMERIC

Platform

Purpose: Retrieve performance statistics by platform at different levels

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/platforms/retrieve-performance-statistics-for-a-marketer-by-platform

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

metadata

RECORD

metrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata.platform

STRING

metadata.breakdown

STRING

metadata.name

STRING

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalconversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewconversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionrate

NUMERIC

metrics.viewconversionrate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalcpa

NUMERIC

metrics.totalvalue

NUMERIC

metrics.totalsumvalue

NUMERIC

metrics.sumvalue

NUMERIC

metrics.viewsumvalue

NUMERIC

metrics.totalaveragevalue

NUMERIC

metrics.averagevalue

NUMERIC

metrics.viewaveragevalue

NUMERIC

metrics.roas

NUMERIC

metrics.totalroas

NUMERIC

Geo_Campaign

Purpose: Retrieving geo data by campaign breakdown.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/geo-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-geo

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

campaignid

STRING

results

RECORD

totalresults

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

results.metadata

RECORD

results.metadata.id

STRING

results.metadata.name

STRING

results.metadata.code

STRING

results.metrics

RECORD

results.metrics.impressions

NUMERIC

results.metrics.clicks

NUMERIC

results.metrics.totalconversions

NUMERIC

results.metrics.conversions

NUMERIC

results.metrics.viewconversions

NUMERIC

results.metrics.spend

NUMERIC

results.metrics.ecpc

NUMERIC

results.metrics.ctr

NUMERIC

results.metrics.conversionrate

NUMERIC

results.metrics.viewconversionrate

NUMERIC

results.metrics.cpa

NUMERIC

results.metrics.totalcpa

NUMERIC

results.metrics.totalvalue

NUMERIC

results.metrics.totalsumvalue

NUMERIC

results.metrics.sumvalue

NUMERIC

results.metrics.viewsumvalue

NUMERIC

results.metrics.totalaveragevalue

NUMERIC

results.metrics.averagevalue

NUMERIC

results.metrics.viewaveragevalue

NUMERIC

results.metrics.roas

NUMERIC

results.metrics.totalroas

NUMERIC

Geo

Purpose: Retrieving performance statistics by geographic breakdown

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/geo/retrieve-geo-performance-statistics-for-a-marketer

Replication: Key-Based Replication

Replication Key: LastRunTIme

Fields

fullnametype

metadata

RECORD

metrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata.id

STRING

metadata.name

STRING

metadata.code

STRING

metadata.countryid

STRING

metadata.countryname

STRING

metadata.countrycode

STRING

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalconversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewconversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionrate

NUMERIC

metrics.viewconversionrate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalcpa

NUMERIC

metrics.totalvalue

NUMERIC

metrics.totalsumvalue

NUMERIC

metrics.sumvalue

NUMERIC

metrics.viewsumvalue

NUMERIC

metrics.totalaveragevalue

NUMERIC

metrics.averagevalue

NUMERIC

metrics.viewaveragevalue

NUMERIC

metrics.roas

NUMERIC

metrics.totalroas

NUMERIC

metrics.conversionmetrics

RECORD

metrics.conversionmetrics.name

STRING

metrics.conversionmetrics.totalconversions

NUMERIC

metrics.conversionmetrics.conversions

NUMERIC

metrics.conversionmetrics.viewconversions

NUMERIC

metrics.conversionmetrics.conversionrate

NUMERIC

metrics.conversionmetrics.viewconversionrate

NUMERIC

metrics.conversionmetrics.totalcpa

NUMERIC

metrics.conversionmetrics.cpa

NUMERIC

metrics.conversionmetrics.totalvalue

NUMERIC

metrics.conversionmetrics.totalsumvalue

NUMERIC

metrics.conversionmetrics.sumvalue

NUMERIC

metrics.conversionmetrics.viewsumvalue

NUMERIC

metrics.conversionmetrics.totalaveragevalue

NUMERIC

metrics.conversionmetrics.averagevalue

NUMERIC

metrics.conversionmetrics.viewaveragevalue

NUMERIC

metrics.conversionmetrics.roas

NUMERIC

metrics.conversionmetrics.totalroas

NUMERIC

Performance_Interests

Purpose: Retrieving performance statistics by interest at different levels: marketer and campaign.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/interests/retrieve-performance-statistics-for-a-marketer-by-interest

Replication: Key-Based Replication

Replication Key: LastRunTIme

Fields

fullnametype

metadata

RECORD

metrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata.id

STRING

metadata.name

STRING

metadata.targetingstatus

STRING

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalconversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewconversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionrate

NUMERIC

metrics.viewconversionrate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalcpa

NUMERIC

metrics.totalsumvalue

NUMERIC

metrics.sumvalue

NUMERIC

metrics.viewsumvalue

NUMERIC

metrics.totalaveragevalue

NUMERIC

metrics.averagevalue

NUMERIC

metrics.viewaveragevalue

NUMERIC

metrics.roas

NUMERIC

metrics.totalroas

NUMERIC

Platform_by_campaign

Purpose: Retrieving platforms data by campaign breakdown.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/platforms-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-platform

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

campaignid

STRING

results

RECORD

totalresults

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

results.metadata

RECORD

results.metadata.platform

STRING

results.metadata.breakdown

STRING

results.metrics

RECORD

results.metrics.impressions

NUMERIC

results.metrics.clicks

NUMERIC

results.metrics.totalconversions

NUMERIC

results.metrics.conversions

NUMERIC

results.metrics.viewconversions

NUMERIC

results.metrics.spend

BIGNUMERIC

results.metrics.ecpc

NUMERIC

results.metrics.ctr

NUMERIC

results.metrics.conversionrate

NUMERIC

results.metrics.viewconversionrate

NUMERIC

results.metrics.cpa

NUMERIC

results.metrics.totalcpa

NUMERIC

results.metrics.totalvalue

NUMERIC

results.metrics.totalsumvalue

NUMERIC

results.metrics.sumvalue

NUMERIC

results.metrics.viewsumvalue

NUMERIC

results.metrics.totalaveragevalue

NUMERIC

results.metrics.averagevalue

NUMERIC

results.metrics.viewaveragevalue

NUMERIC

results.metrics.roas

NUMERIC

results.metrics.totalroas

NUMERIC

results.metrics.spend_nu

NUMERIC

Engagement_Metrics

Purpose: Retrieve all Engagement Metrics avaialable for associated with the Marketer

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/multiple-conversions/conversion-event-collection/retrieve-marketer's-engagement-metrics

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

id

STRING

name

STRING

type

STRING

marketerid

STRING

enabled

BOOLEAN

conversionwindow

NUMERIC

includeinconversions

BOOLEAN

trackingstatus

STRING

category

STRING

description

STRING

isvaluable

BOOLEAN

creationtime

DATETIME

lastmodified

DATETIME

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Publishers_by_campaign

Purpose: Retrieving publishers data by campaign breakdown

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/publishers-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-publisher

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

campaignid

STRING

results

RECORD

totalresults

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

results.metadata

RECORD

results.metadata.id

STRING

results.metadata.name

STRING

results.metadata.url

STRING

results.metrics

RECORD

results.metrics.impressions

NUMERIC

results.metrics.clicks

NUMERIC

results.metrics.totalconversions

NUMERIC

results.metrics.conversions

NUMERIC

results.metrics.viewconversions

NUMERIC

results.metrics.spend

NUMERIC

results.metrics.ecpc

NUMERIC

results.metrics.ctr

NUMERIC

results.metrics.conversionrate

NUMERIC

results.metrics.viewconversionrate

NUMERIC

results.metrics.cpa

NUMERIC

results.metrics.totalcpa

NUMERIC

results.metrics.totalsumvalue

NUMERIC

results.metrics.sumvalue

NUMERIC

results.metrics.viewsumvalue

NUMERIC

results.metrics.totalaveragevalue

NUMERIC

results.metrics.averagevalue

NUMERIC

results.metrics.viewaveragevalue

NUMERIC

results.metrics.totalroas

NUMERIC

results.metrics.roas

NUMERIC

IABCategories

Purpose: Returns all available IAB categories.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/iab-category-targeting/retrieve-all-available-iab-categories/retrieve-all-available-iab-categories

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

categoryid

STRING

categoryname

STRING

children

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

subConcepts

RECORD

id

STRING

name

STRING

canBeTargeted

BOOLEAN

reachEstimationCount

NUMERIC

children.categoryid

STRING

children.categoryname

STRING

children.parentid

STRING

children.pageviews

NUMERIC

subConcepts.id

STRING

subConcepts.name

STRING

subConcepts.canBeTargeted

BOOLEAN

subConcepts.reachEstimationCount

NUMERIC

Currencies

Purpose: Returns metadata about available currencies

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/currencies/currencies-collection/list-currencies

Replication: Key-Based Replication

Replication Key: NA

Fields

fullnametype

code

STRING

sign

STRING

name

STRING

minimumcpc

NUMERIC

maximumcpc

NUMERIC

nativeplacementmincpc

NUMERIC

carouselsequencemincpc

NUMERIC

appinstallsequencemincpc

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

Segments_by_campaign

Purpose: Retrieving sections data by campaign breakdown

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-section

Replication: Key-Based Replication

Replication Key: LastRunTIme

Fields

fullnametype

campaignid

STRING

results

RECORD

totalresults

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

results.metadata

RECORD

results.metadata.id

STRING

results.metadata.name

STRING

results.metadata.publisherid

STRING

results.metadata.publishername

STRING

results.metadata.url

STRING

results.metadata.publisherurl

STRING

results.metadata.isoen

BOOLEAN

results.metrics

RECORD

results.metrics.impressions

NUMERIC

results.metrics.clicks

NUMERIC

results.metrics.totalconversions

NUMERIC

results.metrics.conversions

NUMERIC

results.metrics.viewconversions

NUMERIC

results.metrics.spend

NUMERIC

results.metrics.ecpc

NUMERIC

results.metrics.ctr

NUMERIC

results.metrics.conversionrate

NUMERIC

results.metrics.viewconversionrate

NUMERIC

results.metrics.cpa

NUMERIC

results.metrics.totalcpa

NUMERIC

results.metrics.totalvalue

NUMERIC

results.metrics.totalsumvalue

NUMERIC

results.metrics.sumvalue

NUMERIC

results.metrics.viewsumvalue

NUMERIC

results.metrics.totalaveragevalue

NUMERIC

results.metrics.averagevalue

NUMERIC

results.metrics.viewaveragevalue

NUMERIC

results.metrics.roas

NUMERIC

results.metrics.totalroas

NUMERIC

results.metrics.conversionmetrics

RECORD

results.metrics.conversionmetrics.name

STRING

results.metrics.conversionmetrics.totalconversions

NUMERIC

results.metrics.conversionmetrics.conversions

NUMERIC

results.metrics.conversionmetrics.viewconversions

NUMERIC

results.metrics.conversionmetrics.conversionrate

NUMERIC

results.metrics.conversionmetrics.viewconversionrate

NUMERIC

results.metrics.conversionmetrics.totalcpa

NUMERIC

results.metrics.conversionmetrics.cpa

NUMERIC

results.metrics.conversionmetrics.totalvalue

NUMERIC

results.metrics.conversionmetrics.totalsumvalue

NUMERIC

results.metrics.conversionmetrics.sumvalue

NUMERIC

results.metrics.conversionmetrics.viewsumvalue

NUMERIC

results.metrics.conversionmetrics.totalaveragevalue

NUMERIC

results.metrics.conversionmetrics.averagevalue

NUMERIC

results.metrics.conversionmetrics.viewaveragevalue

NUMERIC

results.metrics.conversionmetrics.roas

NUMERIC

results.metrics.conversionmetrics.totalroas

NUMERIC

Performance_report_campaign

Purpose: Retrieves periodic data by campaign breakdown.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/periodic-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-periodic-breakdown

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

id

STRING

name

STRING

marketerid

STRING

segmenttype

STRING

enabled

BOOLEAN

trackingstatus

STRING

conversion

RECORD

creationtime

STRING

lastmodified

STRING

membershipduration

NUMERIC

size

NUMERIC

archived

BOOLEAN

availability

RECORD

effectivesize

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata

RECORD

metrics

RECORD

conversion.id

STRING

availability.status

STRING

metadata.budget

RECORD

metadata.budget.id

STRING

metadata.budget.shared

BOOLEAN

metadata.budget.amount

NUMERIC

metadata.budget.currency

STRING

metadata.budget.startDate

DATE

metadata.budget.endDate

STRING

metadata.budget.type

STRING

metadata.budget.pacing

STRING

metadata.id

STRING

metadata.name

STRING

metadata.campaignOnAir

BOOLEAN

metadata.onAirReason

STRING

metadata.enabled

BOOLEAN

metadata.isVideo

BOOLEAN

metadata.cpc

NUMERIC

metadata.targetedSegments

NUMERIC

metadata.optimizationExperimentStatus

STRING

metadata.creativeFormat

STRING

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalConversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewConversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionRate

NUMERIC

metrics.viewConversionRate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalCpa

NUMERIC

metrics.totalSumValue

NUMERIC

metrics.sumValue

NUMERIC

metrics.viewSumValue

NUMERIC

metrics.totalAverageValue

NUMERIC

metrics.averageValue

NUMERIC

metrics.viewAverageValue

NUMERIC

metrics.totalRoas

NUMERIC

metrics.roas

NUMERIC

Sections

Purpose: Returns marketer performance statistics with breakdown by section

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections/retrieve-performance-statistics-for-a-marketer-by-section

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

metadata

RECORD

metrics

RECORD

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

metadata.id

STRING

metadata.name

STRING

metadata.targetingstatus

STRING

metadata.blockTypes

RECORD

metadata.blockTypes.marketerPublisher

BOOLEAN

metadata.blockTypes.marketerSection

BOOLEAN

metadata.blockTypes.campaignPublisher

BOOLEAN

metadata.blockTypes.campaignSection

BOOLEAN

metadata.publisherId

STRING

metadata.publisherName

STRING

metadata.url

STRING

metadata.blockStatus

STRING

metadata.publisherUrl

STRING

metrics.impressions

NUMERIC

metrics.clicks

NUMERIC

metrics.totalconversions

NUMERIC

metrics.conversions

NUMERIC

metrics.viewconversions

NUMERIC

metrics.spend

NUMERIC

metrics.ecpc

NUMERIC

metrics.ctr

NUMERIC

metrics.conversionrate

NUMERIC

metrics.viewconversionrate

NUMERIC

metrics.cpa

NUMERIC

metrics.totalcpa

NUMERIC

metrics.totalsumvalue

NUMERIC

metrics.sumvalue

NUMERIC

metrics.viewsumvalue

NUMERIC

metrics.totalaveragevalue

NUMERIC

metrics.averagevalue

NUMERIC

metrics.viewaveragevalue

NUMERIC

metrics.roas

NUMERIC

metrics.totalroas

NUMERIC

Sections_by_campaign

Purpose: Returns sections data by campaign breakdown.

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-section

Replication: Key-Based Replication

Replication Key: LastRunTime

Fields

fullnametype

campaignid

STRING

results

RECORD

totalresults

NUMERIC

_daton_user_id

NUMERIC

_daton_batch_runtime

NUMERIC

_daton_batch_id

NUMERIC

results.metadata

RECORD

results.metadata.id

STRING

results.metadata.name

STRING

results.metadata.publisherid

STRING

results.metadata.publishername

STRING

results.metadata.url

STRING

results.metadata.publisherurl

STRING

results.metadata.isoen

BOOLEAN

results.metrics

RECORD

results.metrics.impressions

NUMERIC

results.metrics.clicks

NUMERIC

results.metrics.totalconversions

NUMERIC

results.metrics.conversions

NUMERIC

results.metrics.viewconversions

NUMERIC

results.metrics.spend

NUMERIC

results.metrics.ecpc

NUMERIC

results.metrics.ctr

NUMERIC

results.metrics.conversionrate

NUMERIC

results.metrics.viewconversionrate

NUMERIC

results.metrics.cpa

NUMERIC

results.metrics.totalcpa

NUMERIC

results.metrics.totalvalue

NUMERIC

results.metrics.totalsumvalue

NUMERIC

results.metrics.sumvalue

NUMERIC

results.metrics.viewsumvalue

NUMERIC

results.metrics.totalaveragevalue

NUMERIC

results.metrics.averagevalue

NUMERIC

results.metrics.viewaveragevalue