Instacart Source Data

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

Column Name	Data type	Description
upc	String	Upc
product_name	String	Product name
product_url	String	Product url
catalog_product_id	String	Catalog product id
product_image_url	String	Product image url
product_size	String	Product size
product_unit_count	String	Product unit count
brand_name	String	Brand name
product_id	Integer	Product id
account_id	Integer	Intentwise account id
updated_at	Timestamp	Updated at date and time in UTC time format