creatordb-app · Schema

InstagramSponsorshipData

Retrieve recently sponsored Instagram posts and reels data for a specified creator.

CompanyCreator DataInfluencer MarketingAPIAnalyticsAsia

Properties

Name Type Description
sponsorList array List of sponsors and their associated branded content.
View JSON Schema on GitHub

JSON Schema

creatordb-app-instagram-sponsorship-data-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/creatordb-app/json-schema/creatordb-app-instagram-sponsorship-data-schema.json",
  "title": "InstagramSponsorshipData",
  "description": "Retrieve recently sponsored Instagram posts and reels data for a specified creator.",
  "x-generated": "2026-10-30",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/creatordb-app-openapi.yaml#/components/schemas/InstagramSponsorshipData",
  "type": "object",
  "properties": {
    "sponsorList": {
      "type": "array",
      "description": "List of sponsors and their associated branded content.",
      "items": {
        "type": "object",
        "description": "A sponsor's branded posts and aggregated performance metrics.",
        "properties": {
          "brandName": {
            "type": "string",
            "description": "The sponsor name."
          },
          "brandId": {
            "type": "string",
            "description": "The official website URL or unique identifier of the sponsor."
          },
          "brandIgIds": {
            "type": "array",
            "description": "The Instagram handles of the sponsor.",
            "items": {
              "type": "string"
            }
          },
          "sponsoredImages": {
            "type": "array",
            "description": "Recent sponsored Instagram image post data.",
            "items": {
              "type": "object",
              "description": "A recent sponsored Instagram image post.",
              "properties": {
                "publishTime": {
                  "type": "integer",
                  "description": "Publish time, represented as a Unix timestamp in milliseconds."
                },
                "contentId": {
                  "type": "string",
                  "description": "The unique identifier. Represented as follows: `https://www.instagram.com/p/{imageId}`"
                },
                "isSponsored": {
                  "type": "boolean",
                  "description": "`true` if sponsored."
                },
                "description": {
                  "type": "string",
                  "description": "The post caption, including emojis and line breaks."
                },
                "coverImageUrl": {
                  "type": "string",
                  "description": "The first image URL in an image post."
                },
                "carouselImageUrls": {
                  "type": "array",
                  "description": "URLs of images in the Instagram post.",
                  "items": {
                    "type": "string"
                  }
                },
                "igGeoTaggedLocation": {
                  "type": [
                    "object",
                    "null"
                  ],
                  "description": "Tagged location.",
                  "properties": {
                    "lat": {
                      "type": "number",
                      "description": "Latitude of the geo-tagged location."
                    },
                    "lng": {
                      "type": "number",
                      "description": "Longitude of the geo-tagged location."
                    },
                    "name": {
                      "type": "string",
                      "description": "Name of the geo-tagged location."
                    }
                  },
                  "required": [
                    "lat",
                    "lng",
                    "name"
                  ]
                },
                "likes": {
                  "type": "number",
                  "description": "Number of likes."
                },
                "comments": {
                  "type": "number",
                  "description": "Number of comments."
                },
                "engagementRate": {
                  "type": "number",
                  "description": "Engagement rate, rounded to 4th decimal place. <br /> *Engagement Rate &#61; (Likes + Comments)/ Followers*"
                },
                "hashtags": {
                  "type": "array",
                  "description": "Keywords used in the post description.",
                  "items": {
                    "type": "string"
                  }
                },
                "taggedCreators": {
                  "type": "array",
                  "description": "Tagged creators.",
                  "items": {
                    "type": "string"
                  }
                }
              },
              "required": [
                "publishTime",
                "contentId",
                "isSponsored",
                "description",
                "coverImageUrl",
                "carouselImageUrls",
                "igGeoTaggedLocation",
                "likes",
                "comments",
                "engagementRate",
                "hashtags",
                "taggedCreators"
              ]
            }
          },
          "sponsoredReels": {
            "type": "array",
            "description": "Recently sponsored Instagram reels.",
            "items": {
              "type": "object",
              "description": "A recent sponsored Instagram reel.",
              "properties": {
                "publishTime": {
                  "type": "integer",
                  "description": "Publish time, represented as a Unix timestamp in milliseconds."
                },
                "contentId": {
                  "type": "string",
                  "description": "The unique identifier. Represented as follows: `https://www.instagram.com/reel/{reelId}`"
                },
                "isSponsored": {
                  "type": "boolean",
                  "description": "`true` if sponsored."
                },
                "description": {
                  "type": "string",
                  "description": "The reel caption, including emojis and line breaks."
                },
                "coverImageUrl": {
                  "type": "string",
                  "description": "The cover image URL."
                },
                "igGeoTaggedLocation": {
                  "type": [
                    "object",
                    "null"
                  ],
                  "description": "Tagged location.",
                  "properties": {
                    "lat": {
                      "type": "number",
                      "description": "Latitude of the geo-tagged location."
                    },
                    "lng": {
                      "type": "number",
                      "description": "Longitude of the geo-tagged location."
                    },
                    "name": {
                      "type": "string",
                      "description": "Name of the geo-tagged location."
                    }
                  },
                  "required": [
                    "lat",
                    "lng",
                    "name"
                  ]
                },
                "likes": {
                  "type": "number",
                  "description": "Number of likes."
                },
                "comments": {
                  "type": "number",
                  "description": "Number of comments."
                },
                "views": {
                  "type": "number",
                  "description": "Number of views."
                },
                "engagementRate": {
                  "type": "number",
                  "description": "Engagement rate, rounded to 4th decimal place. <br /> - *Engagement Rate &#61; (Likes + Comments) / Views*"
                },
                "hashtags": {
                  "type": "array",
                  "description": "Keywords in the reel description.",
                  "items": {
                    "type": "string"
                  }
                },
                "taggedCreators": {
                  "type": "array",
                  "description": "Tagged creators.",
                  "items": {
                    "type": "string"
                  }
                },
                "musicInfo": {
                  "type": "object",
                  "description": "Information about the music used in the reel. Returns an object of empty strings when no music information is available.",
                  "properties": {
                    "id": {
                      "type": "string",
                      "description": "Unique identifier of the music track."
                    },
                    "title": {
                      "type": "string",
                      "description": "Title of the music track."
                    },
                    "displayArtist": {
                      "type": "string",
                      "description": "Artist name as displayed on Instagram."
                    }
                  },
                  "required": [
                    "id",
                    "title",
                    "displayArtist"
                  ]
                }
              },
              "required": [
                "publishTime",
                "contentId",
                "isSponsored",
                "description",
                "coverImageUrl",
                "igGeoTaggedLocation",
                "likes",
                "comments",
                "views",
                "engagementRate",
                "hashtags",
                "taggedCreators",
                "musicInfo"
              ]
            }
          },
          "sponsoredImagesPerformance": {
            "type": "object",
            "description": "Performance metrics for sponsored Instagram image posts broken down by brands.",
            "properties": {
              "likes": {
                "type": "object",
                "properties": {
                  "all": {
                    "type": "integer",
                    "description": "Total number of likes.",
                    "minimum": 0
                  },
                  "avg": {
                    "type": "number",
                    "description": "Average number of likes per sponsored image post, rounded to an integer.",
                    "minimum": 0
                  },
                  "median": {
                    "type": "number",
                    "description": "Median number of likes.",
                    "minimum": 0
                  },
                  "min": {
                    "type": "number",
                    "description": "Minimum number of likes.",
                    "minimum": 0
                  },
                  "max": {
                    "type": "number",
                    "description": "Maximum number of likes.",
                    "minimum": 0
                  }
                },
                "required": [
                  "all",
                  "avg",
                  "median",
                  "min",
                  "max"
                ]
              },
              "comments": {
                "type": "object",
                "properties": {
                  "all": {
                    "type": "integer",
                    "description": "Total number of comments.",
                    "minimum": 0
                  },
                  "avg": {
                    "type": "number",
                    "description": "Average number of comments per sponsored image post, rounded to an integer.",
                    "minimum": 0
                  },
                  "median": {
                    "type": "number",
                    "description": "Median number of comments.",
                    "minimum": 0
                  },
                  "min": {
                    "type": "number",
                    "description": "Minimum number of comments.",
                    "minimum": 0
                  },
                  "max": {
                    "type": "number",
                    "description": "Maximum number of comments.",
                    "minimum": 0
                  }
                },
                "required": [
                  "all",
                  "avg",
                  "median",
                  "min",
                  "max"
                ]
              },
              "engagement": {
                "type": "object",
                "description": "Engagement performance metrics including rates, per-follower statistics and consistency analysis.",
                "properties": {
                  "avgEngagementRate": {
                    "type": "number",
                    "description": "Average engagement rate per image post (excluding older pinned image posts), rounded to 4th decimal place <br />\n- *Engagement Rate &#61; (Likes + Comments) / Followers*",
                    "minimum": 0
                  },
                  "likesPerFollower": {
                    "type": "number",
                    "description": "Average number of likes per follower on image posts, rounded to 4th decimal place.",
                    "minimum": 0
                  },
                  "commentsPerFollower": {
                    "type": "number",
                    "description": "Average number of comments per follower on image posts, rounded to 4th decimal place.",
                    "minimum": 0
                  },
                  "engagementConsistency": {
                    "type": "object",
                    "description": "Consistency of engagement performance of sponsored Instagram image posts broken down by brands.",
                    "properties": {
                      "cv": {
                        "type": "number",
                        "description": "*cv &#61; Standard Deviation of Engagement Rate/ Mean Engagement Rate* <br />\n- The value is rounded to 4th decimal place. <br />\n- Lower values indicate more consistent performance. <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "medianVsMean": {
                        "type": "number",
                        "description": "*medianVsMean &#61; Median Engagement Rate/ Mean Engagement Rate* <br />\n- The value is rounded to 4th decimal place <br />\n- Values closer to `1` indicate more consistent performance. <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "topBottomRatio": {
                        "type": "number",
                        "description": "*topBottomRatio &#61; avg(Top 3 Engagement) / avg(Bottom 3 Engagement)* <br />\n- The value is rounded to 4th decimal place <br />\n- Lower ratios indicate more consistent performance <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "consistencyScore": {
                        "type": [
                          "integer",
                          "null"
                        ],
                        "description": "*consistencyScore &#61; 100 - [(cvScore\\*weight_cv) + (topBottomScore\\*weight_topBottom) + (medianVsMeanScore\\*weight_medianVsMean)]* <br />\n- The score is rounded to an integer. <br />\n- A higher score indicates more stable and consistent performance. <br />\n- Returns `null` when any of the three indicators (`cv`, `medianVsMean`, `topBottomRatio`) is `0`, indicating insufficient data.",
                        "minimum": 0,
                        "maximum": 100
                      },
                      "consistencyLevel": {
                        "type": [
                          "string",
                          "null"
                        ],
                        "enum": [
                          "high",
                          "moderate",
                          "low",
                          null
                        ],
                        "description": "A qualitative label based on the `consistencyScore`: <br />\n- high: 81 - 100 <br />\n- moderate: 51 - 80 <br />\n- low: 1 - 50 <br />\n- Returns `null` when `consistencyScore` is `null`, indicating insufficient data."
                      }
                    },
                    "required": [
                      "cv",
                      "medianVsMean",
                      "topBottomRatio",
                      "consistencyScore",
                      "consistencyLevel"
                    ]
                  }
                },
                "required": [
                  "avgEngagementRate",
                  "likesPerFollower",
                  "commentsPerFollower",
                  "engagementConsistency"
                ]
              }
            },
            "required": [
              "likes",
              "comments",
              "engagement"
            ]
          },
          "sponsoredReelsPerformance": {
            "type": "object",
            "description": "Performance metrics for sponsored Instagram reels broken down by brands.",
            "properties": {
              "likes": {
                "type": "object",
                "properties": {
                  "all": {
                    "type": "integer",
                    "description": "Total number of likes.",
                    "minimum": 0
                  },
                  "avg": {
                    "type": "number",
                    "description": "Average number of likes per reel, rounded to an integer.",
                    "minimum": 0
                  },
                  "median": {
                    "type": "number",
                    "description": "Median number of likes.",
                    "minimum": 0
                  },
                  "min": {
                    "type": "number",
                    "description": "Minimum number of likes.",
                    "minimum": 0
                  },
                  "max": {
                    "type": "number",
                    "description": "Maximum number of likes.",
                    "minimum": 0
                  }
                },
                "required": [
                  "all",
                  "avg",
                  "median",
                  "min",
                  "max"
                ]
              },
              "comments": {
                "type": "object",
                "properties": {
                  "all": {
                    "type": "integer",
                    "description": "Total number of comments.",
                    "minimum": 0
                  },
                  "avg": {
                    "type": "number",
                    "description": "Average number of comments per reel, rounded to an integer.",
                    "minimum": 0
                  },
                  "median": {
                    "type": "number",
                    "description": "Median number of comments.",
                    "minimum": 0
                  },
                  "min": {
                    "type": "number",
                    "description": "Minimum number of comments.",
                    "minimum": 0
                  },
                  "max": {
                    "type": "number",
                    "description": "Maximum number of comments.",
                    "minimum": 0
                  }
                },
                "required": [
                  "all",
                  "avg",
                  "median",
                  "min",
                  "max"
                ]
              },
              "views": {
                "type": "object",
                "properties": {
                  "all": {
                    "type": "integer",
                    "description": "Total number of views.",
                    "minimum": 0
                  },
                  "avg": {
                    "type": "number",
                    "description": "Average number of views per reel, rounded to an integer.",
                    "minimum": 0
                  },
                  "median": {
                    "type": "number",
                    "description": "Median number of views.",
                    "minimum": 0
                  },
                  "min": {
                    "type": "number",
                    "description": "Minimum number of views.",
                    "minimum": 0
                  },
                  "max": {
                    "type": "number",
                    "description": "Maximum number of views.",
                    "minimum": 0
                  }
                },
                "required": [
                  "all",
                  "avg",
                  "median",
                  "min",
                  "max"
                ]
              },
              "engagement": {
                "type": "object",
                "description": "Engagement performance metrics broken down by brand, including standard engagement metrics and views per follower.",
                "properties": {
                  "avgEngagementRate": {
                    "type": "number",
                    "description": "Average engagement rate per reel (excluding older pinned reels), rounded to 4th decimal place. <br />\n*Engagement Rate &#61; (Likes + Comments)/ Followers* <br />\n- This aggregate is recomputed against follower count, while the per-reel `engagementRate` values in `sponsoredReels` are divided by views. The two are therefore not directly comparable, and this figure is not the mean of those values.",
                    "minimum": 0
                  },
                  "likesPerFollower": {
                    "type": "number",
                    "description": "Average number of likes per follower, rounded to 4th decimal place.",
                    "minimum": 0
                  },
                  "commentsPerFollower": {
                    "type": "number",
                    "description": "Average number of comments per follower, rounded to 4th decimal place.",
                    "minimum": 0
                  },
                  "viewsPerFollower": {
                    "type": "number",
                    "description": "Average number of views per follower, rounded to 4th decimal place.",
                    "minimum": 0
                  },
                  "engagementConsistency": {
                    "type": "object",
                    "description": "Consistency of engagement performance of sponsored Instagram reels broken down by brands.",
                    "properties": {
                      "cv": {
                        "type": "number",
                        "description": "*cv &#61; Standard Deviation of Engagement Rate/Mean Engagement Rate* <br />\n- The value is rounded to 4th decimal place. <br />\n- Lower values indicate more consistent performance. <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "medianVsMean": {
                        "type": "number",
                        "description": "*medianVsMean &#61; Median Engagement Rate/ Mean Engagement Rate* <br />\n- The value is rounded to 4th decimal place <br />\n- Values closer to `1` indicate more consistent performance. <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "topBottomRatio": {
                        "type": "number",
                        "description": "*topBottomRatio &#61; avg(Top 3 Engagement)/avg(Bottom 3 Engagement)* <br />\n- The value is rounded to 4th decimal place. <br />\n- Lower ratios indicate more consistent performance. <br />\n- *A value of `0` indicates insufficient data.*",
                        "minimum": 0
                      },
                      "consistencyScore": {
                        "type": [
                          "integer",
                          "null"
                        ],
                        "description": "*consistencyScore &#61; 100 - [(cvScore*weight_cv) + (topBottomScore*weight_topBottom) + (medianVsMeanScore*weight_medianVsMean)]* <br />\n- The score is rounded to an integer. <br />\n- A higher score indicates more stable and consistent performance. <br />\n- Returns `null` when any of the three indicators (`cv`, `medianVsMean`, `topBottomRatio`) is `0`, indicating insufficient data.",
                        "minimum": 0,
                        "maximum": 100
                      },
                      "consistencyLevel": {
                        "type": [
                          "string",
                          "null"
                        ],
                        "enum": [
                          "high",
                          "moderate",
                          "low",
                          null
                        ],
                        "description": "A qualitative label based on the `consistencyScore`: <br />\n- high: 81 - 100 <br />\n- moderate: 51 - 80 <br />\n- low: 1 - 50 <br />\n- Returns `null` when `consistencyScore` is `null`, indicating insufficient data."
                      }
                    },
                    "required": [
                      "cv",
                      "medianVsMean",
                      "topBottomRatio",
                      "consistencyScore",
                      "consistencyLevel"
                    ]
                  }
                },
                "required": [
                  "avgEngagementRate",
                  "likesPerFollower",
                  "commentsPerFollower",
                  "viewsPerFollower",
                  "engagementConsistency"
                ]
              }
            },
            "required": [
              "likes",
              "comments",
              "views",
              "engagement"
            ]
          }
        },
        "required": [
          "brandName",
          "brandId",
          "brandIgIds",
          "sponsoredImages",
          "sponsoredReels",
          "sponsoredImagesPerformance",
          "sponsoredReelsPerformance"
        ]
      }
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/creatordb-app-instagram-sponsorship-data"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.