When you share media data with Paramark, impressions are the preferred volume signal for many digital channels. But not every channel has clean impression reporting, and some channels are better represented by a different metric. This article explains what to send us when impressions are unavailable, incomplete, or not the best fit for the channel.

What Paramark needs from each channel

For every channel, we need a time-varying input that helps the model understand marketing pressure over time. In many cases that input is impressions. In other cases, it may be spend, sends, mailed pieces, leads, calls, or another operational volume metric.

As a rule of thumb:

• Use impressions when the platform reports them directly and they are stable enough to represent delivery.

• Use spend when impression reporting is estimated, inconsistent, or not available.

• Use a channel-specific count metric when the channel is operationally measured another way, such as emails sent, mail pieces, inbound calls, or leads delivered.

Recommended fallback metrics by channel type

• Email: send emails sent if impression reporting is not available.

• Direct mail: send pieces mailed.

• Lead generation / data lead vendors: send leads delivered when that is the operational unit of delivery.

• Billboards / OOH: send spend unless you have a clearly documented, consistent impression methodology you want us to use.

• Linear TV / local linear: send spend if reported impressions are estimated or incomplete.

• Affiliate, sponsorships, and placement-based channels: send spend or the primary delivery count for the channel.

• Call-driven channels: if the channel is measured operationally through calls, send inbound call counts in addition to spend where available.

• Social / paid social / Meta: send impressions when available; if they are missing for a period, send the data you do have and flag the gap so we can determine the cleanest fallback.

If you are unsure which metric best represents a specific channel, include the channel name and the fields you have available. We can advise on the best modeling input.

Common examples of acceptable fallback inputs

• Affiliate: if impression reporting is unavailable, a manual spend sheet is an acceptable starting point.

• Direct mail: use mailed pieces as the primary volume metric; if your team also has impressions from a separate analytics workflow, include them as supporting context rather than waiting to send nothing.

• Influencer, TV, or other manually tracked channels: a Google Sheet or similar manual source is acceptable if it clearly states timing, spend, and any available delivery counts.

• Organic social: keep paid and organic delivery separated. If a source blends paid impressions into an organic total, send the cleanest split you have and clearly note any manual adjustment used to remove paid activity.

When spend is the right fallback, a simple spreadsheet is fine

For channels like OOH, print, sponsorships, podcasts, field marketing, or other offline buys, it is completely fine to start by sending a static spreadsheet instead of building a live connector on day one.

In many onboarding workflows, the fastest path is:

1. send a static historical file first so Paramark can review the structure and begin ingesting the data,

2. confirm the row grain and channel definitions with your Growth Advisor, then

3. decide whether to keep updating that same sheet on an ongoing basis or move the data into a warehouse or other long-term source later.

You do not need to wait for a perfect automated pipeline before sharing useful budget or spend data.

If Paramark is doing an initial feasibility check, a simple weekly or monthly historical sheet is usually enough to get started. A practical first pass often includes your core KPI series plus channel-level spend, even if impressions are only available for some channels or not available yet at all. In that case, send the cleanest spend history you have, and note which channels may get a fuller volume metric later.

What to include in a manual spend or budget file

If you are sending a spreadsheet for manually tracked channels, include as many of these fields as you can:

• date, or a clear start and end date if the spend applies to a flight

• channel (for example: OOH, podcast, print, events, sponsorships)

• sub-channel or campaign name if you want separate breakouts later

• spend

• currency

• geography when relevant (state, DMA, city, country, region, or market)

• volume metric if one exists in addition to spend, such as mailed pieces, calls, leads delivered, or estimated impressions

• notes for caveats like partial history, blended invoices, or methodology changes

If the file is really a planning or budget document, that is still workable as long as it clearly distinguishes planned values from actual delivered spend. When both exist, label them separately rather than combining them into one spend column.

How to structure the file

To keep the ingest process smooth:

• Keep channel names consistent over time.

• Use one column for the selected volume metric for that channel.

• If different channels use different units, document that clearly in the file or handoff note.

• Flag any channels with partial history, missing periods, or methodology changes.

• If a channel changed measurement logic over time, note when that change happened.

• If rows may be added over time, keep the sheet tab and column names stable so the file can keep working as an ongoing source.

Common row structures that work well:

