Outbrain V2 (Old)
Outbrain ETL connector for data replication
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 |
email |
STRING |
creationtime |
STRING |
status |
STRING |
fullname |
STRING |
role |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |