# MNTN ### ### 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 Replication: Key-Based Replication ### Advertiser **Fields**

Field name	Target Datatype
AverageOrderValue	STRING
AveragePageViewsPerVisitor	STRING	NULLABLE	UNSELECTED
CompletedViewRate	STRING	NULLABLE	UNSELECTED
CompletedViews	STRING	NULLABLE
ConversionAttributionPercentage	STRING	NULLABLE
ConversionRate	STRING	NULLABLE
Conversions	STRING	NULLABLE
CostPerAcquisition	STRING	NULLABLE
CostPerCompletedView	STRING	NULLABLE
CostPerVisit	STRING	NULLABLE
CPA	STRING	NULLABLE
Day	STRING	NULLABLE
ExistingSiteVisitors	STRING	NULLABLE
Frequency	STRING	NULLABLE
ID	STRING	NULLABLE
ImpressionConversionRate	STRING	NULLABLE
Impressions	STRING	NULLABLE
ImpressionVisitRate	STRING	NULLABLE
Name	STRING	NULLABLE
NewSiteVisitors	STRING	NULLABLE
OrderValue	STRING	NULLABLE
OrderValueAttributionPercentage	STRING	NULLABLE
PageViews	STRING	NULLABLE
PercentageOfConversions	STRING	NULLABLE
PercentageOfOrderValue	STRING	NULLABLE
RawAverageOrderValue	STRING	NULLABLE
RawConversionRate	STRING	NULLABLE
RawConversions	STRING	NULLABLE
RawOrderValue	STRING	NULLABLE
ReturnOnAdSpend	STRING	NULLABLE
ReturnOnInvestment	STRING	NULLABLE
ROAS	STRING	NULLABLE
ROI	STRING	NULLABLE
SiteVisitors	STRING	NULLABLE
Spend	STRING	NULLABLE
UserConversionRate	STRING	NULLABLE
UsersReached	STRING	NULLABLE
UserVisitRate	STRING	NULLABLE
ViewableImpressionRate	STRING	NULLABLE
ViewableImpressions	STRING	NULLABLE
VisitConversionRate	STRING	NULLABLE
VisitRate	STRING	NULLABLE
Visits	STRING	NULLABLE

### AdvertiserInfo **Fields**

Field name	Target Datatype
Active	STRING	Active
Address1	STRING		NULLABLE
Address2	STRING		NULLABLE
City	STRING		NULLABLE
ContactEmail	STRING		NULLABLE
ContactFirstName	STRING		NULLABLE
ContactLastName	STRING		NULLABLE
ContactMobilePhone	STRING		NULLABLE
ContactOfficePhone	STRING		NULLABLE
CreateTime	STRING		NULLABLE
Currency	STRING		NULLABLE
ID	STRING		NULLABLE
Name	STRING		NULLABLE
PostalCode	STRING		NULLABLE
State	STRING		NULLABLE
TimeZone	STRING		NULLABLE
Zip	STRING		NULLABLE

### CampaignGroup **Fields**

Field name	Target Datatype
AverageOrderValue	STRING	AverageOrderValue
CompletedViewRate	STRING		NULLABLE
CompletedViews	STRING		NULLABLE
ConversionRate	STRING		NULLABLE
Conversions	STRING		NULLABLE
CostPerAcquisition	STRING		NULLABLE
CostPerCompletedView	STRING		NULLABLE
CostPerVisit	STRING		NULLABLE
CPA	STRING		NULLABLE
Day	STRING		NULLABLE
ExistingSiteVisitors	STRING		NULLABLE
Frequency	STRING		NULLABLE
ID	STRING		NULLABLE
ImpressionConversionRate	STRING		NULLABLE
Impressions	STRING		NULLABLE
ImpressionVisitRate	STRING		NULLABLE
Name	STRING		NULLABLE
NewSiteVisitors	STRING		NULLABLE
OrderValue	STRING		NULLABLE
ReturnOnAdSpend	STRING		NULLABLE
ReturnOnInvestment	STRING		NULLABLE
ROAS	STRING		NULLABLE
ROI	STRING		NULLABLE
SiteVisitors	STRING		NULLABLE
Spend	STRING		NULLABLE
UserConversionRate	STRING		NULLABLE
UsersReached	STRING		NULLABLE
UserVisitRate	STRING		NULLABLE
ViewableImpressionRate	STRING		NULLABLE
ViewableImpressions	STRING		NULLABLE
VisitConversionRate	STRING		NULLABLE
VisitRate	STRING		NULLABLE
Visits	STRING		NULLABLE

### CampaignGroupInfo **Fields**

Field Name	Target Datatype
Description	STRING
EndTime	STRING
ID	STRING
Name	STRING
StartTime	STRING

### Channel **Fields**

Field Name	Target Datatype
AverageOrderValue	STRING	NULLABLE
CompletedViewRate	STRING	NULLABLE
CompletedViews	STRING	NULLABLE
ConversionRate	STRING	NULLABLE
Conversions	STRING	NULLABLE
CostPerAcquisition	STRING	NULLABLE
CostPerCompletedView	STRING	NULLABLE
CostPerVisit	STRING	NULLABLE
CPA	STRING	NULLABLE
Day	STRING	NULLABLE
ExistingSiteVisitors	STRING	NULLABLE
Frequency	STRING	NULLABLE
ID	STRING	NULLABLE
ImpressionConversionRate	STRING	NULLABLE
Impressions	STRING	NULLABLE
ImpressionVisitRate	STRING	NULLABLE
Name	STRING	NULLABLE
NewSiteVisitors	STRING	NULLABLE
OrderValue	STRING	NULLABLE
ReturnOnAdSpend	STRING	NULLABLE
ReturnOnInvestment	STRING	NULLABLE
ROAS	STRING	NULLABLE
ROI	STRING	NULLABLE
SiteVisitors	STRING	NULLABLE
Spend	STRING	NULLABLE
UserConversionRate	STRING	NULLABLE
UsersReached	STRING	NULLABLE
UserVisitRate	STRING	NULLABLE
ViewableImpressionRate	STRING	NULLABLE
ViewableImpressions	STRING	NULLABLE
VisitConversionRate	STRING	NULLABLE
VisitRate	STRING	NULLABLE
Visits	STRING	NULLABLE

