# Data Overview

Coupler.io pulls five types of data from Blogger, each corresponding to a different part of your blog. Here's a breakdown of what's available in each entity and the fields you can work with.

## Entities

| Entity       | Description                                                            |
| ------------ | ---------------------------------------------------------------------- |
| **Posts**    | Published blog posts with content, titles, dates, labels, and metadata |
| **Pages**    | Standalone static pages within a blog                                  |
| **Comments** | Reader comments attached to posts                                      |
| **Blogs**    | Top-level blog configuration and metadata                              |
| **Users**    | Profile data for blog authors and admins                               |

***

#### Posts fields

| Field                | Description                          |
| -------------------- | ------------------------------------ |
| `id`                 | Unique post identifier               |
| `title`              | Post title                           |
| `content`            | Full HTML content of the post        |
| `published`          | Publication date and time            |
| `updated`            | Date the post was last updated       |
| `url`                | Permalink to the post                |
| `labels`             | Tags/categories assigned to the post |
| `author.displayName` | Name of the post author              |
| `author.id`          | Author's Google user ID              |
| `blog.id`            | Blog the post belongs to             |
| `replies.totalItems` | Total number of comments on the post |
| `status`             | Post status (live, draft, scheduled) |

#### Pages fields

| Field                | Description                   |
| -------------------- | ----------------------------- |
| `id`                 | Unique page identifier        |
| `title`              | Page title                    |
| `content`            | Full HTML content of the page |
| `published`          | Publication date              |
| `updated`            | Last updated date             |
| `url`                | Permalink to the page         |
| `author.displayName` | Page author name              |
| `status`             | Page status (live or draft)   |

#### Comments fields

| Field                | Description                           |
| -------------------- | ------------------------------------- |
| `id`                 | Unique comment identifier             |
| `content`            | Text of the comment                   |
| `published`          | Date and time the comment was posted  |
| `updated`            | Date comment was last updated         |
| `author.displayName` | Commenter's display name              |
| `author.id`          | Commenter's Google user ID            |
| `post.id`            | ID of the post the comment belongs to |
| `blog.id`            | Blog the comment belongs to           |
| `status`             | Comment status (live, spam, pending)  |

#### Blogs fields

| Field              | Description                     |
| ------------------ | ------------------------------- |
| `id`               | Unique blog identifier          |
| `name`             | Blog display name               |
| `description`      | Blog description                |
| `url`              | Blog homepage URL               |
| `published`        | Date the blog was created       |
| `updated`          | Last activity date              |
| `posts.totalItems` | Total number of published posts |
| `pages.totalItems` | Total number of static pages    |

#### Users fields

| Field         | Description                            |
| ------------- | -------------------------------------- |
| `id`          | Google user ID                         |
| `displayName` | User's display name                    |
| `url`         | Link to the user's Google profile      |
| `blogs`       | List of blogs associated with the user |

***

## Common field combinations

* **Content audit:** Posts `title` + `published` + `labels` + `replies.totalItems` — see what topics get the most engagement
* **Comment moderation log:** Comments `content` + `author.displayName` + `published` + `status` — review recent or flagged comments
* **Blog health snapshot:** Blogs `posts.totalItems` + `pages.totalItems` + `updated` — quickly assess activity across multiple blogs

## Use cases by role

{% tabs %}
{% tab title="Content creators" %}

* Export all posts with labels and comment counts to understand which topics resonate most
* Track your publishing cadence by pulling `published` dates into a Google Sheets calendar
* Use the **Append** transformation to combine posts from multiple blogs into a single content inventory
  {% endtab %}

{% tab title="Marketers" %}

* Pull post metadata into Looker Studio to visualize publishing frequency and topic distribution
* Join Blogger post data with Google Analytics exports to connect content performance to traffic
* Send post titles and content to ChatGPT or Claude for automatic tagging, SEO summaries, or content repurposing
  {% endtab %}

{% tab title="Developers & agencies" %}

* Sync blog and post data into BigQuery for long-term archiving and trend analysis
* Use the Users and Blogs entities to audit multi-author or multi-blog setups
* Automate comment moderation reporting by exporting Comments with status filters into a shared spreadsheet
  {% endtab %}
  {% endtabs %}

## Platform-specific notes

* The Blogger API returns post content as raw HTML — you may need to clean this in your destination if you're analyzing text
* `replies.totalItems` in the Posts entity reflects the total comment count but does not include individual comment details — pull the **Comments** entity separately for that
* Blogger's API does not return draft posts by default; only published content is accessible via the standard API key flow
* If you manage multiple blogs, each blog requires its own Blog ID — use the **Append** transformation in Coupler.io to consolidate data from several blogs into one dataset