Collecting data from Celtra

This guide explains how to collect data from Celtra. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.

Introduction

For a list of the fields that you can collect from Celtra, see Celtra.

Limitations

Collecting data from Celtra comes with the following limitations:

  • Celtra can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

  • Certain dimensions and metrics are not compatible with each other. To check which combination of fields is valid, check the dimensions and metrics compatibility in the Celtra user interface.

Creating a datastream to collect data from Celtra

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from Celtra.

Configuration: Choose the data you want to collect from Celtra

To choose what data to collect and customize the Celtra datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Metrics and Dimensions, change the list of fields that you want to see in your data extract.

  1. In Custom dimensions and Custom filters, enter the custom dimensions or custom filters to apply to the data collection. For more information on custom dimensions and custom filters, see Advanced Celtra tips.

  2. In Filters account and Filters campaign, select the accounts and campaigns on which to collect data. If you cannot see any accounts or campaigns, return to the datastream configuration page once the datastream is created and try again.

For information on configuring other Celtra fields, see Advanced Celtra tips.

What's next?

Advanced Celtra tips

Configuring data collection from Celtra

In the Settings tab of your Celtra datastream overview, you can configure a number of additional settings:

Custom dimension

Enter a custom dimension on which to collect data. A custom dimension must be entered in the following format:

custom{Type}Attributes[{keyValue}]

Replace the following:

  • Replace {type} with either Account, Creative, Placement, or Campaign.

  • Replace {keyValue} with the value of the custom dimension.

For example, enter customCampaignAttributes[region] to collect data on the dimension value region from the custom dimension customCampaignAttribute.

To collect data on multiple custom dimensions, enter each custom dimension on a new line.

For more information on custom dimensions, see the Celtra documentation.

Custom filter

Enter a custom filter to collect only certain data. For more information on the filter format, the different operators and an example of the custom filter, see Configuring custom filters for Celtra.

To use multiple custom filters, enter each custom filter on a new line.

Configuring custom filters for Celtra

To use a custom filter when collecting data from Celtra, enter the custom filter in the following format:

filters.{dimension}.{operator}={value}

Replace the following:

  • Replace {dimension} with the name of the dimension or metric for which to filter your data.

  • Replace {operator} with the operator to use. The following operators are valid:

    • in filters for values that are contained in the column specified in {dimension} (this operator is applied by default).

    • nin filters for values that are not contained in the column specified in {dimension}.

    • lt filters for values that are less than the number specified in {value}.

    • lte filters for values that are less than or equal to the number specified in {value}.

    • gt filters for values that are greater than the number specified in {value}.

    • gte filters for values that are greater than or equal to the number specified in {value}.

  • Replace {value} with the value used to filter data.

For example, to collect data on values in the clicksmetric that are greater than 1,000, enter filters.clicks.gt=1000.

Operator limitations

The operators in and nin accept a list of comma-separated values. For example to collect data on two different campaign names, which have the dimension values campaign1 and campaign2, enter the custom filter filters.campaignName.in=campaign1, campaign2.

The operators in and nin cannot be used to filter metric values.

The following operators only accept a single value. They can be used to filter dimension or metric values.

  • lt

  • lte

  • gt

  • gte