# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the Outbrain v2 connector:

* [Conversion\_Events](#conversion_events)
* [Budget\_for\_Marketer](#budget_for_marketer)
* [Campaign\_associated\_marketer](#campaign_associated_marketer)
* [Performance\_report\_periodic](#performance_report_periodic)
* [Platform](#platform)
* [Geo\_campaign](#geo_campaign)
* [Geo](#geo)
* [Performance\_Interest](#performance_interest)
* [Platform\_by\_campaign](#platform_by_campaign)
* [Engagement\_Metrics](#engagement_metrics)
* [Publishers\_by\_campaign](#publishers_by_campaign)
* [IABCategories](#iabcategories)
* [Currencies](#currencies)
* [Segments\_by\_campaign](#segments_by_campaign)
* [Performance\_report\_campaign](#performance_report_campaign)
* [Sections](#sections)
* [Sections\_by\_campaign](#sections_by_campaign)
* [Users\_permitted\_to\_marketer](#users_permitted_to_marketer)

#### **Conversion\_Events**

Purpose: Retrieve all Conversion Events associated with the current Marketer. For more information, see [conversion events](https://amplifyv01.docs.apiary.io/#reference/multiple-conversions/conversion-event-collection/retrieve-all-marketer's-conversion-events)

**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. For more information, see [budget for marketer](https://amplifyv01.docs.apiary.io/#reference/budgets/budgets-collection/list-budgets-for-a-marketer)

**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  |

#### **Campaign\_associated\_marketer**

Purpose: Collection of all campaigns for a specific Marketer. For more information, see [campaign associated marketer](https://amplifyv01.docs.apiary.io/#reference/campaigns/campaigns-collection/retrieve-multiple-campaigns)

**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. For more information, see [performance report periodic](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/promoted-content/retrieve-periodic-performance-statistics-for-a-marketer)

**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. For more information, see [platform](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/platforms/retrieve-performance-statistics-for-a-marketer-by-platform)

**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. For more information, see [Geo campaign](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/geo-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-geo)

**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. For more information, see [Geo](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/geo/retrieve-geo-performance-statistics-for-a-marketer)

**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\_Interest**

Purpose: Retrieving performance statistics by interest at different levels: marketer and campaign. For more information, see [performance Interest](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/interests/retrieve-performance-statistics-for-a-marketer-by-interest)

**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. For more information, see [platform by campaign ](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/platforms-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-platform)

**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. For more information, see [engagement metrics](https://amplifyv01.docs.apiary.io/#reference/multiple-conversions/conversion-event-collection/retrieve-marketer's-engagement-metrics)

**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. For more information, see [publishers by campaign](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/publishers-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-publisher)

**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. For more information, see I[ABCategories](https://amplifyv01.docs.apiary.io/#reference/iab-category-targeting/retrieve-all-available-iab-categories/retrieve-all-available-iab-categories)

**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. For more information, see [currencies](https://amplifyv01.docs.apiary.io/#reference/currencies/currencies-collection/list-currencies)

**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. For more information, see [sections by campaign](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-section)

#### **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. For more information, see [Performance report campaign](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/periodic-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-periodic-breakdown)

**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. For more information, see [sections](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections/retrieve-performance-statistics-for-a-marketer-by-section)

**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. For more information, [sections by campaign](https://amplifyv01.docs.apiary.io/#reference/performance-reporting/sections-by-campaign/retrieve-performance-statistics-for-all-marketer-campaigns-by-section) 

**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. For more information, see [users permitted to marketer](https://amplifyv01.docs.apiary.io/#reference/users/getting-all-users-permitted-to-a-marketer)

**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 |