MNTN

MNTN 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

MNTN API Key

Replication Type

Key Based Replication

Replication Key

Date

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

Advertiser

AdvertiserInfo

CampaignGroup

CampaignGroupInfo

Channel

City

Country

State

Pre-requisites

  1. Generate MNTN API Key for Daton

  2. The key can be retrieved from Account Settings page of the MNTN user interface

Integrate MNTN with Daton

  1. Signin to Daton

  2. Select MNTN from Integrations page

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

  4. Provide API Key and Site Name to authorize Daton to periodically extract data from MNTN

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

  6. Then select all required fields for each table

  7. Submit the integration

Workflow

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

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

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

MNTN Data

Source API Documentation

https://mntn-help.zendesk.com/hc/en-us/article_attachments/4408236364301/MNTN_R2API_Guide.pdf

Replication: Key-Based Replication

Advertiser

Fields

Field name
Target Datatype

AverageOrderValue

STRING

AveragePageViewsPerVisitor

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionAttributionPercentage

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerCompletedView

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ID

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

OrderValueAttributionPercentage

STRING

PageViews

STRING

PercentageOfConversions

STRING

PercentageOfOrderValue

STRING

RawAverageOrderValue

STRING

RawConversionRate

STRING

RawConversions

STRING

RawOrderValue

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

AdvertiserInfo

Fields

Field name
Target Datatype

Active

STRING

Address1

STRING

Address2

STRING

City

STRING

ContactEmail

STRING

ContactFirstName

STRING

ContactLastName

STRING

ContactMobilePhone

STRING

ContactOfficePhone

STRING

CreateTime

STRING

Currency

STRING

ID

STRING

Name

STRING

PostalCode

STRING

State

STRING

TimeZone

STRING

Zip

STRING

CampaignGroup

Fields

Field name
Target Datatype

AverageOrderValue

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerCompletedView

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ID

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

CampaignGroupInfo

Fields

Field Name
Target Datatype

Description

STRING

EndTime

STRING

ID

STRING

Name

STRING

StartTime

STRING

Channel

Fields

Field Name
Target Datatype

AverageOrderValue

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerCompletedView

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ID

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

City

Fields

Field name
Target Datatype

AverageOrderValue

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UniqueCode

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

Country

Fields

Field name
Target Datatype

AverageOrderValue

STRING

Code

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UniqueCode

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

State

Fields

Field name
Target Datatype

Type

Mode

AverageOrderValue

STRING

Code

STRING

CompletedViewRate

STRING

CompletedViews

STRING

ConversionRate

STRING

Conversions

STRING

CostPerAcquisition

STRING

CostPerVisit

STRING

CPA

STRING

Day

STRING

ExistingSiteVisitors

STRING

Frequency

STRING

ImpressionConversionRate

STRING

Impressions

STRING

ImpressionVisitRate

STRING

Name

STRING

NewSiteVisitors

STRING

OrderValue

STRING

ParentCode

STRING

ReturnOnAdSpend

STRING

ReturnOnInvestment

STRING

ROAS

STRING

ROI

STRING

SiteVisitors

STRING

Spend

STRING

UniqueCode

STRING

UserConversionRate

STRING

UsersReached

STRING

UserVisitRate

STRING

ViewableImpressionRate

STRING

ViewableImpressions

STRING

VisitConversionRate

STRING

VisitRate

STRING

Visits

STRING

Last updated

#551: Template

Change request updated