How to make a report country senstive through Marketo ?

[MMundra1]

Hi All,

I have created an event which primarily targets on 5 Asia countries - India, China, Korea, Taiwan, Japan. Now,  the stakeholders wants 6 reports (India, China, Korea, Taiwan, Japan, and all OTHER countries) in Excel format. For that, I created a people performance report and grouped by Country and created custom columns -  for 5 Asia countries and for Rest of the World (Others). Please refer snapshot below: 

Now,  they want to  send off to each country leadership on daily basis, while also sensitive as to not allow each country to see each others (hence separate reports). Is there a way we can accomplish this in an automated way using Marketo or it can be done via Excel advanced filters only ?

[Darshil_Shah1 · Accepted solution]

I don't think you can send a fragment of the report via the automated way (i.e., through the Report subscriptions). IMO you should create separate reports for each country and set up the reporting subscriptions for the respective stakeholder. If you create separate reports for each country to send to the respective regional leaders/stakeholders, you need not group people by country (could use some other relevant criteria). I wouldn't recommend deleting your existing report, as you have an aggregated view of people grouped by the country that your global stakeholder/team could view instead of going through individual reports and then combining data.

[MMundra1]

Thanks for confirming Darshil !