# Sponsored Ads

## **Data Source**

To enable the Instacart Sponsored Ads Reports, the datasource: **Instacart Ads** has to be enabled on the Intentwise Platform

### Account Report

​Table Name: ad\_account\_report  

| Column Name            | Data type | Description                                                                                                                 |
| ---------------------- | --------- | --------------------------------------------------------------------------------------------------------------------------- |
| date                   | Date      | Report generated date                                                                                                       |
| impressions            | Numeric   | Impressions                                                                                                                 |
| clicks                 | Integer   | Number of ad clicks                                                                                                         |
| spend                  | Numeric   | Amount spend                                                                                                                |
| ctr                    | Numeric   | Click-through-rate (CTR), calculated by dividing clicks by productImpressions for Product and Product Category report types |
| cpc                    | Numeric   | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees                                    |
| attributed\_quantities | Numeric   | Attributed quantities                                                                                                       |
| attributed\_sales      | Numeric   | Sales revenue attributed to a click or impression; exclusive of assistedSales                                               |
| roas                   | Numeric   | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees                      |
| analytics\_type        | String    | Analytics type                                                                                                              |
| account\_id            | Integer   | Intentwise account id                                                                                                       |
| updated\_at            | Timestamp | Updated date and time in UTC time format                                                                                    |

### Adgroup Attributes

Table:  ad\_adgroup\_attributes

| Column Name        | Data type | Description                              |
| ------------------ | --------- | ---------------------------------------- |
| ad\_group\_id      | UUID      | Adgroup Id                               |
| name               | String    | Name of the Ad group                     |
| enabled            | Boolean   | Adgroup enabled                          |
| ad\_group\_status  | String    | Status of Ad group                       |
| default\_bid       | Numeric   | Default bid                              |
| meta               | JSON      | meta                                     |
| account\_id        | Integer   | Intentwise account id                    |
| suggested\_bid     | Numeric   | Suggested bid                            |
| bid\_strength      | String    | Bid strength                             |
| min\_bid           | Numeric   | Minimum bid                              |
| product\_count     | Integer   | Product count                            |
| campaign\_id       | UUID      | Campaign Id                              |
| uncompetitive\_bid | Numeric   | Uncompetitive bid                        |
| is\_confident\_bid | Boolean   | Bid confident status                     |
| bid\_rec\_type     | String    | Bid rec type                             |
| updated\_at        | Timestamp | Updated date and time in UTC time format |
|                    | ​         |                                          |

### Adgroup Keyword Attributes

Table: ad\_adgroup\_keyword\_attributes

| Column Name                | Data type | Description                              |
| -------------------------- | --------- | ---------------------------------------- |
| ad\_group\_keyword\_id     | UUID      | Adgroup  keyword id                      |
| keyword                    | String    | Keyword for Ad                           |
| cpc\_bid                   | Numeric   | Cost-per-click (CPC) id                  |
| matching\_type             | String    | Matching type                            |
| ad\_group\_keyword\_status | String    | Adgroup keyword status                   |
| ad\_group\_id              | UUID      | Adgroup id                               |
| account\_id                | Integer   | Intentwise account id                    |
| suggested\_bid             | Numeric   | Suggested bid                            |
| bid\_strength              | String    | Bid strength                             |
| min\_bid                   | Numeric   | Minimum bid                              |
| keyword\_type              | String    | Keyword type                             |
| updated\_at                | Timestamp | Updated date and time in UTC time format |

### Adgroup Keyword Report

Table:  ad\_adgroup\_keyword\_report  

| Column Name            | Data type | Description                                                                                                                  |
| ---------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------- |
| ad\_group\_keyword\_id | UUID      | Adgroup  keyword id                                                                                                          |
| date                   | Date      | Date                                                                                                                         |
| impressions            | Numeric   | Impressions                                                                                                                  |
| clicks                 | Numeric   | Adgroup clicks                                                                                                               |
| spend                  | Numeric   | Amount spend for adgroup                                                                                                     |
| ctr                    | Numeric   | Click-through-rate (CTR) , calculated by dividing clicks by productImpressions for Product and Product Category report types |
| cpc                    | Numeric   | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees                                     |
| attributed\_quantities | Numeric   | Attributed quantities                                                                                                        |
| attributed\_sales      | Numeric   | Sales revenue attributed to a click or impression; exclusive of assistedSales                                                |
| roas                   | Numeric   | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees                       |
| analytics\_type        | String    | Analytics type                                                                                                               |
| account\_id            | Integer   | Intentwise account id                                                                                                        |
| ad\_group\_id          | UUID      | Adgroup Id                                                                                                                   |
| updated\_at            | Timestamp | Updated date and time in UTC time format                                                                                     |

