Snapchat Ads

Data Replication

For Teams Created	Default Ingestion Frequency	Minimum Ingestion Frequency	Maximum Ingestion Frequency	Custom Frequency Range (in Hrs)
Before Release 2.21	3 Hrs	1 Hr	24 Hrs	1-24
After Release 2.21	6 Hrs	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours as an integer value. For example, 1, 2, or 3 but not 1.5 or 1.75.

• Historical Data: The first run of the Pipeline ingests historical data for the selected reports and objects on the basis of the historical sync duration specified at the time of creating the Pipeline and loads it to the Destination. Default duration: 1 Year.

• Incremental Data: Once the historical load is complete, all new and updated records are ingested as per the ingestion frequency.

  • For objects, Hevo performs full load to capture any data changes.

  • For reports, Hevo incrementally fetches data up to the previous day (as per the Snapchat Ads account’s timezone).

• Refresher Data: Daily Reports are refreshed once a day, and hourly reports are refreshed once every 6 hours. The refresher window depends on the attribution window you select. For example, if you select a 28 day window, Hevo refreshes the daily report data once a day, and the hourly report data once every 6 hours for the past 28 days.

Custom frequency for Full Load objects

Hevo allows you to set the ingestion frequency for Full Load objects separately from the Pipeline ingestion frequency. You can reduce your Events quota consumption by ingesting Full Load objects at a lower frequency without affecting other objects in the Pipeline. Read Query Modes and Events Quota Consumption to know how different query modes affect your Events quota consumption.

You can identify the Full Load objects in the Pipelines Detailed View by the FL tag corresponding to their name. Alternatively, you can view only Full Load objects in your Pipeline by selecting Full Load from the Filter ( ) menu.

Perform the following steps to set a custom ingestion frequency for Full Load objects:

1. In the Pipelines Detailed View, click the More ( ) icon to open the Pipeline’s Action menu and click Change Schedule.

   

2. In the Change the Pipeline Ingestion Schedule pop-up window, select the ingestion frequency for the Full Load objects as per your requirements. You can select Custom and define the ingestion frequency by specifying an integer value in hours.

   

3. Click SCHEDULE.

The updated schedule is applied immediately.

Note: The following image displays the frequencies suggested by Hevo for teams created before Release 2.21:

Handling Deleted Objects

Snapchat Ads APIs allow performing a soft delete of records. For the deleted records, Hevo sets the deleted column to True in the ingested data and the Destination.

Hevo tracks the deleted Events through the metadata column, deleted and replicates that information for the following objects:

Object Name	Event Type Tracked
ADS	updated
AD SQUADS	deleted
CAMPAIGNS	deleted

Note: As Hevo also replicates the deleted data, you might see more Events in your Destination than in the Source.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

---

Data Model

Hevo fetches both objects and reports from your specified ads account. Reports provide metrics around your users, their interaction related details, and the performance of your Ads.

Objects

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Account	Contains the details of the Snapchat Ads account.
Ads	Contains information required to display an ad per ads squad.
Ad Squads	Contains information of ad squads associated with an ad campaign.
Audience Segments	Contains the list of created audience segments.
Campaigns	Contains the details of the ad campaigns per ad account.
Creatives	Contains the details of creatives owned by an ad account.
Funding Sources	Contains information about the configured funding sources responsible to pay for the ad activity within an ad account of an organization.
Media	Contains the list of created audience segments.
Organizations	Contains the organization details of the user associated with the Snapchat Ads account.
Snap Pixels	Contains the details of snap pixels associated with the Snapchat ads account.

Reports

The following reports are replicated as tables in the Destination when you run the Pipeline:

• Ad Reports

• Ad Squad Reports

• Campaign Reports

Ad Reports

The Ad reports include the following reports:

• AD_HOURLY_REPORT

• AD_DAILY_REPORT

• AD_GEO_COUNTRY_DAILY_REPORT

• AD_GEO_REGION_DAILY_REPORT

• AD_GEO_DMA_DAILY_REPORT

• AD_INTEREST_DAILY_REPORT

• AD_DEVICE_OS_DAILY_REPORT

• AD_DEVICE_MAKE_DAILY_REPORT

• AD_DEMOGRAPHIC_DAILY_REPORT

• AD_UNIQUE_IMPRESSION_DAILY_REPORT

Ad Squad Reports

The Ad Squad reports include the following reports:

• AD_SQUAD_HOURLY_REPORT

• AD_SQUAD_DAILY_REPORT

• AD_SQUAD_GEO_COUNTRY_DAILY_REPORT

• AD_SQUAD_GEO_REGION_DAILY_REPORT

• AD_SQUAD_GEO_DMA_DAILY_REPORT

• AD_SQUAD_DEVICE_OS_DAILY_REPORT

• AD_SQUAD_DEVICE_MAKE_DAILY_REPORT

• AD_SQUAD_DEMOGRAPHIC_DAILY_REPORT

• AD_SQUAD_UNIQUE_IMPRESSION_DAILY_REPORT

Campaign Reports

The Campaign reports include the following reports:

• CAMPAIGN_DAILY_REPORT

• CAMPAIGN_HOURLY_REPORT

• CAMPAIGN_GEO_COUNTRY_DAILY_REPORT

• CAMPAIGN_GEO_REGION_DAILY_REPORT

• CAMPAIGN_GEO_DMA_DAILY_REPORT

• CAMPAIGN_INTEREST_DAILY_REPORT

• CAMPAIGN_DEVICE_OS_DAILY_REPORT

• CAMPAIGN_DEVICE_MAKE_DAILY_REPORT

• CAMPAIGN_DEMOGRAPHIC_DAILY_REPORT

• CAMPAIGN_UNIQUE_IMPRESSION_DAILY_REPORT