Connect CreatorIQ to Python
Bring CreatorIQ creator post, campaign and engagement data into Python with Windsor.ai.
Pick the CreatorIQ fields you need, such as Campaign Name, Publisher Name and Engagement, and Windsor.ai loads them without a CSV export.
Forget CSVs. Stop copy/paste. Connect in minutes.
Get your CreatorIQ data into Python
CreatorIQ is connected once in Windsor.ai, and these are the use cases the fields support:
Compare campaigns
Impressions, Reach and Engagement per Campaign Name show which influencer campaigns reached the most people and got the most interaction.
Rank creators
Engagement, Link Clicks and Saves per Publisher Name show which creators drive interaction and traffic, split by Social Network Name and Post Type.
Separate paid and organic results
Paid Impressions and Paid Clicks next to Impressions and Clicks, with Combined Impressions and Combined Clicks for the total, show how much of a post’s results came from boosting it.
Using Windsor.ai to connect data from CreatorIQ to Python
Windsor.ai moves your CreatorIQ fields into Python on a connection you set up once.
The code example in step 4 shows the request and the columns it returns.
How to connect CreatorIQ to Python with Windsor.ai
Explore a step-by-step guide to integrate your CreatorIQ data into Python with the Windsor.ai connector.
Connect a data source
In your Windsor.ai dashboard, connect CreatorIQ: enter a name for the account and your CreatorIQ API key, then click Add Account. To get an API key, ask your CreatorIQ contact or email [email protected]. Select the account(s) you want to pull data from and click Next.
Set Python as a data destination
Scroll down and choose Python from the data destination list. Copy the API Key URL provided in the instructions below.
Integrate the API Key URL into your Python code to stream data
Use Python’s requests library to call the API Key URL and load the rows into pandas. This example totals the last 30 days by creator:
import requests
import pandas as pd
url = "https://connectors.windsor.ai/creatoriq"
params = {
"api_key": "YOUR_API_KEY",
"date_preset": "last_30d",
"fields": "date,campaign_name,publisher_name,social_network,engagement,link_clicks",
}
rows = requests.get(url, params=params, timeout=60).json()["data"]
df = pd.DataFrame(rows)
print(df.groupby("publisher_name")[["engagement", "link_clicks"]].sum())
The DataFrame has one column per field: date, campaign_name, publisher_name, social_network, engagement and link_clicks. Add post_link and post_type to the fields to see which posts brought the engagement.
FAQs
What CreatorIQ data can I load into Python?
Windsor.ai gives access to 88 CreatorIQ fields: 49 metrics, such as Impressions and Engagement, and 39 dimensions, such as Publisher Name and Date. These are the groups; the CreatorIQ field reference lists all of them:
- Campaigns and creators: Campaign Name, Publisher Name, User Name, Social Network Name, Post Type, Post Link.
- Reach and impressions: Impressions, Reach, Network Impressions, Network Reach, Estimated Impressions, Estimated Reach, Actual Impressions, Actual Reach, Total Reach.
- Engagement: Likes, Comments, Total Shares, Saves, Engagement, Link Clicks, Post View Count.
- Paid and combined: Paid Impressions, Paid Reach, Paid Clicks, Paid Views, Combined Impressions, Combined Reach, Combined Clicks.
- Stories: Taps Forward, Taps Back, Swipe Aways, Story Swipe Ups, Sticker Taps, Replies.
- Date and account: Date, Week, Month, Year, Account Name.
How does Windsor.ai load CreatorIQ data into Python?
Windsor.ai gives you an API URL for your selected CreatorIQ fields. Call it from Python with requests or a similar library and load the response into pandas or your own code.
Can I combine CreatorIQ data with other sources in my scripts?
Yes. Windsor.ai supports 350+ data sources, so CreatorIQ data can sit next to other connected sources in the same scripts. For example, put CreatorIQ Link Clicks and Engagement by Campaign Name and Date next to GA4 Sessions and Key events by Session campaign for the same days, to compare the clicks creators reported with the visits your site recorded.
Do I need to code to connect CreatorIQ to Python?
Yes, a few lines. Connecting CreatorIQ and choosing fields happens in the Windsor.ai dashboard with no code. Loading the data into Python takes one request, as in the example in step 4.
How much does it cost to integrate CreatorIQ with Python using Windsor.ai?
The free forever plan covers 1 data source, so connecting CreatorIQ on its own costs nothing and needs no credit card. Combining CreatorIQ with other sources needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.
Do you have helpful links to get started with CreatorIQ and Python?
Yes. The CreatorIQ field reference lists every field with its description, and the Python integration documentation covers the setup step by step.
The CreatorIQ connector page lists every destination for this data, and the list of Windsor.ai connectors for Python shows the other sources you can add.
To compare CreatorIQ posts with your own social accounts, read the guide on using Windsor.ai for social media.
Tired of manual CreatorIQ data exports? Try Windsor.ai today to report on current data

