The Event Log Query Service lets you bring your AdButler event logs into one place and report on them any way you like, without downloading and unzipping daily files yourself. You will learn:

1. How to sign in.
2. How to import your logs.
3. How to check what you have imported.
4. How to build a report.
5. How to share and export a report.
6. How to delete imported data.

Signing in

1. Go to https://elqs.adbutler.com.
2. Paste your AdButler API key into the Paste your key field.
3. Click Connect.

Your account name and ID are shown at the top right and in the left menu, so you can always see which account you are working in. To sign out, click your account name at the top right, then click Sign out.

The three pages

The left menu has three pages:

• Reports: filter and group your event logs any way you like.
• Your Data: shows what you have imported and what is available from AdButler.
• Import Logs: brings more days of logs in from AdButler.

Importing your logs

Nothing can be reported on until it has been imported. The first time you sign in, start here.

Step 1: Choose what to import

1. Click Import Logs in the left menu, or Import data on the Your Data page.
2. Under What do you want to report on?, pick one or both log types:

• Ads shown (Impressions): every time an ad was served. Use it to see which zones, sites, countries and devices delivered the most ads, and how delivery changed day to day.
• Unfilled requests (Blanks): every time a page asked for an ad and none was shown. Use it to find your fill rate, and which campaign or placement rules filtered ads out.

3. Click Next.

Step 2: Choose the days

1. Under Which days do you want?, choose Last 7 days, Last 30 days, Last 90 days or Everything available.
2. To pick your own range, click Custom, or click one day on the calendar and then another. Click a month's name to pick the whole month.
3. Click Next.

Step 3: Review and start

1. Under Ready to import, check the summary: how many days will be fetched from AdButler, how many you already have and will be skipped, and the estimated size.
2. Click Start import.

The import runs in the background, and you can keep using the service while it runs. Progress is shown on the page and in the status pill in the top bar. Time depends on your traffic, but most days take under a minute each. When it finishes, click See your first report.

Checking what you have imported

Click Your Data in the left menu.

• Rows you can report on: the total number of events imported for your account.
• Ready to import: days AdButler has available that you have not imported yet.
• Calendar: each day is shaded by how much has been imported. Hover over a day for details. Use Ads shown and Unfilled requests at the top right of the calendar to switch between log types. Click Show earlier months to look further back.
• Import history: every import you have run, newest first, with its status.

Building a report

Click Reports in the left menu.

Start from a question

The top of the page lists ready-made reports, such as Traffic by day, Impressions by zone, Fill rate by device, Why ads weren't served, Top countries and Top sites. Click one to fill in the report builder, then click Run report.

Build your own

1. Metrics: pick the numbers you want to see, such as Impressions, Requests, Blanks or Fill rate.
2. From and To: pick the days to report on, or click Last 7 days, Last 30 days, Last 90 days, Month to date or Last 6 months. Only days you have imported return results.
3. Filters: click Add, choose a field, then choose is, is not, is any of or contains and enter a value. For is any of, separate the values with commas. With no filters, every event in the date range is counted.
4. Group by: click Add and choose how to break the numbers down. Each group-by adds a column to the result.
5. Click Run report, or press Ctrl + Enter (Cmd + Enter on a Mac).

You can group by:

• Time: day or hour of day.
• Where it ran: zone, placement, channel, publisher, site or creative size.
• What ran: campaign, ad item or advertiser.
• Audience location: country, region, city or postal code.
• Audience device: device type, browser, operating system, manufacturer, device model, app or app version.
• Targeting: keywords and contextual categories, plus your own data keys and custom columns, using the names you send to AdButler.
• Unfilled requests only: the campaign or placement rule that filtered an ad out.

Reading the results

Results appear as a chart and a table, The numbers, next to the builder. Click any column heading in the table to sort by it.

The example below shows impressions and fill rate for traffic from Canada, grouped by zone and device type.

More options

Click the ... button next to Copy link to change these settings:

• Timezone: the timezone used for days and hours in the report. It defaults to your browser's timezone.
• Order by and Direction: which column the results are sorted by, and whether biggest or smallest comes first.
• Limit: the most rows the report returns. If there may be more rows than the limit, the report tells you. Raise the limit, or add a filter to narrow it down.

Sharing and exporting a report

• Download CSV: downloads the same rows as the table, for use in a spreadsheet.
• Copy link: copies a link that reopens this exact report. Anyone you share it with must sign in with an API key for the same account to see the results.
• Copy API call: under the ... button. Copies the report as a command for the Event Log Query API, so a developer can run the same report from their own systems.

Deleting imported data

You can delete days you have imported, for example to re-import them or to free up your account's space.

1. Click Your Data in the left menu.
2. Click Manage data, at the bottom of the page, to open it.
3. Choose the From and To days, and under Which data choose Both kinds, Impressions only or Blanks only.
4. Click Delete this data....
5. In the Delete imported data? dialog, click Delete the data.