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:
An active Outbrain account.
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
Sign in to Daton.
Select Outbrain from the Integrations page.
Provide Integration Name, Replication Frequency, and History. The integration name would be used in creating tables for the integration and cannot be changed later.
Provide Outbrain Username and Password corresponding to your Outbrain account. Follow this link to learn.
Note: Outbrain authentication is limited to once per hour
Post successful authentication, you will be prompted to choose from the list of available accounts and tables.
Then select all required fields for each table.
Submit the integration.
Workflow
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
Users would be able to edit/pause/re-activate/delete integration anytime
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 |
STRING | |
creationtime | STRING |
status | STRING |
fullname | STRING |
role | STRING |
_daton_user_id | NUMERIC |
_daton_batch_runtime | NUMERIC |
_daton_batch_id | NUMERIC |
Last updated