Capterra Ads

HockeyStack's Capterra Ads integration pulls your campaign data into HockeyStack and connects it with your marketing, revenue, and product data. This allows you to track through your ad spend and ad insight data.

How to Connect

1. Click the "Connect" button next to the Capterra logo in your settings.

1. In order to proceed you need to submit your Capterra API key.

1. In order to get an API key from Capterra, you need to go through Capterra’s helpdesk/account manager. You can find their contact information by signing in to your Capterra account and clicking on "Account Settings". Their contact details are located in the grey box to the right.

1. Once you've received the API key, paste it and Click "Connect". You are all set!

What gets tracked as Metadata

Field Name	Description
account_id_hashed	A hashed representation of the API key for account identification.
type	The type of activity, fixed as 'paid-ads'.
date	The date of the report, based on date_of_report.
id	A unique ID generated by concatenating and hashing the channel, date, country, category, vendor name, and product name.
network	The advertising network, set as 'Capterra Ads'.
country	The lowercase 2-letter country code, derived from the country field using a lookup in countryCodes.
utm_source	The UTM source, derived by formatting the channel (e.g., 'Capterra' → 'capterra').
utm_campaign	The UTM campaign, derived by taking the category field and replacing spaces with underscores.
utm_medium	The UTM medium, set to 'cpc'.
avg_position	The average ad position (avg_position).
conversions	The number of conversions recorded.
clicks	The number of clicks recorded.
cost	The total cost of the clicks.

---

High-Level Flow of the Integration

1. Data Retrieval

   • The integration makes a GET request to the Capterra Ads API endpoint (https://public-api.capterra.com/v1/clicks) using the provided apiKey.

   • A scroll_id is used for paginated retrieval; if one is returned by the API, additional requests are made until no further scroll_id is provided.

2. Date Filtering

   • The system calculates a startMoment based on the account’s lastPulledDate, going back 5 days to ensure data freshness.

3. Completing the Process

   • Once all records are inserted, the account’s lastPulledDate is updated to the current date, and the integration process concludes.