Newer Version Available

This content describes an older version of this product. View Latest

Marketplace Analytics CSV Files

You can export data from the Marketplace Analytics dashboard in comma-separated value (.csv) format. When you export data, Marketplace Analytics creates a separate .csv file for each dashboard visualization and then packages all the files in a .zip file.
We format .csv files as follows.
  • The first row is the header and provides column names. Subsequent rows represent records.
  • Within rows, values are separated by commas.
  • Negative values are prefixed with a minus sign.

Activity Summary by Region and AMP Performance Timeline data isn’t available in .csv format.

Note

Activity Source Timeline File

Provides data from the Activity Source Timeline visualization with your global and local filter selections applied.

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filters set to show visits by day for these traffic sources: AppExchange Featured and AppExchange Search.
1Date,Source,Activity,Count of Activity
22019-01-01,AppExchange Featured,Visits,25
32019-01-01,AppExchange Search,Visits,50
42019-01-02,AppExchange Featured,Visits,30
52019-01-02,AppExchange Search,Visits,60

Customer Engagement File

Provides data from the Customer Engagement visualization with your global and local filter selections applied.

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filters set to show resource views by day.
1Date,Activity,Count of Activity
22019-01-01,Customization Guide,10
32019-01-01,Datasheet,20
42019-01-02,Customization Guide,20
52019-01-02,Datasheet,40

Activity Sources File

Provides data from the Activity Sources visualization with your global and local filter selections applied.

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filter set to show visits.
1Source,Activity,Count of Activity,Percentage of Total Activity,Rank
2AppExchange Browse,Visits,500,20.41,1
3AppExchange Categories,Visits,450,18.37,2
4AppExchange Search,Visits,400,16.33,3
5AppExchange Recommended,350,14.29,4

For brevity, this sample shows only four traffic sources: AppExchange Browse, AppExchange Categories, AppExchange Search, and AppExchange Recommended. The file that you export from your dashboard provides all traffic sources.

Note

Top AppExchange Searches File

Provides data from the Top AppExchange Searches visualization with your global and local filter selections applied.

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filters set to show the top search terms associated with visits and demos.
1Search Term,Activity,Count of Activity
2Geolocation,Visits,50
3Geolocation,Demos,40
4Maps,Visits,30
5Maps,Demos,20

Lead Events Timeline File

Provides data from the Lead Events Timeline visualization with your global and local filter selections applied.

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filter set to show Get It Now clicks and demos.
1Date,Lead Type,Count of Leads
22021-05-03,Get It Now,31
32021-05-03,Watch Demo,3
42021-05-04,Get It Now,40
52021-05-04,Watch Demo,8

Lead Events File

Provides data from the Lead Events visualization with your global and local filter selections applied.

Example

This example shows the header row and two rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filter set to show Get It Now clicks and demos.
1Lead Type,Count of Leads,Percentage of Total Leads
2Get It Now,666,87.6
3Watch Demo,94,12.4

Chat Engagement File

Provides data from the Chat Engagement visualization with your global and local filter selections applied.

AppExchange Chat is required to view chat data in Marketplace Analytics. This feature is available to eligible Salesforce partners through the AppExchange Marketing Program (AMP). Learn more about AppExchange Chat in the Salesforce Partner Community.

Note

Example

This example shows the header row and four rows of sample data. These filters were applied.
  • Global filter set to show data for the last 30 days.
  • Local filter set to show conversations.
1Date,Activity,Type,Total for Activity
22021-05-03,Conversations,Chatbot Conversations,26
32021-05-03,Conversations,Human Conversations,4
42021-05-04,Conversations,Chatbot Conversations,22
52021-05-04,Conversations,Human Conversations,2