MNTN

MNTN ETL connector for data replication

Pulse
Daton

Need help with something?

Talk to data expert

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

Generate MNTN API Key for Daton
The key can be retrieved from Account Settings page of the MNTN user interface

Integrate MNTN with Daton

Signin to Daton
Select MNTN from Integrations page
Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide API Key and Site Name to authorize Daton to periodically extract data from MNTN
Post successful authentication, you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration

Workflow

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

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

Field

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

Table of Contents

Snapshot Pre-requisites Integrate MNTN with Daton Workflow MNTN Data Advertiser AdvertiserInfo CampaignGroup CampaignGroupInfo Channel City Country State

MNTN

Pulse

Daton

MNTN