Mailchimp connector · Marketing
Mailchimp Power BI connector
The DigiData Mailchimp connector reads your marketing data from the connected Mailchimp account over OAuth2 and makes it available through OData and CSV. It never sends campaigns.
Here you will find the supported data, operation and availability of the connection.
Last reviewed:
The reason
Why connect Mailchimp to DigiData?
Connect Mailchimp over OAuth2 and sync audiences, members, tags, segments, campaigns, campaign reports with timeseries and email activity to DigiData. Automations and ecommerce data (stores, customers, orders and products) are included when your Mailchimp plan makes them available. Direct contact details such as email addresses and names are not stored; members are joined through the Mailchimp hash.
More about Mailchimp: mailchimp.com.
Connecting Mailchimp to Power BI in short
The Mailchimp connector is available and synchronizes supported tables such as Account and audiences, Members, tags and segments, Campaigns and reports and Email activity. DigiData offers these source records via OData for Power BI and Excel and via CSV for separate exports. The connector only supplies the entities listed on this page; source permissions, the source API, and your sync schedule determine which records and updates are available. You set up relationships, calculations and dashboards in the reporting tool.
Conditions
Availability, setup and conditions
- Availability
- Status: Available. The connector provides the entities listed on this page under "Available data".
- Setup
- Add Mailchimp in the DigiData dashboard and configure access to the source. DigiData confirms during setup which accounts and entities are available.
- Refresh
- Automatic synchronization based on the integration schedule. New source data will not appear until the source sync and then the Power BI refresh are complete.
- Security
- Secure OAuth2 connection per DigiData environment
- Limitations
- Only the listed entities are supported. Availability and timeliness depend in part on the source API and your rights in Mailchimp. DigiData supplies the source data to DigiData dashboards and the AI agent, and through OData and CSV to your own reporting tool. In Power BI or Excel you set up relationships and measures yourself.
- Price and trial period
- €50 per month for the Mailchimp connector, plus a €95 monthly DigiData platform fee, without start-up costs. You can test DigiData 14 days for free. View current prices.
What you get
What do you get with the Mailchimp link?
An overview of what DigiData does with your Mailchimp data:
Which data
Available Mailchimp data in DigiData
The following entities are automatically synchronized and available via OData or CSV export:
Use cases
What can you do with Mailchimp data?
Compare open and click rates per campaign
Track growth and unsubscribes per audience
Combine campaign results with revenue from your accounting
Analyze ecommerce revenue from Mailchimp campaigns
How it works
How does the Mailchimp link work?
Connect Mailchimp
Link your Mailchimp account via the DigiData dashboard. Safe and fast.
Select your dates
Check which accounts, environments, and entities are available for this resource. The options differ per connector.
Analyze in Power BI
Use the OData feed in Power BI, Excel or download CSV exports.
Build a Mailchimp dashboard with AI
Describe which overview of your Mailchimp data you want to see and the DigiData AI agent builds the dashboard, with filters, drilldowns and a presentation mode for TV screens or meetings. You do not need a Power BI model and you do not pay per viewer.
Mailchimp in Power BI
Each Mailchimp resource gets its own table with fixed columns, such as Mailchimp_Audiences, Mailchimp_Members, Mailchimp_Campaigns, Mailchimp_Reports and Mailchimp_EmailActivity. Join them in Power BI on audience, campaign and member ID.
Frequently asked questions
Questions about the Mailchimp integration
How do I connect Mailchimp to Power BI?
With DigiData you automatically synchronize Mailchimp data to an OData feed. In Power BI Desktop, choose 'Get Data', select OData feed and paste the DigiData URL. You can then load, combine and refresh the tables without building a Mailchimp API connection yourself.
How often is Mailchimp data refreshed?
DigiData synchronizes Mailchimp according to your integration schedule. The exact frequency and availability of new records depend on your settings and the source API.
What does the Mailchimp connection cost?
DigiData charges platform costs plus an amount per active integration. There are no start-up costs and you can test for 14 days for free. View the current price on the prices page.
Which Mailchimp data does DigiData sync?
Audiences, members, tags, segments, campaigns, reports with timeseries and email activity. Automations and ecommerce data are included when your Mailchimp plan makes them available.
Does DigiData store my contacts' email addresses?
No. Email addresses, names and other contact details are not stored. Members are joined through the pseudonymous Mailchimp hash.
Can DigiData send campaigns or change data?
No. The connector only reads reporting data and never sends campaigns.
Combine
Other integrations that may interest you
Most companies do not run on one package. Place Mailchimp next to your other sources, so that you have one report.
14 days free · no start-up costs
Ready to connect Mailchimp to DigiData?
Use the trial period to validate the available tables, synchronization and your reporting model with your own data.
