where are the campaign view status data stored?

I’m looking into where I can find the data found at the view campaign status. Specifically the Campaign Response Activity.

As I want to get the number of recipients that haven’t opened the emails.

Went into phpMyAdmin, searched for “campaign” in tables list…

It’s called

campaign_trkrs

We only have this columns in the table:

| id | name | date_entered | date_modified | modified_user_id | created_by| deleted | assigned_user_id | tracker_key | tracker_count | refer_url | tracker_text | start_date | end_date | status | impressions | currency_id | budget | expected_cost | actual_cost | expected_revenue | campaign_type | objective | content | frequency |

And to be honest I don’t really understand the data stored :slight_smile:

Sorry, my mistake, it’s “campaign_log”

1 Like