### Adgroup Product Attributes

Table:  ad\_adgroup\_product\_attributes

| Column Name                | Data type | Description                                 |
| -------------------------- | --------- | ------------------------------------------- |
| ad\_group\_product\_id     | UUID      | Adgroup product id                          |
| enabled                    | Boolean   | Adgroup enabled status                      |
| product\_name              | String    | Product name                                |
| product\_size              | String    | Product size                                |
| product\_image\_url        | String    | Product image URL                           |
| upc                        | String    | Upc                                         |
| ad\_group\_product\_status | String    | Adgroup product status                      |
| ad\_group\_id              | UUID      | Adgroup Id                                  |
| account\_id                | Integer   | Intentwise account id                       |
| updated\_at                | Timestamp | Updated at date and time in UTC time format |

### Adgroup Product Report

Table:  ad\_adgroup\_product\_report

| Column Name            | Data type | Description                                                                                                                  |
| ---------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------- |
| ad\_group\_product\_id | UUID      | Adgroup product id                                                                                                           |
| date                   | Date      | Date                                                                                                                         |
| impressions            | Numeric   | Impressions                                                                                                                  |
| clicks                 | Numeric   | Adgroup product clicks                                                                                                       |
| spend                  | Numeric   | Amount spend on Adgroup                                                                                                      |
| ctr                    | Numeric   | Click-through-rate (CTR) , calculated by dividing clicks by productImpressions for Product and Product Category report types |
| cpc                    | Numeric   | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees                                     |
| attributed\_quantities | Numeric   | Attributed quantities                                                                                                        |
| attributed\_sales      | Numeric   | Sales revenue attributed to a click or impression; exclusive of assistedSales                                                |
| roas                   | Numeric   | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees                       |
| analytics\_type        | String    | Analytics type                                                                                                               |
| account\_id            | Integer   | Intentwise account id                                                                                                        |
| ad\_group\_id          | UUID      | Adgroup Id                                                                                                                   |
| updated\_at            | Timestamp | Updated at date and time in UTC time format                                                                                  |

### Adgroup Report

Table:  ad\_adgroup\_report  

| Column Name            | Data type | Description                                                                                                                  |
| ---------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------- |
| ad\_group\_id          | UUID      | Adgroup id                                                                                                                   |
| date                   | Date      | Date                                                                                                                         |
| impressions            | Numeric   | Impressions                                                                                                                  |
| clicks                 | Numeric   | Adgroup clicks                                                                                                               |
| spend                  | Numeric   | Amount spend on Adgroup                                                                                                      |
| ctr                    | Numeric   | Click-through-rate (CTR) , calculated by dividing clicks by productImpressions for Product and Product Category report types |
| cpc                    | Numeric   | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees                                     |
| attributed\_quantities | Numeric   | Attributed quantities                                                                                                        |
| attributed\_sales      | Numeric   | Sales revenue attributed to a click or impression; exclusive of assistedSales                                                |
| roas                   | Numeric   | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees                       |
| analytics\_type        | String    | Analytics type                                                                                                               |
| account\_id            | Integer   | Intentwise account id                                                                                                        |
| updated\_at            | Timestamp | Updated at date and time in UTC time format                                                                                  |

### Campaign Adgroup Bids

​Table:  ad\_campaign\_adgroup\_bids  

| Column Name        | Data type | Description                                 |
| ------------------ | --------- | ------------------------------------------- |
| campaign\_id       | UUID      | Campaign id                                 |
| ad\_group\_bid\_id | Integer   | Adgroup bid id                              |
| account\_id        | Integer   | Intentwise account id                       |
| updated\_at        | Timestamp | Updated at date and time in UTC time format |

