Connect Dragon Metrics to Snowflake

Dragon Metrics
+
snowflake

Stream all your data from Dragon Metrics to Snowflake

Connect Dragon Metrics to Snowflake

It is very simple to connect Dragon Metrics to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance)
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select Dragon Metrics as a Data Source and Grant Access to Windsor.ai.

 

Dragon Metrics Google Sheets Connector

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3.Enter all the credentials required and click Save

 

4. Your data will now be streamed from Dragon Metrics to Snowflake. In case there is an error you will be notified.

Dragon Metrics metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
Account IDTEXTAccount ID
Account NameTEXTAccount Name
CampaignTEXTThe Campaign Name (same as campaign_name)
Campaign Alternate Seed URLTEXTSite crawls start from the homepage of the URL entered in the'site' property. To add another URL to begin crawling from, you may optionally enter it as an alternate seed URL.
Campaign Competitors SiteTEXTURL of this competitor site
Campaign Competitors Site ScopeTEXTDefines the scope of which URLs will be included in this site. Enum: "root domain" "subdomain subfolder" "exact url" "root domain only"
Campaign Crawl LimitNUMERICThe maximum number of URLs available for this crawl.
Campaign Crawl SiteBOOLEANBoolean value of whether crawling should be enabled for this site or not.
Campaign Crawl SpeedTEXTThe speed of the crawler. Four potential options include 'Slow', 'Normal' (default), 'Fast', and 'Extreme'. Crawls finish faster with higher speeds, but may result in a higher load on the site'sservers. Lower speeds are recommended if the server returns many 5xx errors.
Campaign Domain AuthorityNUMERICThe Domain Authority of the tracking URL for this campaign. Data comes from Moz.
Campaign IDTEXTCampaign ID
Campaign Keyword Credit UsageNUMERICThe number of keyword credits currently utilized by this campaign.
BOOLEANBy default, this value is set to false, which means that tracking search engines will be set at the campaign level for all keywords in the campaign. If set to true, tracking search engine will be defined at the keyword level, and the search_engines object will not be included in the campaign object.
Campaign Keyword LimitNUMERICKeywords credits are shared across all campaigns in your account. If desired, you can set an optional limit on the number of credits available for this campaign to use.
Campaign NameTEXTThe name of the campaign. Must be unique.
Campaign Ranking Summary All KeywordsNUMERICThe total number of keywords in this set
Campaign Ranking Summary All Keywords DeclinedNUMERICNumber of keywords whose ranking declined during the selected period
Campaign Ranking Summary All Keywords ImprovedNUMERICNumber of keywords whose ranking improved during the selected period
Campaign Ranking Summary Average PositionNUMERICThe mean position of all keywords in the selected set
Campaign Ranking Summary Average Position ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Organic Visibility NUMERICA value between 0-100 measuring the share of organic search visibility. Roughly equates to the average expected click-through rate of all keywords tracked in the current set.
Campaign Ranking Summary Organic Visibility ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 1NUMERICNumber of keywords with a ranking position of 1
Campaign Ranking Summary Position 11-20NUMERICNumber of keywords with a ranking position between 11 and 20
Campaign Ranking Summary Position 11-20 ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 11-20 EnteredNUMERICNumber of keywords with a ranking position between 11 and 20 on the end date that were not in this position on the begin date of the selected range
Campaign Ranking Summary Position 11-20 LeftNUMERICNumber of keywords with a ranking position between 11 and 20 on the begin date that were not in this position on the end date of the selected range
Campaign Ranking Summary Position 1 ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 1 EnteredNUMERICNumber of keywords with a ranking position of 1 on the end date that were not at position 1 on the begin date of the selected range
Campaign Ranking Summary Position 1 LeftNUMERICNumber of keywords with a ranking position of 1 on the begin date that were not at position 1 on the end date of the selected range
Campaign Ranking Summary Position 21-50NUMERICNumber of keywords with a ranking position between 21 and 50
Campaign Ranking Summary Position 21-50 ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 21-50 EnteredNUMERICNumber of keywords with a ranking position between 21 and 50 on the end date that were not in this position on the begin date of the selected range
Campaign Ranking Summary Position 21-50 LeftNUMERICNumber of keywords with a ranking position between 21 and 50 on the begin date that were not in this position on the end date of the selected range
Campaign Ranking Summary Position 2-5NUMERICNumber of keywords with a ranking position between 2 and 5
Campaign Ranking Summary Position 2-5 ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 2-5 EnteredNUMERICNumber of keywords with a ranking position between 2 and 5 on the end date that were not in this position on the begin date of the selected range
Campaign Ranking Summary Position 2-5 LeftNUMERICNumber of keywords with a ranking position between 2 and 5 on the begin date that were not in this position on the end date of the selected range
Campaign Ranking Summary Position 51+NUMERICNumber of keywords with a ranking position that were not found in the top 50 results
Campaign Ranking Summary Position 51+ ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 51+ EnteredNUMERICNumber of keywords with a ranking position that were not found in the top 50 results on the end date that were found in the top 50 results on the begin date of the selected range
Campaign Ranking Summary Position 51-100 LeftNUMERICNumber of keywords with a ranking position that were not found in the top 50 results on the begin date that were found in the top 50 results on the end date of the selected range
Campaign Ranking Summary Position 6-10NUMERICNumber of keywords with a ranking position between 6 and 10
Campaign Ranking Summary Position 6-10 ChangeNUMERICDifference between the selected begin date and end date for this metric
Campaign Ranking Summary Position 6-10 EnteredNUMERICNumber of keywords with a ranking position between 6 and 10 on the end date that were not in this position on the begin date of the selected range
Campaign Ranking Summary Position 6-10 LeftNUMERICNumber of keywords with a ranking position between 6 and 10 on the begin date that were not in this position on the end date of the selected range
TEXTThe search engine code for this search engine. Search engine codes are in the following format: {SEARCH ENGINE NAME}|{COUNTRY CODE}|{LANGUAGE CODE}|{DEVICE}|{LOCATION} For example: google|us|en|desktop.
Campaign Ranking Summary Top 10NUMERICNumber of keywords with a ranking position in the top 10 results
Campaign Ranking Summary Top 10 EnteredNUMERICNumber of keywords with a ranking position in the top 10 results on the end date that were not in the top 10 results on the begin date of the selected range
Campaign Ranking Summary Top 10 LeftNUMERICNumber of keywords with a ranking position in the top 10 results on the begin date that were not in the top 10 results on the end date of the selected range
Campaign Ranking Summary Top 50NUMERICNumber of keywords with a ranking position in the top 50 results
Campaign Ranking Summary Top 50 EnteredNUMERICNumber of keywords with a ranking position in the top 50 results on the end date that were not in the top 50 results on the begin date of the selected range
Campaign Ranking Summary Top 50 LeftNUMERICNumber of keywords with a ranking position in the top 50 results on the begin date that were not in the top 50 results on the end date of the selected range
Campaign Ranking Summary Traffic IndexNUMERICAn estimate of the site's monthly organic traffic from the tracked keywords in this set.
Campaign Ranking Summary Traffic Index ChangeNUMERICDifference between the selected begin date and end date for this metric
TEXTThe search engine code for this search engine. Search engine codes are in the following format: {SEARCH ENGINE NAME}|{COUNTRY CODE}|{LANGUAGE CODE}|{DEVICE}|{LOCATION} For example: google|us|en|desktop
TEXTPlain English name of the search engine (e.g. Google us-EN (desktop))
Campaign SiteTEXTThe site URL for this campaign.
Campaign Site ScopeTEXTDefines the scope of which URLs will be included in this site. Enum: "root domain" "subdomain subfolder" "exact url" "root domain only"
Campaign StatusTEXTWhether the campaign is active or paused. Enum: "active" "paused"
Campaign TagsTEXTA list of all tags in the campaign
DateDATEThe Date
TodayDATEToday's date

Easily connect Dragon Metrics to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Dragon Metrics and Snowflake Integrations