### City **Fields**

Field name	Target Datatype
AverageOrderValue	STRING	NULLABLE
CompletedViewRate	STRING	NULLABLE
CompletedViews	STRING	NULLABLE
ConversionRate	STRING	NULLABLE
Conversions	STRING	NULLABLE
CostPerAcquisition	STRING	NULLABLE
CostPerVisit	STRING	NULLABLE
CPA	STRING	NULLABLE
Day	STRING	NULLABLE
ExistingSiteVisitors	STRING	NULLABLE
Frequency	STRING	NULLABLE
ImpressionConversionRate	STRING	NULLABLE
Impressions	STRING	NULLABLE
ImpressionVisitRate	STRING	NULLABLE
Name	STRING	NULLABLE
NewSiteVisitors	STRING	NULLABLE
OrderValue	STRING	NULLABLE
ReturnOnAdSpend	STRING	NULLABLE
ReturnOnInvestment	STRING	NULLABLE
ROAS	STRING	NULLABLE
ROI	STRING	NULLABLE
SiteVisitors	STRING	NULLABLE
Spend	STRING	NULLABLE
UniqueCode	STRING	NULLABLE
UserConversionRate	STRING	NULLABLE
UsersReached	STRING	NULLABLE
UserVisitRate	STRING	NULLABLE
ViewableImpressionRate	STRING	NULLABLE
ViewableImpressions	STRING	NULLABLE
VisitConversionRate	STRING	NULLABLE
VisitRate	STRING	NULLABLE
Visits	STRING	NULLABLE

### Country **Fields**

Field name	Target Datatype
AverageOrderValue	STRING	AverageOrderValue
Code	STRING		NULLABLE
CompletedViewRate	STRING		NULLABLE
CompletedViews	STRING		NULLABLE
ConversionRate	STRING		NULLABLE
Conversions	STRING		NULLABLE
CostPerAcquisition	STRING		NULLABLE
CostPerVisit	STRING		NULLABLE
CPA	STRING		NULLABLE
Day	STRING		NULLABLE
ExistingSiteVisitors	STRING		NULLABLE
Frequency	STRING		NULLABLE
ImpressionConversionRate	STRING		NULLABLE
Impressions	STRING		NULLABLE
ImpressionVisitRate	STRING		NULLABLE
Name	STRING		NULLABLE
NewSiteVisitors	STRING		NULLABLE
OrderValue	STRING		NULLABLE
ReturnOnAdSpend	STRING		NULLABLE
ReturnOnInvestment	STRING		NULLABLE
ROAS	STRING		NULLABLE
ROI	STRING		NULLABLE
SiteVisitors	STRING		NULLABLE
Spend	STRING		NULLABLE
UniqueCode	STRING		NULLABLE
UserConversionRate	STRING		NULLABLE
UsersReached	STRING		NULLABLE
UserVisitRate	STRING		NULLABLE
ViewableImpressionRate	STRING		NULLABLE
ViewableImpressions	STRING		NULLABLE
VisitConversionRate	STRING		NULLABLE
VisitRate	STRING		NULLABLE
Visits	STRING		NULLABLE

### State **Fields**

Field name	Target Datatype
Type	Mode	Field name	Collation	Default Value	Policy Tags	Description
AverageOrderValue	STRING		NULLABLE
Code	STRING		NULLABLE
CompletedViewRate	STRING		NULLABLE
CompletedViews	STRING		NULLABLE
ConversionRate	STRING		NULLABLE
Conversions	STRING		NULLABLE
CostPerAcquisition	STRING		NULLABLE
CostPerVisit	STRING		NULLABLE
CPA	STRING		NULLABLE
Day	STRING		NULLABLE
ExistingSiteVisitors	STRING		NULLABLE
Frequency	STRING		NULLABLE
ImpressionConversionRate	STRING		NULLABLE
Impressions	STRING		NULLABLE
ImpressionVisitRate	STRING		NULLABLE
Name	STRING		NULLABLE
NewSiteVisitors	STRING		NULLABLE
OrderValue	STRING		NULLABLE
ParentCode	STRING		NULLABLE
ReturnOnAdSpend	STRING		NULLABLE
ReturnOnInvestment	STRING		NULLABLE
ROAS	STRING		NULLABLE
ROI	STRING		NULLABLE
SiteVisitors	STRING		NULLABLE
Spend	STRING		NULLABLE
UniqueCode	STRING		NULLABLE
UserConversionRate	STRING		NULLABLE
UsersReached	STRING		NULLABLE
UserVisitRate	STRING		NULLABLE
ViewableImpressionRate	STRING		NULLABLE
ViewableImpressions	STRING		NULLABLE
VisitConversionRate	STRING		NULLABLE
VisitRate	STRING		NULLABLE
Visits	STRING		NULLABLE