Integrate Apify Instagram Post Scraper into BigQuery

Gather post data with Apify's Instagram Post Scraper. To set up this Actor, you will need to add Instagram usernames to extract the post from, the desired number of posts, and the timeframe of the posts.

For each Instagram post, you will extract:

• Post details: post URL, content type (image, video, carousel), shortcode, post ID, and timestamp.
• Text content: caption, hashtags, and mentions.
• Engagement metrics: number of likes and comments, including a few latest comments.
• Media details: image dimensions (height and width), display URL, and alternative text (if available).
• User information: owner’s username, full name (if available), and user ID.
• Additional data: tagged users, child posts (for carousel posts), and location details (if available).