Impact

Prerequisites

To connect Impact to Fivetran, you need an Impact account.
You need admin access to your brand / advertiser account in Impact, so you can create an API token.

🚧
Set up your API token before you connect
Impact uses scoped API tokens. If the token does not have read access to every table Prescient syncs — or if it was created in a partner account rather than your brand account — the connection will test successfully at first, then drop and ask you to re-authorize.
To avoid this, create the token as described below before you start the connection in Prescient.

Setup Instructions

Switch to your brand account. In Impact, click the account switcher (top left) and select your brand / advertiser account, not a partner account.
Create a new token. Go to Settings → Technical → API → Access Tokens and click Create Access Token.
1. Token name: Prescient
2. API Version: 14 (2022-10-12)
Check the account type before selecting scopes. On the scopes screen, look at the API paths. They should start with /Advertisers/.
1. If they start with /Mediapartners/, you are in a partner account. Stop and switch to your brand account first, otherwise it will fail again.
Select the scopes (GET only). Open each section and tick only the Get rows for: Campaigns, Actions, Accounts, ActionInquiries, Ads, Contacts, Contracts, Deals, ExceptionLists, Invoices, Notes, MediaPartners (Partners), MediaPartnerGroups (Partner Groups), PromoCodes, TrackingValueRequests and Tasks.
1. If any of these also appear under Supported Legacy APIs, tick the Get rows there too.
2. Leave all Post, Put and Delete rows unticked.
3. Click Create.
Copy the new credentials. Open the new Prescient token and go to the Credentials tab. Copy the Account SID (it starts with "IR") and the Auth Token.
1. These are new and specific to this token, so please do not reuse the old ones.
Reconnect in Prescient. Open the Impact connector, click Re-authorize / Edit, and clear the old values.
1. Authentication type: Basic
2. Paste the new Account SID and Auth Token, then click Save & Test.

📘
Note
Impact only supports a single advertising account. To model spend from multiple different Impact accounts, ask your CSM about setting up a Google Sheets Impact connector.

📘
Note
The General Connector Creation Guide asks you not to change a connector's preset permissions. Impact is the exception: its token has no scopes until you enable them, so follow the Get list above.