• one row per day and channel for daily spend data

• one row per month and channel for monthly summaries such as events or sponsorships

• one row per flight with start date, end date, and totals for channels like OOH or print when daily delivery is not available

Static first, dynamic later

If your team is asking whether Paramark needs a one-time static file or a continuously updated spreadsheet, the answer is usually: start with whatever is easiest, then standardize once the structure is validated.

A static file is often the best first step when:

• you are still deciding which channels belong in scope,

• you are cleaning up historical budget data,

• you want Paramark to review the format before you operationalize the process, or

• you are still determining who owns the recurring updates.

An ongoing spreadsheet becomes useful when the channel will continue to refresh and someone on your team can reliably maintain it at the agreed cadence.

What to do when a channel is incomplete

It is normal for some channels to be missing data on the first pass. If a channel is still in progress, send what is available and note:

• which metric is still missing,

• which dates are affected, and

• whether the missing field will be backfilled later.

This helps us start validating the rest of the dataset while keeping a clear record of what still needs to be added.

When to ask Paramark for guidance

Please flag a channel for review if:

• impressions are estimated rather than directly measured,

• the channel can be represented by more than one plausible volume metric,

• the channel naming or grouping changed over time,

• you are combining several delivery types into one reporting bucket, or

• you are unsure whether a budget spreadsheet reflects planned spend, actual delivered spend, or both.

We can help decide whether the best input is impressions, spend, or another delivery metric before the data is finalized.

Common onboarding examples when channel data is still in progress

It is common for onboarding teams to have a few channels that are not fully ready at the same time. The best approach is to send the cleanest interim metric available for each channel, clearly note what is still outstanding, and backfill missing pieces later if needed.

• Affiliate: if complete impression history is not available yet, start with manual spend or the primary delivery metric available from the partner or network. Note whether a fuller export will be backfilled later.

• Direct mail: if impressions are not readily available, send pieces mailed or the closest operational delivery count, plus spend when available.

• Email: if the team is still finalizing category allocations, share the current delivery file and clearly document which categories or segments may be reclassified later.

• Organic social: if the source mixes paid and organic delivery, it is better to share a clean organic metric after removing paid volume than to send a blended series that combines both.

• Influencer: if impressions are tracked in a spreadsheet rather than a platform connector, a recurring sheet is acceptable as long as the format stays stable.

• TV: if the channel is being refreshed from a spreadsheet or another manual source, re-share the latest file and note whether it replaces prior numbers.

What matters most is not that every channel is perfect on day one, but that each one has a clear interim source, metric definition, and owner for follow-up.

Podcasts, YouTube sponsorships, and other placement-based media

For channels like podcast episodes, creator sponsorships, YouTube sponsored videos, newsletter sponsorships, and similar buys, it is usually not necessary to force the data into a daily breakdown if the source does not naturally report that way.

What matters most is that we receive a consistent time-varying signal and enough context to understand when the media ran. In priority order, the most helpful formats are:

1. Daily or weekly data with spend and impressions when the partner or platform reports it. This is the strongest option because it gives the model more variation over time.

2. Flight-level or placement-level data when the buy is naturally reported by episode, sponsored video, creator post, or campaign window. In that case, include the start date, end date, channel or placement name, and total spend.

3. Reach or impressions as the accompanying volume signal when available. If both are available, send both and we will advise which is cleaner. If only one is available, that is still useful.

For many offline or semi-manual channels, spend plus timing information is enough to get started. A weekly breakdown is helpful when you have it, but a clear placement window is usually more important than manufacturing artificial daily rows that do not reflect how the buy was actually delivered.

If the same channel will recur every month, an ongoing spreadsheet is fine as long as the structure stays stable. If this is a one-time historical backfill, a static file is also fine for the first pass.

A good manual file for podcast or sponsored-video activity should include:

• channel (for example: Podcast, YouTube Sponsorships, Creator Partnerships)

• placement name (show, episode, creator, video, campaign, or vendor)

• start date and end date

• spend and currency

• impressions or reach, if reported

• notes for any caveats, such as estimated delivery, bundled placements, or unclear timing

If you are unsure whether a specific sponsorship should be modeled from spend, impressions, or reach, send the fields you have and flag the ambiguity. We can help choose the cleanest input before the data is finalized.