AdRoll Ads

What Data Gets Tracked as Metadata

The following fields are tracked and stored during the integration process:

Field	Description
account_id_hashed	A hashed version of the account ID for secure storage.
type	The type of tracked data, such as paid-ads.
date	The date of the ad activity, formatted as YYYY-MM-DD.
id	A unique identifier for each data row, generated as an MD5 hash.
data	A JSON object containing detailed metadata about the campaign and ad.
account_id	The original account ID associated with the ad.
network	AdRoll Ads
country	The country associated with the advertiser account.
campaign_id	The unique ID of the campaign.
campaign_name	The name of the campaign.
adgroup_id	The unique ID of the ad group.
adgroup_name	The name of the ad group.
ad_id	The unique ID of the ad.
ad_name	The name of the ad.
utm_source	The source of the traffic, such as adroll.
utm_campaign	The campaign name, URL-encoded if necessary.
utm_medium	The medium of the traffic, such as paid.
utm_content	Content-specific identifier for the campaign.
utm_term	The keyword associated with the campaign, if applicable.
impressions	The total number of impressions for the ad.
clicks	The total number of clicks for the ad.
cost	The total cost of the ad campaign in the specified currency.
currency	The currency in which the ad costs are measured (e.g., USD).

High-Level Integration Flow

1. Validation:

   • We validate the apiKey to ensure it is associated with an advertiser account.

   • The start of the integration process is logged for debugging and tracking purposes.

2. Ad Data Retrieval:

   • Campaign, ad group, and ad data are fetched using the AdRoll API.

   • Performance metrics, including impressions, clicks, and costs, are retrieved for each campaign and ad.

3. Analytics and Data Processing:

   • The integration processes raw data into a structured format for metadata tables

4. Data Insertion:

   • Formatted data is stored in the metadata system using insertToMetadata.

   • The account’s lastPulledDate is updated to avoid duplicate data processing.

Notes and Caveats

• Token Handling:

  • The integration uses accessToken and refresh tokens to authenticate all requests to the AdRoll Ads API