Identify each analytical query
A query identifier lets the service request cancellation of a specific ClickHouse query.
Attribution and duplicate-traffic reports
Reports for advertising impressions, conversions, attribution and duplicate traffic.
Project overview
What the service does
An advertising analytics platform that combines impression and conversion records and prepares attribution, overlap and duplicate-traffic reports. If a ClickHouse query times out, the service cancels it and checks that it has stopped before retrying. Reports and exports have separate concurrency limits.
Analysts need to run attribution and duplicate-traffic reports on large datasets without letting long queries block other work.
Who uses it
Advertising analysts and operations teams working with event data and attribution reports.
Input
- Impression and conversion event records.
- Configured attribution windows and report filters.
- Date, source and campaign selections for an analysis.
Output
- Attribution, overlap and duplicate reports.
- Charts and detailed event data.
- CSV or gzip files with report results.
01 / How the service works
Report generation
Report generation
- INPUTImpressions and conversions
Choose period, source and campaigns
- PROCESSRun ClickHouse analysis
Attribution, overlap and duplicate traffic
- CHECKControl long queries
Limit concurrency; cancel before retry
- RESULTView or export results
Charts, detailed rows, CSV and gzip
03 / Implementation details
Engineering decisions
Wait for cancellation before retrying
The service confirms that the timed-out query has stopped before starting another one.
Limit concurrent reports and exports
Separate limits control how many analytical queries and file exports can run at once.
Software development for business
Have a project in mind?
Tell me what the application should do, how the team works today and which requirements or deadlines matter.