ISVforce Guide

ISVforce Guide: Build and Distribute AppExchange Solutions
Get Ready to Distribute on AppExchange
Use Managed Packages to Develop Your AppExchange Solution
Manage Orgs with Environment Hub
Architectural Considerations for Group and Professional Editions
Security Requirements for AppExchange Partners and Solutions
Pass the AppExchange Security Review
Manage Your AppExchange Listings
Prepare to List Your Solution on AppExchange
Create Your AppExchange Listing
Grow Your AppExchange Business
Manage Your Published Listings
Measure Listing Performance with AppExchange Marketplace Analytics
AppExchange Marketplace Analytics Overview
Activity Summary in AppExchange Marketplace Analytics
Filtering in AppExchange Marketplace Analytics
Visualizations in AppExchange Marketplace Analytics
CSV Files in AppExchange Marketplace Analytics
What’s the Difference Between Lead Events and Leads in AppExchange Marketplace Analytics?
Get Started with AppExchange Marketplace Analytics
AppExchange Marketplace Analytics FAQs
Track Package Usage with AppExchange App Analytics
Sell on AppExchange with Checkout
Report Orders to Salesforce with the Channel Order App
Provide Free Trials of Your AppExchange Solution
OEM User License Guide
PDF

Newer Version Available

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

CSV Files in AppExchange Marketplace Analytics

You can export data from AppExchange Marketplace Analytics in comma-separated value (.csv) format. When you export data, Marketplace Analytics creates a separate .csv file for each dashboard visualization.

We format .csv files as follows.

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

Note

  • 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 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.
  • The global filter is set to show data for the last 30 days.
  • The local filters are set to show visits by day for these traffic sources: AppExchange Explore and AppExchange Search.
1Date,Source,Activity,Count of Activity
22019-01-01,AppExchange Explore,Visits,25
32019-01-01,AppExchange Search,Visits,50
42019-01-02,AppExchange Explore,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.
  • The global filter is set to show data for the last 30 days.
  • The local filters are 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.
  • The global filter is set to show data for the last 30 days.
  • The local filter is 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.
  • The global filter is set to show data for the last 30 days.
  • The local filter is 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.
  • The global filter is set to show data for the last 30 days.
  • The local filter is 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.
  • The global filter is set to show data for the last 30 days.
  • The local filter is 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. Learn 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.
  • The global filter is set to show data for the last 30 days.
  • The local filter is 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