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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

fullname	type
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

Users_permitted_to_marketer

Purpose: Returns list of all users permitted to a marketer

Source API Documentation: https://amplifyv01.docs.apiary.io/#reference/users/getting-all-users-permitted-to-a-marketer

Replication: Key-Based Replication

Replication Key: NA

Fields

fullname	type
name	STRING
email	STRING
creationtime	STRING
status	STRING
fullname	STRING
role	STRING
_daton_user_id	NUMERIC
_daton_batch_runtime	NUMERIC
_daton_batch_id	NUMERIC