StackAdapt Data Connector User Guide

StackAdapt Data Connector User Guide

Info
Get valuable insights into your StackAdapt advertising campaigns and performance marketing by connecting your StackAdapt account to Power My Analytics. This guide will walk you through setting up your StackAdapt account as a data source and creating reports to present your data.

Prerequisites

Before connecting StackAdapt to Power My Analytics, ensure you have:
  1. A StackAdapt account
  2. The API key for your StackAdapt account

Find Your StackAdapt API Key

You will need to enter your API key in Power My Analytics when connecting your StackAdapt account as a data source. To find the API key for your StackAdapt account:
  1. Sign in to your StackAdapt account at https://www.stackadapt.com/login
  2. Go to your Account Settings > API Integration.
  3. Find your API key and copy it.

Adding StackAdapt as a Data Source

  1. Go to your Power My Analytics hub and select Sources from the main menu.
  2. Click + Add new source and choose StackAdapt from the gallery of data sources.
  3. Enter the API key that you obtained from StackAdapt.
  4. Click Connect to authenticate and finish adding your StackAdapt account as a data source.
For more information on connecting your StackAdapt account, please see How to Connect to StackAdapt.

Creating a Data Studio Report

Follow these steps to create a Data Studio report using your StackAdapt data:
  1. In the PMA hub, navigate to Reports > Data Studio
  2. Select StackAdapt under Create Data Studio Report (this will open the official Data Studio application in a new window)
    1. Step 1:
      1. Name your data source (e.g., "StackAdapt - Business Name")
      2. Power My Analytics Hub: Choose your PMA hub from the dropdown
      3. Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      4. Click Next
    2. Step 2:
      1. User Account: Select your StackAdapt account (for real data) or "Sample Account" (for sample data)
      2. Click Next
    3. Step 3:
      1. Click Connect (top right) to complete the data source configuration
    4. Step 4:
      1. Click Create Report (top right)

Key Reports and Fields

The StackAdapt connector provides access to a variety of advertising and audience data, including:
  • Lists Metrics: Performance data for your audience lists
  • Automations Metrics: Automated campaign performance data
  • Campaign Performance Metrics: Comprehensive campaign performance analytics
  • Statistics: Detailed statistical data for your StackAdapt campaigns
For a full list of available StackAdapt fields in Power My Analytics, visit the Schema Explorer.

Limitations and Considerations

  • Cached Data Requests with Unique Metrics and Date Dimension: When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see Understanding Cached and Live Data Requests.
  • Backfilling: Power My Analytics performs an initial backfill of 24 months of historical data when you first connect your StackAdapt account as a data source.
  • ROAS (Return on Ad Spend): ROAS is calculated as Conversion Revenue divided by Cost. If you're comparing this figure to another platform's StackAdapt integration and expecting a different number, note that StackAdapt's own "Revenue" figure includes advertiser margin, not just conversion value; Power My Analytics calculates ROAS from actual conversion revenue, so it reflects true return on ad spend.
Notes
If your StackAdapt account doesn't have conversion tracking configured, ROAS will show as blank or 0. This is expected and not an error — set up conversion tracking in StackAdapt to see a ROAS value.

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the StackAdapt connector.