Connect to Marketo with Power BI
The Power BI content pack for Marketo allows you to gain insights into your Marketo account with data around Leads and their activities.Creating this connection retrieves your data and automatically provides a dashboard and related reports based on that data.
Connect to the Marketo content pack for Power BI.
How to connect
Select Get Data at the bottom of the left navigation pane.
In the Services box, select Get.
Select Marketo > Get.
Enter the Marketo REST endpoint supplied to you by Marketo or your Marketo admin, and select Next.
Read more about the Marketo REST endpoint: http://developers.marketo.com/documentation/rest/endpoint-url/ .
Using the Basic Authentication Method, enter the Client ID as the Username and the Client Secret as the Password. Client ID and Client Secret are available in Marketo or from your marketo admin (http://developers.marketo.com/documentation/rest/custom-service/).
This gives the *Marketo for Power BI *content pack access to your Marketo analytics data and allows you to analyze the data in Power BI. The data is refreshed once a day.
Once connected to your Marketo account, a dashboard with all your data is loaded:
- Try asking a question in the Q&A box at the top of the dashboard
- Change the tiles in the dashboard.
- Select a tile to open the underlying report.
- While your dataset will be schedule to refreshed daily, you can change the refresh schedule or try refreshing it on demand using Refresh Now
The following data is available from Marketo in Power BI where the activity occurred between today and one year ago:
|EmailActivities||Data about email sent to leads/contacts, with details about devices, categories, bounced count and percentage, clicked count and percentage, opened count and percentage, and program name. The Email Activities as shown in Power BI is an absolute email deliverability report, it does not apply any additional logic to the data. You might see some different results between the Marketo client and Power BI because of this.|
|ProgramActivites||Data on programs that have had a change a Status. This includes details such as: Reason, Success, Program acquisition count and percentage, and Program success count and percentage.|
|WebPageActivities||Data from user web page visits, including search agent, User agent, web page and hour of day.|
|Datetable||Dates from today and the past year. Allows you to analyze your Marketo data by date.|
|Leads||Lead information like company, revenue size, number of employees, country, industry, Lead score and Lead status. The leads are retrieved based on their presence in the email, program, and webpage activities data.|
All dates are in UTC. Depending on which time zone your account is in, dates my vary (similar as is seen in the Marketo client)
- The Marketo account you use for connecting has permission to access leads and activities.
- Sufficient API calls available to connect to the data. Marketo has an API for each account. When the limit is reached, you won't be able to load data into Power BI.
API Limit Details
Importing data from Marketo uses Marketo APIs. Every customer of Marketo has a total limit of 10,000 API calls per day that are shared between all applications that use the Marketo APIs. You may use the APIs for other integrations as well as the Power BI integration. For more information on the APIs see: http://developers.marketo.com/documentation/rest/.
The amount of API calls Power BI makes to Marketo depends on the amount of data in your Marketo account. Power BI imports all Leads and Activities for the last year. Here is an example of data from Marketo and the amount of API calls that are used by Power BI when importing:
|Data Type||Number of Rows||API Calls|
|Total API Calls||2,200|