MNTN
MNTN ETL connector for data replication
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 |
