Capterra Ads
Last updated
Last updated
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.
Click the "Connect" button next to the Capterra logo in your settings.
In order to proceed you need to submit your Capterra API key.
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.
Once you've received the API key, paste it and Click "Connect". You are all set!
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.
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.
Date Filtering
The system calculates a startMoment based on the account’s lastPulledDate, going back 5 days to ensure data freshness.
Completing the Process
Once all records are inserted, the account’s lastPulledDate is updated to the current date, and the integration process concludes.