ODBC Driver for Snapchat Ads

Build 23.0.8839


Lists all campaigns within a specified ad account.


The 本製品 will use the Snapchat Ads API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Id supports the following operator: =,IN
  • AccountId supports the following operators: =,IN; If specified, it will override the value of the AccountId connection property. Otherwise, if no value is specified, the 本製品 will try to get the first account from the list returned by the Accounts view.
The following queries are processed server side:
    SELECT * FROM Campaigns WHERE AccountId = '2e874d37-a1d5-4579-9f7c-331deb8082b8'
    SELECT * FROM Campaigns WHERE AccountId IN ('2e874d37-a1d5-4579-9f7c-331deb8082b8', '331deb8082b8-a1d5-4579-9f7c-2e874d37')
    SELECT * FROM Campaigns WHERE Id = '5f433224-28d2-40f8-982b-c353c67934cb'
    SELECT * FROM Campaigns WHERE Id IN ('5f433224-28d2-40f8-982b-c353c67934cb', 'c353c67934cb-5f433224-28d2-40f8-982b')


INSERT INTO Campaigns (Name, AccountId, Status, StartTime, RegulationsRestrictedDeliverySignals, MeasurementSpecIOSAppId, MeasurementSpecAndroidAppURL) VALUES ('Cool Campaign', '422588db-75f3-47d1-be3b-92e296d33f68', 'PAUSED', '2016-08-11 22:03:58.869', true, '1234', 'com.snapchatads.android')


UPDATE Campaigns SET Name = 'Cool Campaign (Updated)', RegulationsRestrictedDeliverySignals = false WHERE ID = '1ebd8b15-8100-4cbb-8ad1-04b538bbd043'


DELETE Campaigns WHERE ID = '1ebd8b15-8100-4cbb-8ad1-04b538bbd043'


Name Type ReadOnly References Description
Id [KEY] String True

Campaign ID.

AccountId String False


Ad Account ID.

DailyBudget Decimal False

Daily Spend Cap.

EndTime Datetime False

End time.

Name String False

Campaign name.

CreatedAt Datetime False

The creation date of the entity.

UpdatedAt Datetime False

The date when the entity was last updated.

StartTime Datetime False

Start time.

Status String False

Campaign status.

使用できる値は次のとおりです。ACTIVE, PAUSED

LifetimeSpendCap Decimal False

Lifetime spend cap for the campaign.

MeasurementSpecIOSAppId String False

The IOS app to be tracked for this campaign.

MeasurementSpecAndroidAppURL String False

The Android app to be tracked for this campaign.

Objective String False

Objective of the Campaign.


RegulationsRestrictedDeliverySignals Bool False

Required for Campaigns that run Ads for Credit, Housing, Employment (CHE).

RegulationsCandidateBallotInformation String False

The candidate / ballot field is optional, but may be required in certain states.

DeliveryStatus String True

Delivery status.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839