Get managed campaign reports
Overview
This article summarizes the options you have to get reporting data about Equativ managed campaigns.
Option #1 – Get .xls / .csv / Excel reporting data by e-mail
The most basic option is to receive reporting data about managed campaigns by e-mail with a .xls / .csv / Excel file attachment. Reach out to your contact at Equativ and do not forget to indicate:
- the time the report needs to cover (e. g. last week)
- the KPIs that should be included
- the frequency based on which you need to receive your report (report sent daily/weekly etc.)
Option #2 – Get reporting data on SFTP server
You can get reporting data dropped by Equativ on a SFTP server of your choosing. Make sure you send to your contact at Equativ:
- Host
- User name
- Password
- Port
- Timezone
Do not forget to indicate:
- the time the report needs to cover (e. g. last week)
- the KPIs
- the frequency based on which you need to receive your report (report sent daily/weekly etc.)
Option #3 – Get reporting data through Snowflake connection
Prerequisites
To qualify for Option #3, your data tool has to be compatible with Snowflake. Compatible tools include Looker Studio, TapClicks, Adverity, Tableau and many more - see complete list here. If your tool is not compatible, use options #1 or #2, as explained above.
Setup for Looker Studio
To set up the connection of your Looker Studio with Equativ data, follow the steps below.
Step #1 — Create a new “Equativ” Data source
Step #2 — Search for “Snowflake” and authorize the connection
Step #3 — Log in to your Snowflake account
You will receive credentials from your Equativ account manager.
Step #4 — Fill in fields
Input for each field:
| Field name | Input |
|---|---|
| Choose database (Required) | EQUATIV_DATASHARE |
| Choose role (Required) | ROLE_EQUATIV_DATASHARE_DYNADMIC_READER |
| Choose schema (Required) | EQUATIV_CLIENT_REPORTS |
| Choose warehouse (Required) | WAREHOUSE_DATASHARING |
| Enter your Snowflake account URL (Required) | smartadserver.eu-west-1.snowflakecomputing.com |
| Enter your SQL query (Required) | SELECT * FROM "EQUATIV_DATASHARE"."EQUATIV_CLIENT_REPORTS"."CAMPAIGN_ACTIVITY" |
Dimensions and metrics
The reporting data available through the Snowflake connection consists in a predefined set of dimensions and metrics which cannot be customized. Reporting data is available for the last 180 days and can be extended upon request. The time zone used is UTC.
Available metrics
| Metric name | Metric name in BKO user interface |
|---|---|
| CLICK | CLICK |
| COMPANION_CLICK | CLICKS COMPANIONS |
| COMPANION_IMPRESSION | IMP COMPANIONS |
| COMPLETEVIEW | COMPLETE VIEWS |
| DISCOUNT (€) | - |
| DISCOUNT_AGENCY_CURRENCY | - |
| FIRST_QUARTILE | FIRST QUARTILE |
| IAS_MESURABLE_IMP | MESURABLE IMPRESSIONS |
| IAS_VIEWABLE_IMP | VIEWABLE IMPRESSIONS |
| IMPRESSION | IMPRESSION |
| MID_POINT | MID POINT |
| MOAT_MESURABLE_IMP | MESURABLE IMPRESSIONS |
| MOAT_VIEWABLE_IMP | VIEWABLE IMPRESSIONS |
| SPENDS (€) | SPENDS |
| SPENDS_AGENCY_CURRENCY | - |
| SPENDS_NET (€) | SPENDS NET |
| SPENDS_NET_AGENCY_CURRENCY | - |
| STORY_COMPLETE | STORY COMPLETE |
| STORY_INTERACTION | IMPRESSIONS WITH INTERACTIONS |
| STORY_START | STORY START |
| STORY_VIEW_SIX_SECONDS | STORY VIEW 6s |
| STORY_VIEW_THREE_SECONDS | STORY VIEW |
| THIRD_QUARTILE | THIRD QUARTILE |
| VIDEO_START | START |
| VIEWABLE_COMPLETEVIEW | VIEWABLE COMPLETE VIEWS |
| YOUTUBE_BUMPER | BUMPER ADS |
| YOUTUBE_CONVERSION | ACTIONS / CONVERSIONS |
| YOUTUBE_DISCOVERY | YOUTUBE TRUEVIEW |
| YOUTUBE_NON_SKIPPABLE_INSTREAM | IMPRESSION |
| YOUTUBE_SKIPPABLE_INSTREAM | IMPRESSION |
| YOUTUBE_TRUEVIEW | YOUTUBE TRUEVIEW |
| YOUTUBE_VIEWABILITY_IMP | YT VWB IMPRESSIONS |
Available dimensions
- ADVERTISER_NAME
- CAMPAIGN_NAME
- CAMPAIGN_ID
- CAMPAIGN_IO
- FORMAT_NAME
- PRODUCT_NAME
- DAY
- DELIVERY_COUNTRY_ID
- AGENCY_CURRENCY
- CREATIVE_PLACEMENT