Connect Instacart Ads to Power BI

Setup guide

How to Connect Instacart to Power BI

Connect your Instacart account, set up Power BI, and run your first report.

Connect Instacart Ads to Adzviser

Connect your Instacart Ads account in an Adzviser workspace and select the advertiser you want to analyze.

Set up Power BI

Set up the Adzviser Power BI Desktop connector, authorize access, and select your workspace, account, dates, and fields. Power BI setup guide →

Run your first report

Select Spend, Impressions, Clicks and a date range. Use the data in Power BI to analyze trends and build reports.

Why this connection

Why Connect Instacart Ads to Power BI?

Use Power BI to report on ad spend, attributed sales, and new-to-brand performance from your connected Instacart account.

What you can do

Review campaign ROAS

Compare spend and attributed sales to find the campaigns contributing most to revenue.

Track new-to-brand sales

See which products contribute new-to-brand sales alongside total attributed sales.

Compare ad formats

Review Sponsored Product, Display, and Video performance using the fields supported by each format.

YOUR REPORTING WORKFLOW

Build your Instacart Ads report in Power BI

Load reporting data into Power BI for interactive dashboards. Add it to your model alongside sales, CRM, or other advertising data.

Load a reporting table

Import Spend, Impressions, Clicks, Attributed sales linear, NTB attributed sales linear by Campaign ID, Campaign name, Ad group ID, Ad format for use in your charts and measures.

Add tables and measures

Connect a date table and add measures for your report. Keep different reporting levels in separate fact tables.

Publish and schedule refreshes

Publish your dashboard, then follow the Query URL setup for scheduled refresh in Power BI Service. This feature requires account activation.

Field availability depends on ad format. Keep linear and last-touch attribution separate when comparing sales or ROAS.

Reporting coverage

Instacart reporting coverage for Power BI

48supported metrics

54supported breakdowns

Complete field catalogBrowse all metrics & breakdowns for Instacart

Trusted by Agencies, Freelancers, and Founders

See how enterprises are using Adzviser to visualize their Instacart data in Power BI.

Ryan Whiteside

Adzviser is the Supermetrics replacement we've been looking for. Adzviser delivers the same essential functionality at a much better price point, with far superior customer support. The added bonus of a ChatGPT connector allows for seamless data analysis in a way that enhances workflow efficiency.

Digital Marketing DirectorTwo Wheels Marketing

Jared Laidlaw

I appreciate Adzviser's per-client workspace setup, which simplifies organizing data sources compared to setting them up via channels. The customer support is excellent and responsive, addressing my issues swiftly. The pricing is competitive and scales nicely with business growth, which is crucial for me.

Managing DirectorOrchard Financial Marketing

Adam Orris

It is so simple to create your integration with all the supplied connectors. I also love the ability to send data to Gsheets and Looker for automation. The best part is being able to chat with your data inside of ChatGPT's. Adzviser really helps you along the way as well. The customer support is superb.

Director of Data and AnalyticsDisruptive Advertising

Saar Bell

Adzviser completely transformed the way I handle marketing data! Connecting all my sources to Google Sheets, Looker, and ChatGPT was unbelievably simple — no endless setup or technical headaches. Everything runs fast, accurate, and at a fraction of the cost compared to other tools I’ve tried. The customer support is extremely personal and responsive.

Company OwnerBellaPOINT

Powering data-driven decisions for 15K+ companies across 100 countries

Instacart to Power BI Integration FAQs

Spend, impressions, clicks, attributed sales, and new-to-brand performance, with campaign, ad-group, or product detail. Sponsored Product, Display, and Video reports are supported; available fields vary by format. View supported Instacart Ads fields →

Connect your Instacart Ads account in an Adzviser workspace and select the advertiser you want to analyze. Set up the Adzviser Power BI Desktop connector, authorize access, and select your workspace, account, dates, and fields. Power BI setup guide →

Yes. Ask Adzviser to activate the Query URL feature for your account, then configure the query and a refresh schedule in Power BI Service. The scheduled-refresh guide covers this setup separately from the Desktop connector. Power BI scheduled-refresh guide →

Yes. Load other connected sources into Power BI and combine them in your report model. You can analyze advertising performance alongside sales, CRM data, or budget targets already in your reports.

Supercharge your data-driven decisions
with Adzviser

Start 14-day trial

Have a question?

Talk to us