Glew Integration Instructions

Pepperjam’s Ascend™ and Glew Integration Instructions

Overview
How it Works. Glew’s integration with Ascend™ integrates your affiliate marketing data-- account transactions, creatives, groups, publisher creatives, publisher performance and transactions—into your reporting source of truth.

Getting Started. To begin your integration, follow these steps:

• Log in to Ascend™
• Access your API Key:
• Ascend’s API requires an API key to authenticate all API requests. To get your API key, navigate to https://ascend.pepperjam.com/merchant/api/ and log into your Ascend account.

• This will display your API Key and version, which are unique to your account. Please copy and save both values - you will need to paste them into Glew.

• Note: We do not recommend selecting Generate New Key. Selecting Generate New Key will overwrite your existing key, perhaps breaking other integrations that leverage this key.

Review

• Please review the fields below before saving your Pepperjam integration. Any changes you make to the fields below will automatically update the previous fields. To save your integration, click Save Changes.
  • API Key:
  • Version:

Screenshots:

Understanding Ascend Data

Dimension Tables
These tables provide descriptive information about creatives, groups, and publishers

• Creative
  • Creative ID
  • Name
  • Type
• Groups
  • Group ID
  • Name
  • Publishers
• Publishers
  • Publisher ID
  • Name
  • Company
  • State
  • Website
  • Type

• Fact Tables

  The Pepperjam fact tables tie directly to reports available in the Ascend interface.

  Fact Table	Pepperjam Report Name	Pepperjam Support Article
  Fact_pepperjam_account_transactions	Payments + Fees	Payments and Fees Report
  Fact_pepperjam_creatives	Creative Performance	Creatives Report
  Fact_pepperjam_publisher_creatives	Creative Performance by Publisher	Creatives Report
  Fact_pepperjam_publisher_performance	Publisher Performance	Performance Reports
  Fact_pepperjam_transactions	Transaction History	Transaction History Reports
  Fact_pepperjam_transaction_items	Itemized Transactions	Itemized Report