# CartStack Data Connector User Guide

> **Note:** Are you looking to streamline your e-commerce analytics and improve your cart abandonment recovery efforts? This guide will walk you through setting up and using the CartStack data source in Power My Analytics. By integrating CartStack with our platform, you'll be able to automate your data collection, centralize your metrics, and create powerful reports to drive your e-commerce success.

## Prerequisites

Before you begin, make sure you have:

- An active CartStack account
- Your CartStack Site ID and API key

Your Site ID and API key can be found under **Settings** > **Site ID/API Key** in CartStack's UI:

![](https://knowledge.powermyanalytics.com/application/sources/images/cartstack-data-connector-user-guide-1.png)

## Adding CartStack as a Data Source

1. Log in to your Power My Analytics hub.
2. Navigate to **Sources** from the main menu.
3. Click on **\+ Add new source**.
4. Select CartStack from the gallery of available sources.
5. Enter your CartStack **Site ID** and **API key**.
6. Click **Connect** to authenticate.

For more information on connecting your CartStack account, please see the article [How to Connect to CartStack](https://knowledge.powermyanalytics.com/application/sources/how-to-connect-to-cartstack/).

## Creating a Data Studio Report

Follow these steps to create a Data Studio report using your CartStack data:

1. In the Power My Analytics hub, go to **Reports** > **Data Studio**
2. Select CartStack under Create Data Studio Report (this will open the official Data Studio application in a new window)
3. Google Data Studio Configuration:

    - Step 1:

        - Name your data source (e.g., "CartStack - Your Company Name")
        - Choose your Power My Analytics hub from the dropdown
        - Optional: Leave "Use report template for new reports" checked to use the pre-built PMA demo template
        - Click **Next**

    - Step 2:

        - User Account: Select your CartStack account (for real data) or "Sample Account" (for sample data)
        - Click **Next**

    - Step 3:

        - Click **Connect** in the top right to finalize the data source configuration

    - Step 4:

        - Click **Create Report** in the top right

For a quick start, you can use our pre-built [CartStack demo template](https://lookerstudio.google.com/reporting/44130281-be1f-4b8b-b3e7-6fd148910d61).

## Key Reports and Fields

CartStack offers a wealth of data to analyze your e-commerce performance. Here are some key metrics you can report on:

- Key Performance Metrics: Open Rate, Click Rate, Conversion Rate, Recovered Carts, Unsubscribes, Recovered Revenue, Abandoned Carts, Emails Sent, Opens
- Recoveries Metrics: Revenue

For a complete list of available CartStack fields in Power My Analytics, visit our [Schema Explorer](https://hub.powermyanalytics.com/resources/schema/cartstack).

## Limitations and Important 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 this reason, only cached data will appear in a report or chart that pairs a unique field with the date dimension.
- Backfilling: An initial backfill of 24 months of data will be performed when you first connect your CartStack account as a data source.

### Unavailable Data

- Realtime data
- Custom fields

## Troubleshooting

See our article [Basic Troubleshooting](https://knowledge.powermyanalytics.com/application/troubleshooting/basic-troubleshooting/) for information on issues that may affect the CartStack connector.
