With Two Minute Reports’ Pinterest Ads connector, just connect your (client’s) Pinterest ad account. TMR will extract key ad metrics and let you merge your campaign performance data into Google Sheets – without writing any code. Besides, our system ensures data protection by encrypting and storing your information securely in your private Google Sheet.
Now, let me explain how to connect your Pinterest Ads data via Two Minute Reports in Google Sheets.
Step 1: Install and Launch Two Minute Reports
Start by installing TMR in Google Sheets using this step-by-step tutorial: How to install TMR in Google Sheets?
Once done, you can connect your Pinterest account to extract its insights into Google Sheets.
Step 2: Connect Pinterest Ads to Google Sheets
Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.
When the “Adding New Connection” dialog box appears, complete the following three key steps to access your Instagram Insights accounts:
- Select the Pinterest Connector
- Authenticate your account
- Enable the specific accounts with the Pinterest Connector
Choose Pinterest Ads from the list of options, and authorize your Connection by entering your login credentials.
After successful authentication, you will see a screen showing your Account name, ID, Connection name, Status, and Speedboost, as shown below:
Enable the accounts for which you want to run queries. Once enabled, Speedboost is automatically activated, allowing you to retrieve Pinterest Ads data within seconds. Please note that you cannot run queries from the disabled accounts.
Once an account is enabled, Speedboost performs two functions:
- Warm-up – Prepares your account for faster data retrieval by caching your historical data.
- Periodic sync – Ensures your data stays updated automatically at regular intervals.
| To reflect the connected accounts in the TMR sidebar, click “Refresh Connections.” |
Step 3: Fetching Pinterest Ads data in Google Sheets
To pull your Pinterest Ads performance data, navigate to the Data Queries section and create a new query.
- Click Add and choose the Instagram Insights accounts you want to analyze.
- You can manage multiple clients’ Instagram accounts from one interface. Simply select one or more accounts to obtain actionable content marketing insights.
- Alternatively, you can navigate to the Clients section to add your clients and map their corresponding Instagram Insights accounts.
- Click on “Manage Clients” and map the necessary account details. Then click “Save & Close” to save your client’s information for future reference.
Next, add the Pinterest ad metrics and dimensions you want to analyze. You can choose from the list of metrics and dimensions to assess your Pinterest Ad campaign performance. Refer to the screenshot below for better understanding.
Configure your data reporting by selecting relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the information that matters.
Once you finish these steps, click Run Query to visualize the output.
You can then use various Google Sheets features, such as pivot tables and VLOOKUP(), to extract critical insights and build charts to visualize your Instagram Insights data.
| Pro TMR Tip: Run all your queries directly from the Extensions menu in Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action. |
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient(s)’s email ID and save the new schedule.
You can also specify the reporting format. You can opt to insert the sheet content in the email body, attach the selected sheet as a PDF or Excel file, or attach the spreadsheet as an Excel file.
Two Minute Reports’s schedule refresh or data refresh feature has other capabilities. For more information, please read our guide, “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. Please contact our support team via chat button or [email protected] if you have any questions.