Docs

Pinterest Public Data Export

What is Pinterest Public Data?

Pinterest is a social media platform full of ideas right from recipes, fashion, business, designs to technology and science. It is the platform to find inspiration and organize it in a visually appealing way.

With Electrik.AI’s Pinterest Public Data you can access your Pins, Boards and get all the important metrics. In addition to your own data, you can also get the trending pins, pinner, boards of your choice.

How to add a Pinterest Public Data Connection in Electrik.AI?

Follow these steps to connect your Pinterest account to Electrik.AI

Step 1:  Ensure you have following prerequisites to create a Pinterest Public Data Connection in Electrik.AI

  1. Access to Pinterest Account.
  2. Pinterest Account User Id and Password.

Step 2: Sign-in into your Electrik.AI account

Step 3: Select IO in Electrik.AI dashboard

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Connections tab in the left most panel and click on “Add” button.

Select the Connections tab in the left most panel Conn - ElectrikAI

Step 5: The Source default tab is selected just click on “Pinterest Public Data” connection.

Conn Step 5 The Source default tab is selected just click on “Pinterest Public Data” connection - ElectrikAI

Step 6: Enter your Pinterest account User Id and Password.

Conn Step 6-Enter your Pinterest account User Id and Password - ElectrikAI

Step 7: Allow Electrik.AI to access your Pinterest Account.

Conn Step 7-Allow Electrik.AI to access your Pinterest Account - ElectrikAI

Step 8: Click on Save button on the top right corner of the screen.

Conn Step 8 -Click on Save button on the top right corner of the screen - ElectrikAI

Congratulations, you have successfully created a “Pinterest Public Data ”Connection in Electrik.AI

Congratulations, you have successfully created a “Microsoft Ads Keyword Ideas ” Connection in Electrik.AI

What are the supported Data Destinations?

Electrik.AI supports the following databases and Data Warehouse to export Pinterest Public Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

Google Big Query Data Destination-Elecrik.AI
PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Snowflake-Data-Destination-Electrik.AI
Amazon S3-ElectrikAI

How to export Pinterest Public Data?

Electrik.AI creates a data flow (or ETL process) that exports Pinterest Public Data to a target database or data warehouse or cloud storage. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Pinterest Public Data to Google BigQuery

Step 1: Ensure you have the following prerequisites.

  1. Access to Pinterest Account.
  2. Pinterest Account User Id and Passwords.
  3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL)
  4. Database Connection Details such as Host, Port, DB Name, DB User.

Step 2: Sign-in into your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Connections Icon in the left most panel and Click on Add button to create a Pinterest Public Data Extractor Flow

Select the Connections Icon in the left most panel Flow - ElectrikAI

Step 5: Select Pinterest Public Connection present in the list of available sources.

Flow Step 5 The Source default tab is selected just click on “Pinterest Public Data” connection - ElectrikAI

Step 6: Select your existing Pinterest connection in Electrik.AI.

Flow Step 6- Select your existing Pinterest connection in - ElectrikAI

To configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from list of available destinations.

In this example we are choosing BigQuery.

Flow Click on a destination of your choice from list of available destinations - ElectrikAI

Step 8: Click on a destination of your choice from list of available destinations.

Flow-Step 8 Click on a destination of your choice from list of available destinations - ElectrikAI

 Step 9:
a. Choose the desired report to get the appropriate data. In this example we are choosing all.

flow Step 9a Pinterest Public Data Export - ElectrikAI

b. Input Pinterest username whose data you want to get.

flow Step 9b Pinterest Public Data Export - ElectrikAI

Step: 10 Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.

Flow Step 10 Pinterest Public Data Export - ElectrikAI

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By Default, Electrik.AI uses the signed-in user’s Email Id.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen - ElectrikAI

You have now successfully setup Pinterest Public Data to Google BigQuery flow in Electrik.AI

You have now successfully setup Pinterest Public Data to Microsoft BigQuery flow in ElectrikAI

Your Pinterest Public data will start loading after 24 hours in your Google BigQuery Dataset.

Your Microsoft Analytics data will start loading after 24 hours in your Microsoft BigQuery Dataset