Overview
Pepperjam Ascend’s™ integration with Funnel.io enables brands to integrate affiliate marketing lifecycle data into their reporting source of truth. Funnel downloads the last 30 days of Ascend’s data each day, including:
-
Dimensions:
- Creative ID
- Creative Name
- Creative Type
- Publisher ID
- Publisher Name
-
Metrics
- Clicks: Count of clicks associated with the add
- Commission: Represents the total commission (Pepperjam + Publisher) associated with an order
- Impressions: count of impressions associated with the ad
- New to File: If an advertiser captures this information in their Pepperjam pixel, we will count the transactions where New to File = Yes
- Sales: Revenue
- Transactions: Order or lead count
Funnel’s data is comparable to what is found in Ascend’s Transaction Details report, but with the benefit of evaluating performance marketing data as a part of your overall marketing mix. Data is considered to be transaction summary based, not transaction history. This means that if a correction or adjustment is applied to a transaction, historical data may change if it is within your locking period.
Getting Started
Connect your account in 3 easy steps:
1. Sign into Funnel using your subscription credentials. If you don’t have a Funnel subscription, you can get started here. Navigate to the Data Sources page and select ‘+Data Sources’ to add a new data source.
2. Search for Pepperjam from Funnel’s 500+ data sources.
3. Enter your Pepperjam credentials and API Key. Your Pepperjam API Key can be found here: https://ascend.pepperjam.com/merchant/api/
Select the currency your program is set to in Ascend. If you’re not sure what currency you’re using, the Ascend Dashboard reportlet called “Program Status” has the currency symbol associated with your program.
Ascend Program Status reportlet:
Once connected, you’ll see Pepperjam listed as a data source in your Funnel account. Funnel will download 730 days of historic data the first time it connects to Pepperjam.
Validation
To validate Funnel data against data available in Ascend, navigate to the Data Explorer in Funnel.
- Select publisher ID, publisher name, creative type, creative ID, and creative name as your dimensions and limit your data to a specific date range.
- Next, open the Creative Performance by Publisher report in Ascend. Filter the report to the same date range.
- Compare totals. They should match exactly.
Data Translation
|
Funnel Variable Name |
Pepperjam Variable Name in Creative Performance by Publisher Report |
|
Creative ID |
CID |
|
Creative Name |
Creative Name |
|
Creative Type |
Creative Type |
|
Publisher ID |
Aff. ID |
|
Publisher Name |
Affiliate |
|
Impressions |
Impressions |
|
Clicks |
Clicks |
|
Transactions |
Transactions |
|
Sales |
Sales |
|
Commissions |
Publisher Commission + Site Commission |