Report Builder IAS - Agency account
Introduction
In this article it is described regarding auto-report set up from IAS (Integral Ad Sience) vereficator. Both reports are needed in case to be able to proceed with needed optimisation of campaign. Which is crucial for reaching good campaign KPIs and troubleshoot on data descripency that usually appears due to different methodology of measurement between DSP and 3rd party verification.
Total report per campaign - this report is needed for the evaluation of campaign performance, and troubleshoot discrepancy of measured stats. Report should include campaign or/and placement as main segment split. It also should include all important KPIs and be established for period from the start till the end day of campaign.
Report per domains/apps - this report is needed for KPIs evaluation across different sites/apps and helps to optimise campaign for reaching better KPIs by excluding site and apps with lower performance. This report should include dates, campaigns and show last 30 days stats.
Keep in mind that it is possible to prepare auto-report only when campaigns measured some ads. Otherwise, you will not able to select needed campaigns for your report. Therefore, Plan to prepare auto-report on the 3rd day after campaigns started, as it takes up to 48h for IAS to collect data on their side.
Total campaign report step-by-step set up guide
1. First of all open your IAS account and go to "Build New Report" menu
3. In Report Type section you will need to create 4 different sheets as it is shown on the screen below. You can name sheets accordingly "Daily Campaigns", "Total Campaigns", "Daily Placements", "Total Placements". Each sheet will be presented in same xls file which will be generated automatically. Start with one sheet creation, select "Performance Report" and scroll down till "Dimensions" section.
Tip 1: Create 1 sheet at first, for example "Daily Campaigns". And move to next steps. Later on the sheet might be copied so it will simplify process of creation as you will not need go from the scratch on all next steps for each separate sheet.
Tip 2: If you are using separate tracker per each placement, then create reports per placements as well, so it will be 4 sheets in total. However if you are measuring performance per campaign level, it would be enough to create only 2 sheets which is "Daily campaigns" and "Total campaigns"
4. For the sheet "Daily Campaigns" for Dimensions section you need to select "Media Partners", "Campaigns", "Dates". Select dimensions in same order.
Also once dimensions are selected specify media partners (it should be Eskimi), also specify campaigns (you need to select campaigns that you want to include for reporting", and as last step select "by day" for Date dimension.
In this case IAS will generate report per selected campaign with daily split. Once this done scroll down till the section "Minimum Total Tracked Ads Filter".
5. In the "minimum total tracked ads filter" section you need to select "all tracked ads". In this case all measured impressions for dimensions you selected above will be presented in the report. Once selected you need scroll down till "Metric" section
6. In "Metrics" section you need to enable metrics which are important to for campaign analysis. Below you can see our suggestions regarding metrics that should be selected. Please include them to any report you are creating for Eskimi team.
In case you would like to know definition of the metrics, please refer to article prepared by IAS: "Advertise Metrics Clossary"
 |
 |
 |
 |
 |
|
 |
7. At this step you can move back to the 3rd point and duplicate the sheet, in this case all settings will be already preselected and will not require additional selection from scratch. Once new sheets are duplicated, you need to rename them accordingly.
8. After duplicating sheets open the one you want to adjust 1 by 1. At this step you need to change dimensions per each sheet.
The sheet called "Total Camapaigns" should have selected dimensions as on screen below. Once dimension selected move to another sheet. Keep in mind that you also need to select media partner, and campaigns that you want to include in the report.
9. In case you set up pixel per each creative (a.k. placement) you can add additional report per placement segment. In this case the sheet called "Daily Placements" should consist dimensions as on screen below. Keep in mind that you also need to select media partner, and campaigns that you want to include in the report.
10. Open sheet "Total placements" and select following dimensions. Keep in mind that you also need to select media partner, and campaigns that you want to include in the report.
11. Once all set up is done scroll the page till the end and enter email details and frequency for the auto reporting. It is also possible to enter multiple emails who need to get the settled up report.
Email Details - enter "adops@eskmi.com"
Frequency - select "daily" and establish a period from the campaign first day till the end of last campaign.
12. Once everything is done the button "save and run" will be active, so you need to press on it to activate the report.
13. If everything set up correctly, the receiver(s) will start getting daily report from IAS. The example of IAS email presented below.
Site/Apps report step-by-step set up guide
0. If you already set up Total campaign report, you can go to Custom Report menu and duplicate the settings from previously created report. In this case most of the settings will be pre-selected and will require slight adjustments (you can follow this guide further to see the adjustment that need to be done). Otherwise you will need to create the report from scratch, where you can follow step-by-step process described below.
1. First of all open your IAS account and go to "Build New Report" menu
3. In Report Type section you will need to create 2 different sheets as it is shown on the screen below. You can name sheets accordingly "Domains" and "Apps". Each sheet will be presented in same xls file which will be generated automatically. Start with one sheet creation, select "Performance Report" and scroll down till "Dimensions" section.
Tip 1: Create 1 sheet at first, for example "Domains". And move to next steps. Later on the sheet might be copied so it will simplify process of creation as you will not need go from the scratch on all next steps for each separate sheet.
4. For the sheet "Domains" for Dimensions section you need to select "Media Partners", "Campaigns", "Domains" and "Dates". Select dimensions in same order.
Also once dimensions are selected specify media partners (it should be Eskimi), also specify campaigns (you need to select campaigns that you want to include for reporting", and as last step select "by day" for Date dimension.
In this case IAS will generate report per domains that appeared for selected campaigns with a daily split. Once this done scroll down till the section "Minimum Total Tracked Ads Filter".
5. In the "minimum total tracked ads filter" section you need to select "all tracked ads". In this case all measured impressions for dimensions you selected above will be presented in the report. Once selected you need scroll down till "Metric" section
6. In "Metrics" section you need to enable metrics which are important to for campaign analysis. Below you can see our suggestions regarding metrics that should be selected. Please include them to any report you are creating for Eskimi team.
In case you would like to know definition of the metrics, please refer to article prepared by IAS: "Advertise Metrics Clossary"
|
|
|
|
|
|
|
7. At this step you can move back to the 3rd point and duplicate the sheet, in this case all settings will be already preselected and will not require additional selection from scratch. Once new sheets are duplicated, you need to rename them accordingly.
8. After duplicating sheets open the one you want to adjust 1 by 1. At this step you need to change dimensions per each sheet.
The sheet called "Apps" should have selected dimensions as on screen below. Basically you need to unselect "domains" and select "apps" here. Once dimension selected scroll the page down till "Dilivery" section.
11. Once all set up is done scroll the page till the end and enter email details and frequency for the auto reporting. It is also possible to enter multiple emails who need to get the settled up report.
Email Details - enter "adops@eskmi.com"
Frequency - select "daily" and establish a period from the campaign first day till the end of last campaign.
12. Once everything is done the button "save and run" will be active, so you need to press on it to activate the report.
13. If everything set up correctly, the receiver(s) will start getting daily report from IAS. The example of IAS email presented below.
Future campaigns
If you reached to this stage it means that your both reports are set up. The only question might remains is how to be with future campaigns. In this case there are several options:
Option One
If you are planning future campaigns to be tracked in IAS as well, you can simple edit previously created report by selecting new campaigns in the "Dimension" section and adjusting the Delivery period accordingly. Keep in mind that this should be done for both reports and for each sheet separately.
Option Two
You can also create new report by simple coping from previously created. For new report you need to select new campaigns that will be tracked with IAS as well. In this case, report setting require only several adjustments in "Dimension" and "Delivery" sections. Keep in mind that this should be done for both reports and for each sheep accordingly.