+
Stream your marketing data from Instagram to Snowflake
About Instagram
About 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:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- 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 Instagram as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
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
| name | type | description |
|---|---|---|
| Account ID | TEXT | Alias for Instagram user ID |
| Account Name | TEXT | Instagram user name |
| Age group name | TEXT | age group name |
| Number of followers of a age group | NUMERIC | The lifetime number of an Instagram profile followers who belong to a age group |
| Number of followers from a city | NUMERIC | The lifetime number of an Instagram profile followers from a city |
| Audience Country Name | COUNTRY | Follower's country code |
| Number of followers from a country | NUMERIC | The lifetime number of an Instagram profile followers from a country |
| Gender/Age group name | TEXT | Gender/age group name |
| Number of followers of a gender/age group | NUMERIC | The lifetime number of an Instagram profile followers who belong to a gender/age group |
| Gender group name | TEXT | Gender group name |
| Number of followers of a gender group | NUMERIC | The lifetime number of an Instagram profile followers who belong to a gender group |
| Locale name | TEXT | Follower's locale name (language code + country code) |
| Number of followers for a locale | NUMERIC | The lifetime number of an Instagram profile followers with a locale |
| Instagram profile (account) biography | TEXT | Instagram profile (account) biography |
| Carousel album engagement | NUMERIC | Total number of likes and comments on the carousel album |
| Carousel album impressions | NUMERIC | Total number of times the carousel album has been seen |
| Carousel album reach | NUMERIC | Total number of unique Instagram accounts that have seen the carousel album |
| Carousel album saved | NUMERIC | Total number of unique accounts that have saved the carousel album |
| Carousel album video views | NUMERIC | Total number of unique Instagram accounts that have viewed video within the carousel album. |
| City | TEXT | Follower's city |
| Total clicks | NUMERIC | Total number of taps on directions, call, text message, website links in the Instagram user's profile within a day |
| Date | DATE | Date |
| Email contacts (1 day) | NUMERIC | Total number of taps on the email link in the Instagram user's profile within a day |
| The current latest date of a lifetime period | DATE | The current latest date for lifetime metrics |
| New followers (1 day) | NUMERIC | Total number of new followers within a day. Not available on users with fewer than 100 followers. |
| Profile followers | NUMERIC | Total number of unique accounts following this profile |
| Profile follows | NUMERIC | Total number of accounts this profile is following |
| Get directions clicks (1 day) | NUMERIC | Total number of taps on the directions link in the Instagram user's profile within a day. |
| Alias for Impressions (1 day) | NUMERIC | Alias for Impressions (1 day) |
| Impressions (1 day) | NUMERIC | Total number of times the Instagram user's Instagram Media have been viewed within a day. Does not include profile views. |
| Legacy Instagram user ID | TEXT | Legacy Instagram user ID |
| Media caption | TEXT | Caption of the post |
| Comments count | NUMERIC | Count of comments on the media. Excludes comments on album child media and the media's caption. Includes replies on comments. |
| Profile media count | NUMERIC | Total number of media for this profile |
| Media engagement | NUMERIC | Sum of like_count, comments_count and saved counts on the Instagram media object |
| Media ID | TEXT | Media object ID. |
| Media impressions | NUMERIC | Total number of times the Instagram media object has been seen |
| Media comments enabled | TEXT | Whether or not the comments are enabled |
| Media Like Count | NUMERIC | Count of likes on the media. Excludes likes on album child media and likes on promoted posts created from the media. Includes replies on comments. |
| Media permalink | TEXT | URL of the post on Instagram |
| Media product type | TEXT | Surface where the media is published. Can be AD, FEED, IGTV, or STORY |
| Media reach | NUMERIC | Total number of unique Instagram accounts that have seen the Instagram media object. |
| Media saved | NUMERIC | Total number of unique Instagram accounts that have saved the Instagram media object |
| Media shortcode | TEXT | Shortcode of the post on Instagram |
| Video thumbnail URL | IMAGE_URL | URL of the video thumbnail |
| Media type | TEXT | Type of the media object (IMAGE, VIDEO, CAROUSEL_ALBUM, REEL) |
| Media URL | IMAGE_URL | URL of the media object |
| Media video views | NUMERIC | Total 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) name | TEXT | Instagram profile (account) name |
| Phone call clicks (1 day) | NUMERIC | Total number of taps on the call link in Instagram user's profile within a day |
| Profile views (1 day) | NUMERIC | Total number of users who have viewed the Instagram user's profile within a day |
| Alias for Profile reach (1 day) | NUMERIC | Alias for Profile reach (1 day) |
| Profile reach (1 day) | NUMERIC | Total number of unique users who have viewed at least one of the Instagram user's Instagram Media |
| Story exits | NUMERIC | Number of times someone exited the story |
| Story ID | TEXT | Story ID |
| Story impressions | NUMERIC | Total number of times the story has been seen |
| Permanent URL to the media. | TEXT | Total number of taps to see this story's previous photo or video |
| Story reach | NUMERIC | Total number of unique accounts that have seen the story |
| Story replies | NUMERIC | Total number of replies to the story |
| Story taps back | NUMERIC | Total number of taps to see this story's previous photo or video |
| Story taps forward | NUMERIC | Total number of taps to see this story's next photo or video |
| Text message clicks (1 day) | NUMERIC | Total number of taps on the text message link in the Instagram user's profile within a day |
| Media created | TIMESTAMP | Date and time when media was added |
| Instagram user ID | TEXT | Instagram user ID |
| Instagram user name (alias) | TEXT | Alias for Instagram user name |
| Instagram user name | TEXT | Instagram user name |
| Linked website | TEXT | Link to your website that is displayed on your Instagram profile page |
| Linked website clicks (1 day) | NUMERIC | Total 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
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.