Connect Instagram Insights to Snowflake

instagram
+
snowflake

Stream your marketing data from Instagram to Snowflake

Connect Instagram Insights to Snowflake in 2023

It is very simple to connect Instagram Insights 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. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username Import Snowflake 1
  • Get the password Import Snowflake 2
  • Get the account Import Snowflake 3
  • Get the warehouse Import Snowflake 4
  • Get the database Import Snowflake 5
  • Get the schema Import Snowflake 6
  • Get the table name Import Snowflake 7

Second step

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

Instagram Insigths Windsor.ai Onboarding

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save
Snowflake connector

 

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

Instagram Insights metrics and dimensions available for streaming into Snowflake

Connect your data

nametypedescription
Account IDTEXTAlias for Instagram user ID
Account NameTEXTInstagram user name
Age group nameTEXTage group name
Number of followers of a age groupNUMERICThe lifetime number of an Instagram profile followers who belong to a age group
Number of followers from a cityNUMERICThe lifetime number of an Instagram profile followers from a city
Audience Country NameCOUNTRYFollower's country code
Number of followers from a countryNUMERICThe lifetime number of an Instagram profile followers from a country
Gender/Age group nameTEXTGender/age group name
Number of followers of a gender/age groupNUMERICThe lifetime number of an Instagram profile followers who belong to a gender/age group
Gender group nameTEXTGender group name
Number of followers of a gender groupNUMERICThe lifetime number of an Instagram profile followers who belong to a gender group
Locale nameTEXTFollower's locale name (language code + country code)
Number of followers for a localeNUMERICThe lifetime number of an Instagram profile followers with a locale
Instagram profile (account) biographyTEXTInstagram profile (account) biography
NUMERICTotal number of likes and comments on the carousel album
NUMERICTotal number of times the carousel album has been seen
NUMERICTotal number of unique Instagram accounts that have seen the carousel album
NUMERICTotal number of unique accounts that have saved the carousel album
NUMERICTotal number of unique Instagram accounts that have viewed video within the carousel album.
CityTEXTFollower's city
Total clicksNUMERICTotal number of taps on directions, call, text message, website links in the Instagram user's profile within a day
DateDATEDate
Email contacts (1 day)NUMERICTotal number of taps on the email link in the Instagram user's profile within a day
The current latest date of a lifetime periodDATEThe current latest date for lifetime metrics
New followers (1 day)NUMERICTotal number of new followers within a day. Not available on users with fewer than 100 followers.
Profile followersNUMERICTotal number of unique accounts following this profile
Profile followsNUMERICTotal number of accounts this profile is following
Get directions clicks (1 day)NUMERICTotal number of taps on the directions link in the Instagram user's profile within a day.
Alias for Impressions (1 day)NUMERICAlias for Impressions (1 day)
Impressions (1 day)NUMERICTotal number of times the Instagram user's Instagram Media have been viewed within a day. Does not include profile views.
Legacy Instagram user IDTEXTLegacy Instagram user ID
Media captionTEXTCaption of the post
Comments countNUMERICCount of comments on the media. Excludes comments on album child media and the media's caption. Includes replies on comments.
Profile media countNUMERICTotal number of media for this profile
Media engagementNUMERICSum of like_count, comments_count and saved counts on the Instagram media object
Media IDTEXTMedia object ID.
Media impressionsNUMERICTotal number of times the Instagram media object has been seen
Media comments enabledTEXTWhether or not the comments are enabled
Media Like CountNUMERICCount of likes on the media. Excludes likes on album child media and likes on promoted posts created from the media. Includes replies on comments.
TEXTURL of the post on Instagram
Media product typeTEXTSurface where the media is published. Can be AD, FEED, IGTV, or STORY
Media reachNUMERICTotal number of unique Instagram accounts that have seen the Instagram media object.
Media savedNUMERICTotal number of unique Instagram accounts that have saved the Instagram media object
Media shortcodeTEXTShortcode of the post on Instagram
Video thumbnail URLIMAGE_URLURL of the video thumbnail
Media typeTEXTType of the media object (IMAGE, VIDEO, CAROUSEL_ALBUM, REEL)
Media URLIMAGE_URLURL of the media object
Media video viewsNUMERICTotal number of times the video Instagram Media has been seen. For album Instagram media, the number of times all videos within the album have been seen.
Instagram profile (account) nameTEXTInstagram profile (account) name
Phone call clicks (1 day)NUMERICTotal number of taps on the call link in Instagram user's profile within a day
Profile views (1 day)NUMERICTotal number of users who have viewed the Instagram user's profile within a day
Alias for Profile reach (1 day)NUMERICAlias for Profile reach (1 day)
Profile reach (1 day)NUMERICTotal number of unique users who have viewed at least one of the Instagram user's Instagram Media
Story exitsNUMERICNumber of times someone exited the story
Story IDTEXTStory ID
Story impressionsNUMERICTotal number of times the story has been seen
Permanent URL to the media.TEXTTotal number of taps to see this story's previous photo or video
Story reachNUMERICTotal number of unique accounts that have seen the story
Story repliesNUMERICTotal number of replies to the story
Story taps backNUMERICTotal number of taps to see this story's previous photo or video
Story taps forwardNUMERICTotal number of taps to see this story's next photo or video
Text message clicks (1 day)NUMERICTotal number of taps on the text message link in the Instagram user's profile within a day
Media createdTIMESTAMPDate and time when media was added
Instagram user IDTEXTInstagram user ID
Instagram user name (alias)TEXTAlias for Instagram user name
Instagram user nameTEXTInstagram user name
Linked websiteTEXTLink to your website that is displayed on your Instagram profile page
Linked website clicks (1 day)NUMERICTotal number of taps on the website link in the Instagram user's profile

Easily connect Instagram Insights 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 Instagram Insights and Snowflake Integrations