Forum Discussion
Separating MailChimp data by month?
Not sure about mailchimp but would suggest not splitting send date, instead you can have a seperate date table that contains all date columns you need which is linked by send date.
PowerBi should remember the split steps on re-import but you won't need to do that if you have a date table like above.
Have you tried the mailchimp content pack?
https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-mailchimp/
Thanks, I'll work on using a table for the campaign information. It still doesn't help with the list data though, unfortunately.
I've used that content pack on the web version and while it gives me most of what I need it doesn't give me everything + that pack isn't the same when using PBI desktop. Web version has some awesome data I can use and so does desktop but each one has holes that the other could fill. I guess it's to be expected though seeing as how the MailChimp pack is still in beta.
- I'll have a look at the mailchimp table structures when I get into work tomorrow, bet someone beats me to it though, lots of knowledgeable folks on here
Awesome, I look forward to hopefully ending this headache.
Wasn't able to find the table structures on the web without signing up for mailchimp, can you post some anonymised examples?