Awin + Querri
Querri reads the transactions and campaign performance in your Awin advertiser account, so you can ask which publishers drive sales, what commission really costs and how affiliate orders line up with your own records.
Querri only reads from Awin and never changes your records. SOC 2 Type II, HIPAA and ISO 27001:2022 certified, and your data is never used to train a model.
What you can answer
Commission, network fees and sale amounts sit on separate columns of every transaction, and the answer changes depending on which commission statuses you count. Write the rule once, such as approved commissions only, and Querri applies it to every cost-per-sale answer.
Facts & rulesSpotting this means splitting transactions by voucher use and new versus returning customers, publisher by publisher. Querri does that split from Awin's own fields and keeps it on a dashboard.
DashboardsAffiliate transactions and booked orders are kept in different systems, so returns and cancellations slip through. Querri matches Awin's order reference against sales orders in NetSuite and lists the ones that disagree.
NetSuiteWhat comes over
Querri copies this data into your Library on a schedule, next to every other system you connect, so one question can draw on all of it.
Each sync reloads the data you picked, daily, weekly or monthly, or whenever you run it by hand.
Querri reads from Awin and never creates, edits or deletes anything there. Every answer runs on Querri's own copy.
Querri's own sharing and row-level access decide who sees which rows, in chat, dashboards, Claude, ChatGPT and the API.
How to connect
Say "connect Awin" or pick it from the connector catalog.
Enter your Awin advertiser ID and API key in the secure form, which the Connector Agent never sees. You also set a start date, a number of lookback days, and the window each request covers, which defaults to 400 days.
Pick the data you want and how often it refreshes, then approve the first load.
The data lands in your Library, ready for chat, dashboards and scheduled reports.
FAQ
Ask the Connector Agent to connect Awin and enter your advertiser ID and API key in the secure form. Then set a start date, the lookback days and the request window, or keep the 400-day default for the window.
Transactions and campaign performance. Each transaction carries the publisher, sale and commission amounts, commission status, network fee, order reference, voucher code, click and transaction dates and devices, and the customer acquisition flag.
On the schedule you pick: daily, weekly or monthly, or by hand whenever you need it. Every run rereads Awin transactions and campaign performance from your start date, so commission status changes since the last sync show up after the next one.
Yes. Awin marks each transaction with a customer acquisition value, so Querri can split sales and commission between new and returning customers for every publisher and show where commission buys growth.
No. Querri only reads from Awin. It never creates, edits or deletes records there, and every answer runs on Querri's own copy of the data.
Yes. Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified, credentials are stored encrypted, and your data is never used to train a model.
Keep exploring
Contacts, campaigns, deals, lists and forms from ActiveCampaign.
Links, clicks, campaigns, channels and QR codes from Bitly.
Contacts, email and SMS campaigns, companies and deals from Brevo.
Clients, lists, segments, campaigns and templates from Campaign Monitor.
Connect Awin, add the rest of your systems, and get answers your whole team can check.