### Campaign Attributes

Table:  ad\_campaign\_attributes  

| Column Name                | Data type | Description                                 |
| -------------------------- | --------- | ------------------------------------------- |
| campaign\_id               | UUID      | Campaign id                                 |
| name                       | String    | Name of the campaign                        |
| enabled                    | Boolean   | State of the campagign                      |
| scheduled\_start\_at       | Timestamp | Campaign scheduled start date and time      |
| scheduled\_end\_at         | Timestamp | Campaign scheduled end date and time        |
| scheduled\_start\_at\_date | Date      | Campaign scheduled start date               |
| scheduled\_end\_at\_date   | Date      | Campaign scheduled end date                 |
| campaign\_type             | String    | Campagin type                               |
| purchase\_order            | String    | Purchase order                              |
| campaign\_status           | String    | Status of the campaign                      |
| budget                     | Numeric   | Budget of the campagin                      |
| spend                      | Numeric   | Amount spend on campaign                    |
| daily\_cap\_enabled        | Boolean   | Status of daily cap enabled                 |
| daily\_budget              | Numeric   | Daily budget of the campagin                |
| memo                       | String    | Memo                                        |
| objective                  | String    | Objective                                   |
| objective\_custom          | String    | Custom objective                            |
| at\_risk\_meta             | JSON      | At risk meta                                |
| account\_id                | Integer   | Intentwise account id                       |
| is\_deleted                | Boolean   | Is deleted                                  |
| pacing\_method             | String    | Pacing method                               |
| target\_daily\_budget      | Numeric   | Target daily budget                         |
| budget\_type               | String    | Budget type                                 |
| updated\_at                | Timestamp | Updated at date and time in UTC time format |

### Campaign Report

Table:   ad\_campaign\_report  

| Column Name            | Data type | Description                                                                                                                  |
| ---------------------- | --------- | ---------------------------------------------------------------------------------------------------------------------------- |
| campaign\_id           | UUID      | Campaign id                                                                                                                  |
| date                   | Date      | Date                                                                                                                         |
| impressions            | Numeric   | Impressions                                                                                                                  |
| clicks                 | Numeric   | Clicks                                                                                                                       |
| spend                  | Numeric   | Spend                                                                                                                        |
| ctr                    | Numeric   | Click-through-rate (CTR) , calculated by dividing clicks by productImpressions for Product and Product Category report types |
| cpc                    | Numeric   | Cost-per-click (CPC), calculated by dividing spend by clicks; inclusive of platform fees                                     |
| attributed\_quantities | Numeric   | Attributed quantities                                                                                                        |
| attributed\_sales      | Numeric   | Sales revenue attributed to a click or impression; exclusive of assistedSales                                                |
| roas                   | Numeric   | Return-on-ad-spend (ROAS), calculated by dividing attributedSales by spend; inclusive of platform fees                       |
| analytics\_type        | String    | Analytics type                                                                                                               |
| account\_id            | Integer   | Intentwise account id                                                                                                        |
| updated\_at            | Timestamp | Updated at date and time in UTC time format                                                                                  |

### Product

Table:  ad\_product  

<table><thead><tr><th>Column Name</th><th width="241.79992675781253">Data type</th><th>Description</th></tr></thead><tbody><tr><td>upc</td><td>String</td><td>Upc</td></tr><tr><td>product_name</td><td>String</td><td>Product name</td></tr><tr><td>product_url</td><td>String</td><td>Product url</td></tr><tr><td>catalog_product_id</td><td>String</td><td>Catalog product id</td></tr><tr><td>product_image_url</td><td>String</td><td>Product image url</td></tr><tr><td>product_size</td><td>String</td><td>Product size</td></tr><tr><td>product_unit_count</td><td>String</td><td>Product unit count</td></tr><tr><td>brand_name</td><td>String</td><td>Brand name</td></tr><tr><td>product_id</td><td>Integer</td><td>Product id</td></tr><tr><td>account_id</td><td>Integer</td><td>Intentwise account id</td></tr><tr><td>updated_at</td><td>Timestamp</td><td>Updated at date and time in UTC time format</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.intentwise.com/iac-source-data/instacart-source-data/sponsored-ads.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.